Top Posters
Since Sunday
25
21
20
17
17
16
15
14
14
14
14
14
New Topic  
wrote...
Posts: 111
A week ago
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 World's inventory. Each table should include a primary key, three non-key attributes, and foreign keys as necessary. Make up data values for two records within each table.
Source  Download
Accounting Information Systems
Edition: 14th
Authors:
Read 7 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 128
Rep: 9 0
A week ago
Sign in or Sign up in seconds to unlock everything.
Inventory table; item ID (primary key), description, size, color, warehouse location, quantity on hand
Price table; ID (primary key), list price, discount, item ID (foreign key)
Sales table; sales invoice number (primary key), date, amount, sales tax, shipping charge, shipping method
Sales-Inventory table; sales invoice number and item ID (concatenated primary key), quantity sold, sales price, extended amount

Students should also make up data values for two separate records for each table.
1
Related Topics
wrote...
A week ago
Helps a lot... Now I'm ready for my quiz
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  170 People Browsing
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 152

Previous poll results: Where do you get your textbooks?
Related Images
 68
 80
 62