List the tables with primary keys, attributes, and foreign keys that implement the following UML Class diagram given the accompanying list of attributes.
Attributes:Bicycle colorBicycle product numberBicycle quantity on handBicycle sizeBicycle TypeBicycle Type DescriptionCustomer addressCustomer nameCustomer numberGeographic region descriptionGeographic region identifierNumber of bicycles of this type on handPrice of this bicycle sold on this invoiceQua Quantity of this bicycle sold on this invoiceSale total $ amountSales invoice dateSales invoice numberYear-to-date sales $ for this region
What will be an ideal response?
Types of Bicycles = Bicycle Type (PK), Bicycle Type Description, Number of bicycles of this type on hand
Bicycles = Bicycle Product Number (PK), Bicycle Type (FK), Bicycle Size, Bicycle Color, Bicycle Quantity on Hand
Sales = Sales Invoice Number (PK), Customer Number (FK), Sales Invoice Date, Sale Total $ Amount
Customers = Customer Number (PK), Geographic Region Identifier (FK), Customer Name, Customer Address
Geographic Region = Geographic Region Identifier (PK), Geographic Region Description, Year-to-date Sales $ for this Region
(Linking Tables)
Sales - Bicycles = Sales Invoice Number + Bicycle Product Number (PK), Price of this Bicycle Sold on this Invoice, Quantity of this Bicycle Sold on this Invoice
You might also like to view...
The marketing research process begins by ________
A) developing a research plan B) defining the problem, the decision alternatives, and research objectives C) analyzing the internal environment D) reading marketing research journals E) contacting a professional research consultant
Which of the following is not an advantage of commercial software? Commercial software
a. can be installed faster than a custom system b. can be easily modified to the user's exact specifications c. is significantly less expensive than a system developed in-house d. is less likely to have errors than an equivalent system developed in-house
All of the following are elements of discourse ethics EXCEPT ______.
A. equal power among participants B. freedom from coercion C. unjustified claims D. involve all affected by the decision
Companies may use a special bank account solely for the purpose of paying employees, by depositing an amount equal to the total employees' net pay into the account each pay period and drawing the employees' payroll checks on the account. This account is a(n):
A. Federal depository bank account. B. Payroll bank account. C. Payroll register account. D. Employee's Individual Earnings account. E. Employees' bank account.