Consider the following un-normalized relational table on an online retail store orders and payments information:

An online retail store would like to create a database to keep track of its sales activities. Information recorded in the database supposed to include customer number that identifies each customer, customer’s first name, last name, unique order number of orders a customer made, the date when an order was made, unique product number of products included in orders, product description, sequence number listing the sequence when a product is included in each order as well as the quantity for each product made in each order. The retail store would also like to store the payment information such as a credit card number of credit card that was being charge to, payment date and the amount paid. The online retail store allows customer to pay using any one of the credit cards the customers own, as long as the credit card is valid.

A database designer created the following relational schema:

CUSTORDER(custNum, custFName, custLName, orderNum, orderDate, prodNum, prodDesc, itemNum, quantity, cCardNum, paymentDate, amountPaid)

Decompose the relational schema into the smallest number of relational schemas each one in forth normal form (4NF) and to explain or justify that each schema is in 4NF. To justify that the relational schemas obtained from the decomposition are in 4NF you must find all functional and multivalued dependencies valid in each relational schema, you must find the minimal keys, and then apply the definitions to support your justification. Note, that a relational schema is in 4NF when it is in BCNF and it does not have any nontrivial multivalued dependencies. It means, that first, you have to prove that a schema is in BCNF and later show that it has no nontrivial multivalued dependencies. Please keep in mind that the smallest number of 4NF relational schemas is expected

Task: The below table shows socio-economic data of two fictitious countries. From the perspective of a business considering the possibility of undertaking business in these countries, consider what the data could mean and present three conclusions. Each conclusion should compare both countries using at least two variables. You can relate each conclusion to any type of international business (eg. you can present a conclusion from the perspective of a business choosing a new export market, a business seeking an import source, a business choosing a location for FDI, etc). Recommended length for each conclusion: approximately 200 words.                                           (4 marks per conclusion)

A Lab question asks whether the relationship between atomic number and electronegativity is direct, log, or inverse. I am inclined to say that it is direct since electronegativity increases with atomic number; though my out of my various graphs, the one graphing atomic number vs. log of electronegativity has the best line of fit (highest R^2) so I want to say it has a log relationship. Is this correct?

In Chapter 28, you learned about the concept of comparative advantage. How does this principle apply to people/members in the church? In other words, you may consider that every individual within the Church community has a different/unique role (pastor, praise band leaders, server for meals, children’s ministry, etc) as gifted from God. How does the principle of comparative advantage relate to this situation? For you to receive full credit, please make sure you provide an accurate analysis based on the knowledge of comparative advantage to this given situation. Please do not refer to other sources, other than your textbook. (Due: Day 4(Thursday) by 11:59pm; word count: minimum 300 words).

(a) Compute the impedance of a series R-L-C circuit at angular frequencies of w1 = 1000 rad/s, w2 = 735 rad/s and w3 = 540 rad/s. Take =160 ohm, = 0.940 H and = 2.05 uF.

(b) Describe how the current amplitude varies as the angular frequency of the source is slowly reduced from 1000 to 540 .
a-Amplitude is always constant.
b-Amplitude decreases.
c-Amplitude increases.
d-First amplitude increases next it decreases.
e-First amplitude decreases next it increases.

(c) What is the phase angle of the source voltage with respect to the current when w = 1000 rad/s?

A passenger on a moving train walks at a speed of 1.40 m/s due north relative to the train. The passenger's speed with respect to the ground is 4.5 m/s at an angle of 30.0° west of north. What are the magnitude and direction of the velocity of the train relative to the ground?

• Name three technology/automated advances that you appreciate as a customer or a service provider. Explain what business uses each advancement and how it is helpful as a customer or employee.

A point charge +q is at the origin. A spherical Gaussian surface centered at the origin encloses +q. So does a cubical surface centered at the origin and with edges parallel to the axes. Select "True" or "False" for each statement below.

1. Suppose (for this statement only), that q is moved from the origin but is still within both the surfaces. The flux through both surfaces is changed.

2.If the radius of the spherical Gaussian Surface is varied, the flux through it also varies.

3. The area vector and the E-Field vector point in the same direction for all points on the spherical surface.

4. The E-Field at all points on the spherical surface is equal due to spherical symmetry.

5. The Electric Flux through the spherical surface is less than that through the cubical surface.

I tried :( F , T, F, T, F) but it is wrong, and I don't know which one is wrong.

I tried：

F T F T F

T F F T F

Both are wrong, and i dont know which one is wrong.

Using Excel Linear Solver Please answer the following, include all of the constraints.

You are a project manager for a consulting firm. You are going to hire four new employees. The candidates that you are choosing from are named Amy, Bob, Charlie, Debbie, and Elizabeth. You are managing two projects that you will use your new employees to complete. Project 1 will require at least 700 labor hours and Project 2 will require at least 870 labor hours. Elizabeth is the owner’s daughter so you will have to hire her. Amy and Charlie used to work together, but they can’t stand each other. If you hire one, you can’t hire the other. You have contracts that guarantee a set fee for each of the projects. Your profit will be determined by your ability to minimize your labor costs. Each of the employees you hire will require a signing bonus. The respective signing bonuses required for each employee if hired follow: Amy $24,000; Bob $11,000; Charlie $16,000; Debbie $17,000; Elizabeth $15,000. The hourly rate you pay each employee is determined by the type of project to which they are assigned. For Project 1, the required hourly rates for each employee if hired follow: Amy $100; Bob $95; Charlie $85; Debbie $50; Elizabeth $45. For Project 2, the required hourly rates for each employee if hired follow: Amy $60; Bob $40; Charlie $75; Debbie $120; Elizabeth $130. If you hire an employee, they can be used for both projects. Labor should be allocated in one hour increments. During the lifespan of these two projects, the candidates are available to work the following number of hours: Amy 440; Bob 730; Charlie 520; Debbie 680; Elizabeth 590. Which candidates will you hire?

Use the Gravity model to predict the effect of Brexit on UK’s trade with the EU.

c) What are the trade diversion and trade creation effect of trade agreements? Explain trade diversion and trade creation effect of the following.

1. US getting out of TPP Using the
2. US being part of NAFTA

Create your own programming application and give a brief description of the system.

What is Eliyahu M. Goldratt's most important contributions to Project Management?

Describe the evidence of the stages of group development, the role of status within the group and the six properties of a group from the movie 12 Angry Men.

From the film 12 Angry Men explain the stages of group development, the role of status within the group and describe the six properties of a group as related to the jurors in the movie.

You have filed a Patent application on March 18th 2020 and have been issued a Patent Application Number. On March 20th your competitor files a Patent application for almost the exact same invention. On September 22 2021 you are issued a Patent. What will likely happen to your competitors Patent Application that is currently in the que? Briefly explain your answer.