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)

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
Get step-by-step solutions from verified subject matter experts
