Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What changes would you need to make to the normalized tables in Exercise 3 to support the following additional requirements: a. TAL needs to keep
What changes would you need to make to the normalized tables in Exercise 3 to support the following additional requirements:
a. TAL needs to keep track of the price a supplier charges for an item. Different suppliers can charge different prices for the same item.
b. Each storehouse has a manager who is identified by a manager number, a manager last name, and a manager first name.
Item(ItemNum, Description, Category, Price)
Storehouse(StoreHouseNum, StoreHouseName, OnHand)
Suppliers(SupplierName, LeadTime)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started