Derive relations for the following conceptual data model:
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...
Give a command to
a. Redirect standard output from a sort command to a file named phone_list. Assume the input file is named numbers. b. Translate all occurrences of the characters [ and { to the character (, and all occurrences of the characters ] and } to the character ), in the file permdemos.c. c. Create a file named book that contains the contents of two other files: part1 and part2.
What is the reference point locator used for?
What will be an ideal response?
____________________ is the combination of design characteristics that are applied to text.
Fill in the blank(s) with the appropriate word(s).
The convergence of information technology and operations technology, offering the potential for tremendous improvements in efficiency, product quality, agility, and flexibility, allowing companies to mass-produce customized products and better monitor supply chains, refers to which term below?
a. Applications in the Cloud b. The Technology of Things c. The Technology Effect d. Internet of Things e. Industrial Internet of Things