Question: B. Below is the relational model for warehouse inventory system for a local retailer. c) Based on the relational model, create the database metadata as
B. Below is the relational model for warehouse inventory system for a local retailer. c) Based on the relational model, create the database metadata as part the physical design phase. From the metadata, write the SQL create database and table statements (DDL) for all entities (tables). f) g) Implement the tables in your MySQL DB. h) Export your database to a sql file and submit as part of your lab submission. NVENTORY UPC Warehouso Name Quantiy PRODUCT VP Name Buying Price Seling Price SizeManvcvoc.Noroe MANUFACTURER Manufacturer Name MStreet MCity MState MZip MPhone WAREHOUSE Warohouse Name wLocation WCity WState WZip WSpace 5 pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
