Types of Bicycles 0..* 0..1 Sales 0..* Bicycle Inventory 1..* 1..1 Customers 0..* 1..1 Geographic Region

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

ist the tables with primary keys, attributes, and foreign keys that implement the following UML Class diagram given the accompanying list of attributes.

 

Attributes:

Bicycle color

Bicycle product number

Bicycle quantity on hand

Bicycle size

Bicycle Type

Bicycle Type Description

Customer address

Customer name

Customer number

Geographic region description

Geographic region identifier

Price of this bicycle sold on this invoice

Quantity of this bicycle sold on this invoice

Sale total $ amount

Sales invoice date

Sales invoice number

Year-to-date sales $ for this region

Types of
Bicycles
0..*
0..1
Sales
0..*
Bicycle
Inventory
1..*
1..1
Customers
0..*
1..1
Geographic
Region
Transcribed Image Text:Types of Bicycles 0..* 0..1 Sales 0..* Bicycle Inventory 1..* 1..1 Customers 0..* 1..1 Geographic Region
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education