Derive relations for the following conceptual data model:

What will be an ideal response?


Customer (customerNo, customerName, customerStreet, customerCity,
customerState, customerZipCode, custTelNo, custFaxNo, DOB,
maritalStatus, creditRating)
Primary Key customerNo
Alternate Key custTelNo
Alternate Key custFaxNo
Employee (employeeNo, title, firstName, middleName, lastName, address, workTelExt,
homeTelNo, empEmailAddress, socialSecurityNumber, DOB, position, sex,
salary, dateStarted)
Primary Key employeeNo
Alternate Key socialSecurityNumber
Invoice (invoiceNo, dateRaised, datePaid, creditCardNo, holdersName, expiryDate,
orderNo, pMethodNo)
Primary Key invoiceNo
Foreign Key orderNo references Order(orderNo)
Foreign Key pMethodNo references PaymentMethod(pMethodNo)
Order (orderNo, orderDate, billingStreet, billingCity, billingState, billingZipCode,
promisedDate, status, customerNo, employeeNo)
Primary Key orderNo
Foreign Key customerNo references Customer(customerNo)
Foreign Key employeeNo references Employee(employeeNo)
OrderDetail (orderNo, productNo, quantityOrdered)
Primary Key orderNo, productNo
Foreign Key orderNo references Order(orderNo)
Foreign Key productNo references Product(ProductNo)
PaymentMethod (pMethodNo, paymentMethod)
Primary Key pMethodNo
Product (productNo, productName, serialNo, unitPrice, quantityOnHand, reorderLevel,

reorderQuantity, reorderLeadTime)

Primary Key productNo
Alternate Key serialNo
Shipment (shipmentNo, quantity, shipmentDate, completeStatus, orderNo, productNo,
employeeNo, sMethodNo)
Primary Key shipmentNo
Foreign Key orderNo, productNo references OrderDetail(orderNo, productNo)
Foreign Key employeeNo references Employee(employeeNo)
Foreign Key sMethodNo references ShipmentMethod(sMethodNo)
ShipmentMethod (sMethodNo, shipmentMethod)
Primary Key sMethodNo

Computer Science & Information Technology

You might also like to view...

Most workbooks arrange data in ________

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

When using EUI-64, what is the correct result of inverting the seventh bit of the interface ID with an interface ID of B2C3:7AA0:8801?

A) B2C3:7A80:8801 B) B0C3:7AA0:8801 C) B3C3:7AA0:8801 D) BDC3:7AA0:8801

Computer Science & Information Technology

A Windows 7 business computer can only be reimaged three times

Indicate whether the statement is true or false

Computer Science & Information Technology

The domain naming master and schema master roles are held by ____________ in the forest

a. All domain controllers in the forest b. Only one domain controller in the forest c. At least two domain controllers in the forest d. None of the above.

Computer Science & Information Technology