Question
The following diagram is a REA data model in UML notation. Attributes: Bicycle color Geographic region description Bicycle product number Geographic region identifier Bicycle quantity
The following diagram is a REA data model in UML notation.
Attributes: | |
Bicycle color | Geographic region description |
Bicycle product number | Geographic region identifier |
Bicycle quantity on hand | Number of bicycles of this type on hand |
Bicycle size | Price of this bicycle sold on this invoice |
Bicycle Type | Quantity of this bicycle sold on this invoice |
Bicycle Type Description | Sale total $ amount |
Customer address | Sales invoice date |
Customer name | Sales invoice number |
Customer number | Year-to-date sales $ for this region |
Using the list of attributes above, list all relevant attributes to be included in each of 1. Sales, 2. Types of Bicycles, 3. Bicycle Inventory, 4. Geographic Region, and 5.Sales-Bicycles (linking table) tables when these tables are implemented. Clearly indicate primary keys, foreign keys, and other non-key attributes in these tables. For example, the attributes of Customers table should be listed in the following format.
Customers: Customer Number (PK), Geographic Region Identifier (FK), Customer Name, Customer Address.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started