Top Posters
Since Sunday
p
57
54
C
18
I
13
n
13
a
12
11
C
11
s
11
11
m
11
10
New Topic  
wrote...
Posts: 212
5 months 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.
Textbook 

Accounting Information Systems


Edition: 14th
Authors:
Read 30 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 273
5 months 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...
5 months 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
  130 People Browsing
Your Opinion
Related Images
 103
 91
 33