Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please make this jnto a entity realtionshop diogram ex Part Attributes: PartID (Primary Key) Name Description Manufacturer Model SerialNumber Condition (Good/Bad) DateReceived Location (Warehouse/Site) Status

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
please make this jnto a entity realtionshop diogram
ex
image text in transcribed
Part Attributes: PartID (Primary Key) Name Description Manufacturer Model SerialNumber Condition (Good/Bad) DateReceived Location (Warehouse/Site) Status (In Stock/Installed/Out for Repair) PurchaseDate PurchasePrice EstimatedLife Servicesite Attributes: SitelD (Primary Key) Name Location SiteManager RepairRecord Attributes: RecordID (Primary Key) PartlD (Foreign Key) DateRepaired TechnicianlD (Foreign Key) RepairDescription RepairCost Supplier Attributes: SuppliedD (Primary Key) Name ContactName ContactEmail ContactPhone PurchaseOrder Attributes: OrderiD (Primary Key) PartiD (Foreign Key) SupplierlD (Foreign Key) OrderDate Quantity Uniterice Totalcost Orderstatus STORE \begin{tabular}{|l|} \hline StoreSK \\ \hline StoreName \\ City \\ Country \\ Phone \\ Fax \\ Email \\ Contact \\ \hline \end{tabular} PURCHASE PurchaseSK Date Description Category PriceUSD SHIPMENT ITEM InsuredValue SHIPPER \begin{tabular}{|l|l|} \hline ShipperName \\ \hline Phone \\ Fax \end{tabular} SHIPMENT ShipmentsK ShipDate ShipperinviceNumber Email Origin Contact Destination Supplier Attributes: SupplierlD (Primary Key) Name ContactName ContactEmail ContactPhone PurchaseOrder Attributes: OrderlD (Primary Key) PartID (Foreign Key) SypplierID (Foreign Key) Employee Attributes: EmployeelD (Primary Key) FirstName LastName Position Email Phone Warehouse Attributes: WarehouselD (Primary Key) Name Location Part Attributes: PartID (Primary Key) Name Description Manufacturer Model SerialNumber Condition (Good/Bad) DateReceived Location (Warehouse/Site) Status (In Stock/Installed/Out for Repair) PurchaseDate PurchasePrice EstimatedLife Servicesite Attributes: SitelD (Primary Key) Name Location SiteManager RepairRecord Attributes: RecordID (Primary Key) PartlD (Foreign Key) DateRepaired TechnicianlD (Foreign Key) RepairDescription RepairCost Supplier Attributes: SuppliedD (Primary Key) Name ContactName ContactEmail ContactPhone PurchaseOrder Attributes: OrderiD (Primary Key) PartiD (Foreign Key) SupplierlD (Foreign Key) OrderDate Quantity Uniterice Totalcost Orderstatus STORE \begin{tabular}{|l|} \hline StoreSK \\ \hline StoreName \\ City \\ Country \\ Phone \\ Fax \\ Email \\ Contact \\ \hline \end{tabular} PURCHASE PurchaseSK Date Description Category PriceUSD SHIPMENT ITEM InsuredValue SHIPPER \begin{tabular}{|l|l|} \hline ShipperName \\ \hline Phone \\ Fax \end{tabular} SHIPMENT ShipmentsK ShipDate ShipperinviceNumber Email Origin Contact Destination Supplier Attributes: SupplierlD (Primary Key) Name ContactName ContactEmail ContactPhone PurchaseOrder Attributes: OrderlD (Primary Key) PartID (Foreign Key) SypplierID (Foreign Key) Employee Attributes: EmployeelD (Primary Key) FirstName LastName Position Email Phone Warehouse Attributes: WarehouselD (Primary Key) Name Location

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Fundamentals

Authors: Robert N. Lussier

9th Edition

154438419X, 978-1544384191

More Books

Students also viewed these General Management questions

Question

How is a year-over-year percentage calculated?

Answered: 1 week ago