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
You might also like to view...
Most workbooks arrange data in ________
Fill in the blank(s) with the appropriate word(s).
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
A Windows 7 business computer can only be reimaged three times
Indicate whether the statement is true or false
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.