Scribd
Upload
12 views2 pages

Transaction Table

The document outlines the structure of a Sales Journal, detailing its header and detail components, including attributes such as transaction numbers, dates, customer codes, item codes, and pricing. It specifies the primary key for the Customer entity and the foreign key relationship with the Sales Journal. Additionally, a UML Class Diagram is referenced, indicating a visual representation of these relationships.

Uploaded by

Yulia keren
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views2 pages

Transaction Table

The document outlines the structure of a Sales Journal, detailing its header and detail components, including attributes such as transaction numbers, dates, customer codes, item codes, and pricing. It specifies the primary key for the Customer entity and the foreign key relationship with the Sales Journal. Additionally, a UML Class Diagram is referenced, indicating a visual representation of these relationships.

Uploaded by

Yulia keren
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Transaction Table

Sales Journal
Sales Journal Header Detail
Transaction Number Transaction Number
Transaction Date Item Code
Customer Code Item Quantity
Description Item Price
Total Price

Attributes
Customer
Customer Code
Customer Name

Sales Journal
Sales Journal Header Detail
Transaction Number Transaction Number
Transaction Date Item Code
Customer Code Item Quantity
Description Item Price
Total Price

Primary Key and Foreign Key


Customer Primary Key
Customer Code Foreign Key
Sales Journal
Sales Journal Header Detail
Transaction Number Transaction Number
Transaction Date Item Code
Customer Code Item Quantity
UML Class Diagram

You might also like