Question: ERD Diagram Lab Question 3- SQL (using Lucidechart or similar program) Prepare an IE style ERD diagram for the IST272Eagle databases Customer, CustOrder, and CustOrderLine

ERD Diagram Lab Question 3- SQL (using Lucidechart or similar program)

ERD Diagram Lab Question 3- SQL (using Lucidechart or similar program) Prepare

Prepare an IE style ERD diagram for the IST272Eagle databases Customer, CustOrder, and CustOrderLine tables (just these three tables - do not include any other tables on the diagram). Paste an image of the diagram in the space below:

Exercise 3 --* O dbo.Custorder e a Columns 9 OrderID (PK, varchar(10), not null) ? CustomerID (FK, varchar(10), null) Order Date (smalldatetime, null) O RequiredDate (smalldatetime, null) O dbo.Customer e a Columns ? CustomerID (PK, varchar(10), not null) O CompanyName (varchar(40), null) CustfirstName (varchar(15), null) CustlastName (varchar(20), null) n CustTitle (varchar(5), null) | Address (varchar(40), null) n City (varchar(20), null) O State (varchar(2), null) O PostalCode (varchar(10), null) | Phone (varchar(12), null) O Fax (varchar(12), null) O EmailAddr (varchar(50), null) O dbo.Custorderline e a Columns ? OrderID (PK, FK, varchar(10), not null) Y PartNumber (PK, FK, varchar(10), not null) A UnitPrice (decimal(9,2), null) O OrderQuantity (decimal(9,0), null) O Discount (decimal(6,2), null) Status (varchar(15), null)

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 Databases Questions!