The problems use the Customer, Order Tbi, and Employee tables of the simplified Order Entry database....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The problems use the Customer, Order Tbi, and Employee tables of the simplified Order Entry database. Chapters 4 and 10 extend the database to increase its usefulness. The Customer table contains clients who have placed orders. The OrderTbl contains basic facts about customer orders. The Employee table contains facts about employees who take orders. The primary keys of the tables are CustNo for Customer, EmpNo for Employee, and OrdNo for Order Tbl. CustNo C0954327 C1010398 C2388597 C3340959 C3499503 C8543321 EmpNo E1329594 E8544399 EB843211 E9345771 E9884325 E9954302 CustFirstName Sheri Jim Beth Betty Bob Ron Landi Joe Amy Colin CustLastName Thomas Mary Gordon Glussman Taylor Wise Mann EmpFirstName Thompson Customer CustCity Littleton Denver Seattle Seattle Monroe Renton Employee EmpLastName Santos Jenkins Tang White Johnson Hill CustState Custzip 80129-5543 80111-0033 98103-1121 98178-3311 98013-1095 98666-1289 CO co WA WA WA WA EmpPhone (303) 789-1234 (303) 221-9875 (303) 556-4321 (303) 221-4453 (303) 555-9987 (303) 556-9871 CustBal $230.00 $200.00 $500.00 $20000 $0.00 $85.00 EmpEmail LSantos@bigco.com JJenkins@bigco.com ATang@bigco.com CWhite@bigco.com TJohnson@bigco.com MHillabigco.com OrdNo 01116324 02334661 03331222 02233457 04714645 C5511365 07989497 01656777 07959898 OrdDate 01/23/2017 01/14/2017 01/13/2017 01/12/2017 01/11/2017 01/22/2017 01/16/2017 02/11/2017 02/19/2017 CustNo C0954327 00954327 C1010398 C2388597 C2388597 C3340959 C3499503 C8543321 C8543321 EmpNo E8544399 E1329594 E9884325 E1329594 E9884325 E9345771 E8544399 1. Write a CREATE TABLE statement for the Customer table. Choose data types appropriate for the DBMS used in your course. Note that the Cust Bal column contains numeric data. The currency symbols are not stored in the database. The CustFirstName and CustLastName columns are required (not null). 2. Write a CREATE TABLE statement for the Employee table. Choose data types appropriate for the DBMS used in your course. The EmpFirst Name, EmpLast Name, and EmpEMail columns are required (not null). 3. Write a CREATE TABLE statement for the Order Tbl table. Choose data types appropriate for the DBMS used in your course. The OrdDate column is required (not null). 4. Identify the foreign keys and draw a relationship diagram for the simplified Order Entry database. The CustNo column references the Customer table and the Emp No column references the Employee table. For each relationship, identify the parent table and the child table. The problems use the Customer, Order Tbi, and Employee tables of the simplified Order Entry database. Chapters 4 and 10 extend the database to increase its usefulness. The Customer table contains clients who have placed orders. The OrderTbl contains basic facts about customer orders. The Employee table contains facts about employees who take orders. The primary keys of the tables are CustNo for Customer, EmpNo for Employee, and OrdNo for Order Tbl. CustNo C0954327 C1010398 C2388597 C3340959 C3499503 C8543321 EmpNo E1329594 E8544399 EB843211 E9345771 E9884325 E9954302 CustFirstName Sheri Jim Beth Betty Bob Ron Landi Joe Amy Colin CustLastName Thomas Mary Gordon Glussman Taylor Wise Mann EmpFirstName Thompson Customer CustCity Littleton Denver Seattle Seattle Monroe Renton Employee EmpLastName Santos Jenkins Tang White Johnson Hill CustState Custzip 80129-5543 80111-0033 98103-1121 98178-3311 98013-1095 98666-1289 CO co WA WA WA WA EmpPhone (303) 789-1234 (303) 221-9875 (303) 556-4321 (303) 221-4453 (303) 555-9987 (303) 556-9871 CustBal $230.00 $200.00 $500.00 $20000 $0.00 $85.00 EmpEmail LSantos@bigco.com JJenkins@bigco.com ATang@bigco.com CWhite@bigco.com TJohnson@bigco.com MHillabigco.com OrdNo 01116324 02334661 03331222 02233457 04714645 C5511365 07989497 01656777 07959898 OrdDate 01/23/2017 01/14/2017 01/13/2017 01/12/2017 01/11/2017 01/22/2017 01/16/2017 02/11/2017 02/19/2017 CustNo C0954327 00954327 C1010398 C2388597 C2388597 C3340959 C3499503 C8543321 C8543321 EmpNo E8544399 E1329594 E9884325 E1329594 E9884325 E9345771 E8544399 1. Write a CREATE TABLE statement for the Customer table. Choose data types appropriate for the DBMS used in your course. Note that the Cust Bal column contains numeric data. The currency symbols are not stored in the database. The CustFirstName and CustLastName columns are required (not null). 2. Write a CREATE TABLE statement for the Employee table. Choose data types appropriate for the DBMS used in your course. The EmpFirst Name, EmpLast Name, and EmpEMail columns are required (not null). 3. Write a CREATE TABLE statement for the Order Tbl table. Choose data types appropriate for the DBMS used in your course. The OrdDate column is required (not null). 4. Identify the foreign keys and draw a relationship diagram for the simplified Order Entry database. The CustNo column references the Customer table and the Emp No column references the Employee table. For each relationship, identify the parent table and the child table.
Expert Answer:
Answer rating: 100% (QA)
The images provided show tables from a simplified Order Entry database with several instructions for creating tables and defining relationships between them To address the instructions provided 1 Writ... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
Momentum [kg-m/s] 1 ? 0.1 0.2 0.3 0.4 0.5 Time [s] Figure 1.21: Momentum as a function of time[1] 22 object is not "in equilibrium," meaning that this time the net force on the object is not zero....
-
Which is not a parasite of the human intestine (a) Ringworm (b) Pinworm (c) Threadworm (d) Tapeworm
-
DRAW A RELATIONAL DATA MODEL FOR INSURANCE OF A CAR AND Construct appropriate tables by specifying the integrity constraints. DriverID Address Name Person Owna License Model Year Car Participated...
-
Figure shows an overhead view of a ring that can rotate about its center like a merry-go-round. Its outer radius R2 is 0.800 m, its inner radius R1 is R2/2.00, its mass M is 8.00 kg, and the mass of...
-
For grade 20 cast iron, Table A24 gives Sut = 22 kpsi, Suc = 83 kpsi. Choose and plot the failure locus and, for the static loadings inducing the stresses at the critical locations of Prob. 59, plot...
-
The comparative balance sheet of Olson-Jones Industries Inc. for December 31, 20Y2 and 20Y1, is as follows: The following additional information is taken from the records: A. Land was sold for $120....
-
You rolled a six-sided die 60 times and got the following tally. 20 ones 20 twos 15 threes 3 fours 2 fives 0 sixes Does this seem like a reasonable result? What inference might you draw from the...
-
Granny Carney Associates surveys American eating habits. The companys accounts include Land, Buildings, Office Equipment, and Communication Equipment, with a separate Accumulated Depreciation account...
-
An agent makes the following statement to a potential buyer: 'The property has amazing views - look at these images. You can see all the way to the bay!' The agent shows the buyer images of the...
-
You, CPA, work as a consultant on various engagements. Your client, Over The Edge Ltd. (OTE), has grown from a small custom snowboard manufacturer servicing the local market to a multinational...
-
A flying squid ( family Ommastrephidae ) is able to "jump" off the surface of the sea by taking water into its body cavity and then ejecting the water vertically downward. A 0 . 7 6 - kg squid is...
-
A solid sphere of mass m = 2.00 kg and radius R = 0.25 m is attached to one end of a rod as shown in Figure 10. The rod has a length L = 1.00 m and mass M = 3.00 kg. If the system rotates about the...
-
A project that is expected to generate annual after-tax cash flows of $2,200 for each of the next 20 years. The project's cost of capital is 8.5 percent and it has an IRR of 9.058 percent. What is...
-
Gabbie has to decide between the following two choices: Option 1: Get $320 with probability 35.97%, and $84.15 with the complement probability. Option 2: Get $94.95 with 100% probability. Her utility...
-
Why are unpaid accruals a "temporary" source of cash? Please give some details and examples.
-
Mark has the following utility function: U = ln(w) where w denotes the wealth. Mark has the chance to play in the following lottery: with probability 0.58 the lottery gives $43,750 and with the...
-
Consider the following matrix A and solving the linear system A = b by iterative methods, A = 1 a B - 1 -7 B7 1 (a) What are the conditions on the variables a, 3, and y for Jacobi's method and...
-
Dan and Diana file a joint return. Dan earned $31,000 during the year before losing his job. Diana received Social Security benefits of $5,000. a. Determine the taxable portion of the Social Security...
-
Part proliferation: role for activity-based costing An article in the Wall Street Journal by Neal Templin and Joseph B. White (June 23, 1993) reported on the major changes occurring at General...
-
Relevant costs and revenues: replacement decision Joyce Printers, Inc., is considering replacing its current printing machines with newer, faster, and more efficient printing technology. The...
-
Provide an example of a fixed cost that would be relevant to a make-or-buy decision, and an example of a fixed cost that would not be relevant to such a decision.
-
In a survey, U.S. adults were asked to identify which social media platforms they use. The results are shown in the figure. Six adults who participated in the survey are randomly selected and asked...
-
Rotator cuff surgery has a 90% chance of success. The surgery is performed on three patients. Find the probability of the surgery being successful on exactly two patients.
-
Determine whether each experiment is a binomial experiment. If it is, specify the values of n, p, and q, and list the possible values of the random variable x. If it is not, explain why. 1. A certain...
Study smarter with the SolutionInn App