Using the Logical Database Design Phase, derive all the relations from the following conceptual database model...

 

Transcribed Image Text:

Using the Logical Database Design Phase, derive all the relations from the following conceptual database model design: Product productNo (PK} productName serialNo unit Price PaymentMethod pMethodFor Invoice pMethodNo {PK} paymentMethod 1. 1 1.. invoiceNo {PK} dateRaised quantityOnHand reorderLevel datePaid credit CardNo reorderQuantity reorderLeadTime holdersName expiryDate 1..1 1.. 1 Partof Raises 1.. 1 Customer Places Order Has OrderDetial customerNo (PK} 1.. 1 orderNo (PK} 1.. 1 quantityOrdered customerName Address orderData billingStreet billingCity billingState billingzipCode promissedDate customerStreet customerCity CustomerState custzipcode cust TelNo 1. 1 status custFaxNo 0.. Packegedin DOB materialStatus Processes 1.. 1 creditRating Employee Prepares Shipment employeeNo {PK} title Name shipmentNo (PK) quantity 1.. 1 shipmentDate completeStatus fName midName IName address workTelExt homeTelNo sMethodFor empEmailAddress 1.. 1 SSN DOB Shipment Method position SMethodNo {PK) shipmentMethod sex salary datastarted Using the Logical Database Design Phase, derive all the relations from the following conceptual database model design: Product productNo (PK} productName serialNo unit Price PaymentMethod pMethodFor Invoice pMethodNo {PK} paymentMethod 1. 1 1.. invoiceNo {PK} dateRaised quantityOnHand reorderLevel datePaid credit CardNo reorderQuantity reorderLeadTime holdersName expiryDate 1..1 1.. 1 Partof Raises 1.. 1 Customer Places Order Has OrderDetial customerNo (PK} 1.. 1 orderNo (PK} 1.. 1 quantityOrdered customerName Address orderData billingStreet billingCity billingState billingzipCode promissedDate customerStreet customerCity CustomerState custzipcode cust TelNo 1. 1 status custFaxNo 0.. Packegedin DOB materialStatus Processes 1.. 1 creditRating Employee Prepares Shipment employeeNo {PK} title Name shipmentNo (PK) quantity 1.. 1 shipmentDate completeStatus fName midName IName address workTelExt homeTelNo sMethodFor empEmailAddress 1.. 1 SSN DOB Shipment Method position SMethodNo {PK) shipmentMethod sex salary datastarted