Question: York company is changing from a file-oriented system to a relational database system. Identify and design a customer table, a sales table, an inventory table,

York company is changing from a file-oriented system to a relational database system. Identify and design a customer table, a sales table, an inventory table, a salesperson table and sales-inventory table that would be needed to capture data for a sales transaction. Each table should include a primary key, foreign keys if necessary and one non-key attribute.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

2.2 Seacrest Bedding is changing from a file-oriented system to a relational database system. Identify and design a customer table, a sales table, an inventory table, a sales- person table and...

Seacrest Bedding is changing from a file-oriented system to a relational database system. Identify and design at least Three tables that would be needed to capture data for a sales transaction. Each...

Kitchen World is changing its inventory system from a file-oriented system to a relational database system. Identify and design at least three tables that would be needed to capture data for Kitchen...

Part 1: Applying General Controls General Controls - A company designs general controls to ensure that its overall AIS is stable and well managed. They contain (partial list): Proper Authorization of...

Applying General Controls General Controls - A company designs general controls to ensure that its overall AIS is stable and well managed. They contain (partial list): Proper Authorization of...

Entity-Relationship Modelling (22 marks) Use the following case study description to answer questions 4 and 5. Smiggle Corporation (SC) has a department store with average of 100 customers per day....

REA Homework #2 Pegasus Paper Products Pegasus Paper Products Inc. Your co-worker, Athletic Annie, was working on the database design project for Pegasus Paper Products (PPP) when she suffered a...

Need excel sheet for part2,3, AND 4 and all the answers for the questions .Thank you Part 2: Projecting Growth For this part of the lab, use the data in the file Part2Lab1Data.xlsx. Copy and paste...

I need help finding out the answers on the study guide so I can have a general idea of whats on the exam. Its all on Microsoft Access and normalization ACG 306 Final Exam Review...

Refer to Problem P22- 47B. Additional data for Beta Batting Company: a. Capital expenditures include $ 40,000 for new manufacturing equipment, to be purchased and paid in the first quarter. b. Cash...

What is a direct cost? An indirect cost? Can the same cost be direct for one purpose and indirect for another? Give an example.

26. Calculating Financial Ratios (LO3) Find the following financial ratios for Earl Grey Golf Corp. (use year-end figures rather than average values where appropriate): Short-term solvency ratios a....

Q8: Use the sandwich theorem to show that 1 sin x.cos(-) = 0 lim |

Stiller Company uses the allowance method to account for bad debts. In the first year of operations (2014), Stiller sold $540,000 of merchandise on credit, including a $2,500 sale to Bubba Long. On...

I am looking for local or national response protocols that were initiated during a critical incident. I can search reputable local and national media for a man-made disaster to discuss. I need to...

1. Information that is currently accessible (recognition).

8. Based on the model in Fig. 10.2 in this chapter, analyse yourself and find out which cell you would place yourself in. Let another person in the group analyse you. Did he/she choose the same cell...

9. Take four examples from your own everyday life where someone has tried to influence you. Which of the seven influencing techniques mentioned above were used? Did they use any other influencing...