The following  are the 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 Type, Bicycle Type Description, Number of bicycles of this type on hand

Bicycle Product Number, Bicycle Type, Bicycle Size, Bicycle Color, Bicycle Quantity on Hand

Sales Invoice Number, Customer Number, Sales Invoice Date, Sale Total $ Amount

Customer Number, Geographic Region Identifier, Customer Name, Customer Address

Geographic Region Identifier, Geographic Region Description, Year-to-date Sales $ for this Region
Sales Invoice Number, Bicycle Product Number, Price of this Bicycle Sold on this Invoice, Quantity of this Bicycle Sold on this Invoice

 

 

Requirement

 

 Use the UML class diagram to create an MS Access database and the relationship.

Determine the primary key for each table.
 

 

Transcribed Image Text:

Types of Bicycles Bicycle Inventory Sales Customers Geographic Region Types of Bicycles Bicycle Inventory Sales Customers Geographic Region