Question: Order ID Order Date Cust ID Cust FName Cust LName Sus Sacs Rep Rep Rep Comm Comm Dept ID FName LName Class Rate ID Pro

Order ID Order Date Cust ID Cust FName Cust LName

Order ID Order Date Cust ID Cust FName Cust LName Sus Sacs Rep Rep Rep Comm Comm Dept ID FName LName Class Rate ID Pro Cat ID Prod Cat Name Prod Qty Prod Prics Cust Phone SSS- 1212 1001/24/20 Sioo John Smith 10 Alice Jones 0.1 10 1 Hand Tools 2 S8.00 Power Tools 2 1 S65.00 4 Fasteners 2 53.00 4 Fasteners 1 S4.25 817- 101 1/25/20 A120 Jand Adams 555- 12 Cireg Taylor 0.ON 14 Misc 200) S1.75 Misc: 100 S1.25 Measuring Tools 102 1/25/20J090 Tim Jones 14 Sara Day 0 10 3 $1.25 1 Hand Tools 1 $7.00 Hardware S7.50 BD 972- 555- 103 1/20/20 B200 Ann Brown x Kay Price ( 0.05 14 Dept Prod Prod Name ID Name BI Sales 121 Hammer Makita Power 228 Drill 1# BI 480 Nails 1 RD 407 Screws Corp 3M Duet Sales 610) Tape 3M Making 618 Tape Aome Store Yard Sales 3x0 Stick BD 121 Hammer Schlage Door 535 knob Corp Sales 121 Acme 123 Pry Bar BD Store Power Saules 229 Drill 3M Duet 610) Acme Yard 380 Stick Schlas Door 535 Knob Corp 3M Duct Sales 610 Tape Acme 123 Pry Bar Store Acne Sales 124 Harrimer BD Store Power Sales 229 Drill Makita Web Power Saules 235 Drill Hn 1 Hand Tools 50 $7.00 1 Hand Tools 20 $6.25 214- 555- 1212 Power Tools 10- 1/26/20SIOO John Sunith 10 Alice Jones A 0.1 10 2 1 S50.00 Tape C 6 Misc 200 $1.75 Measuring Tools 3 $1.25 5 Hardware 4 S7.50 10S 1/267/20 B200 Anna 972- SSS- Brown X Kay Price 0.05 14 MIRO 200) S1.75 1 Hand Tools 40 S5.00 106 1/27/20 60 70 Kate Groen 20 But Jackson R 0.08 10 1 Hand Tools 1 S6.50 Power Tools 107 1/27/20J090 Tim Jones 14 Sara Day 10 2 1 S59.00 Power Tools 108 1/27/20 si 20 Nicole Sims 22 Micah Moore z c 16 2 1 S65.00 - 4. ENTITY-RELATIONSHIP MODEL - 30 points: a. Using Chen notation, create an ERD showing all of the 3NF tables above. You must show the entities, relationships, connectivity, participation, and cardinality (it is not necessary to show the attributes on the ERD). In addition, depict any composite (bridge/linking) tables with a diamond inside the entity rectangle. b. Based on the ERD created in step 4a, use Microsoft Access to create a relational schema showing the entities, their attributes, and the connectivity of the relationships. The PKs must be underlined or highlighted

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Order ID Order Date Cust ID Cust FName Cust LName Sus Sacs Rep Rep Rep Comm Comm Dept ID FName LName Class Rate ID Pro Cat ID Prod Cat Name Prod Qty Prod Prics Cust Phone SSS- 1212 1001/24/20 Sioo...

Page 1 of 3 Project Assignment 1 - Normalization Due 3/11 Order ID Order Date Cust ID Cust Cust FName LName Sales Rep ID Sales Sales Rep Rep Comm FName LName Class Comm Dept ID Rate Prod Quy Prod...

Home Improvement Warehouse is a store that sells home improvement products. All orders are picked up from the store. Each order must be sold to a specific customer. Each customer must have at least...

Based on the information provided above, complete the following: 1. FIRST NORMAL FORM (1NF) 20 pts: Decompose the composite attributes into simple attributes. Convert the table above to 1NF...

8. Write a query to display the employee number, first name, last name, brand name, and total units sold for each brand by that employee. Sort the results by employee number. The column labels and...

9. Write a query to display the product sku, description, category, price, average price of products within that category, and the difference between each products price and the average price of...

Write a query to display the customer code, customer last name, and the number of invoices generated by that customer. Limit the results to only customers who have at least five invoices. Sort the...

You will not be working with the "group by" clause and aggregate functions using MysQL Remember that MySQL does not find all errors when using the "group by" function. You will need to double check...

How to solve these ten questions ??? 218 IU 4G:all 80% 18:54 PM Microsoft Word-Lab 9.docx Lab 9: SQL DML Query in MySQL SQL Query from Multiple Tables IS 4420, Database Fundamentals We import the...

21. The following EER diagram describes a publisher specializing in large edited works Transform the diagram into a relational schema and show the referential integrity constraints among relations....

The Yellow Trust incurred $10,000 of portfolio income. Its corporate trustee paid fiduciary fees of $1,000 there from, and also paid $1,000 in premiums for a life insurance policy on Marcia,the...

If the Federal Reserve sells $50 billion of short-term U.S. Treasury securities to the public, other things held constant, what will this tend to do to short-term security prices and interest rates?...

Carly has one child, Chris, who is 1 8 years old at the end of the year. Chris lived at home for three months during the year before leaving home to work full time in another city. During the year,...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...