Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

----example of what it kinda has to look like. Cycle Assignment Part 3 The second stage of the project requires students to convert their REA

image text in transcribed
image text in transcribed
image text in transcribed ----example of what it kinda has to look like.
image text in transcribed
image text in transcribed
Cycle Assignment Part 3 The second stage of the project requires students to convert their REA diagram into tables. 1. In this step you need to convert your REA diagram into tables. 2. You should submit a list of all your tables, the attributes in each table and primary and foreign keys for each table. Example: Table Name Primary Key Sales Number Sales Foreign Key Customer Number, Employee Number Other Attributes Date of Sale, Time of Sale, Total Amount of Sale Customer REA Diagram Resources Events Gb For More Agents Employees of Sales Inventory PH Customes tone Hier wore the od Deliver th atomer FOTO corean b. *Employees I Cash A cash 04 Receipis customer 7 TO re is recer Employees 1 Table Name E 2 Sales 3 Recieve Cash 4 Inventory D Primary key Foreign Key Other Attributes Date of Sale, Time of Sale, Total Sale No. Customer No., Employee No. Amount of Sale Employee No., Customer No., Receipt Date, Receipt Time, Total Customer Rect No. Sale No., Account No. Amount of Receipt Item No., Customer Rect No., Item No. Sales No., Account No. Description, List Price Account No., Sale No., Account No. Customer Rect No. Bank, Type of Account Customer Name, Customer Address, Customer No. Customer No., Sale No. Customer Phone Employee Name, Employees Employee No. Employee No., Sale No. Address, Employee Phone, Job Title Item No., Sale No., Account Sale No.-Item No. No. Quantity Sold, Actual Price 5 Cash 6 Customer 7 Employee 8 Sales-Inventory 10 N-50 Revenue Cycle Assignment Part 3 The second stage of the project requires students to convert their REA diagram into tables. 1. In this step you need to convert your REA diagram into tables. 2. You should submit a list of all your tables, the attributes in each table and primary and foreign keys for each table. Example: Table Name Sales Other Attributes Primary Key Sales Number Foreign Key Customer Number, Employee Number Date of Sale, Time of Sale, Total Amount of Sale Customer 64 Sales Do Harport Linventory til Lostomer & cash rec. >0 Cash Employed (Economic yousdekor Sales weet chocesih Biss 00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database 10g Insider Solutions

Authors: Arun R. Kumar, John Kanagaraj, Richard Stroupe

1st Edition

0672327910, 978-0672327919

More Books

Students also viewed these Databases questions