Question: Please Help me turn this DBDL into a E-R Diagram (Please include all connections as (Dots) ) Vendor (Vendor number, Vendor name, Address, City, State,

Please Help me turn this DBDL into a E-R Diagram

(Please include all connections as (Dots) )

Vendor (Vendor number, Vendor name, Address, City, State, ZIP code)

Purchase Order (PO number, Vendor number, Subtotal, Tax, Shipping, PO total, PO date)

(FK) Vendor number -> Vendor

Payables (PO number, Product number, Unit price, Quantity)

(FK) PO number -> Purchase Order

(FK) Product number -> Product

Product (Product number, Product)

--------------------------------------------------------------------------------------------------------------------------------------------------

Heres a example of one I made from a prior Project.

(NOTE: This one isnt completely correct)

Please Help me turn this DBDL into a E-R Diagram (Please include

Thank you!

E-R Diagram Location Condo Unit Location# CondoID '-- LocationName Address* City* State PostalCode* (SK) ocation# (FK) Unit# SqrFt Bdrms* Baths* Condo Fee* Owner# (FK) ServiceRequest Owner Owner# Servicelll LastName FirstName Address* City* State* CondoID (FK) Category# (FK) ServiceDescription (SK) CurrentStatus PostalCode (SK) EstHours* SpentHours* NextServiceDate ServiceCategory Category# CategoryDescription (SK) * :-*Technician#ma (FK) Technician Technician# LastName (SK) First Name

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!