Using MS Visio or a well-drawn super neat figure, create a database design Data

Question

Using MS Visio or a well-drawn super neat figure, create a database design

Data Model 2: PRODUCT MANAGEMENT SYSTEM FDA REPORT COMPANY PRODUCT issues/IssuedBy Produces/MadeBy ReportNumber ProcuctD Date ProductName ts/lsListedIn -------------------------o Serving SizeOz List Serving SizeGrm Contains/lsUsedIn NumServings Listsing/lsListedIn Has Nutrient/From Has/From PROD NUTR INGREDIENT et IngredientID Prod Only Amt IngredientName ProdOnly Units ProdSkimAmut ProdSkimUnits. Prod WholeAmt Bought From/Sells rodWholeUnits lsInP ntains ING SUPPLIER IngredientID Price NUTRIENT Nutrient NutrientName PROD VIT IRON Supplies/lsSuppliedBy Vitkron lslin/Contains. VITAMIN IRON ProdonlyRDA. ProdMilkRDA. SUPPLIER Vitron Name Description Sul ierName

Explanation / Answer

CREATE TABLE FDA_REPORT (ReportNumber integer, Date DATE ,Title varchar(20)) CREATE TABLE INGREDIENT (IngredientID integer, IngredientName varchar(10)) CREATE TABLE ING_SUPPLIER (IngredientID integer, SupplierName varchar(20), Price integer) CREATE TABLE SUPPLIER (SupplierName varchar(15)) CREATE TABLE COMPANY (CompanyName varchar(20)) CREATE TABLE PRODUCT (ProductID integer, ProductName varchar(20), ServingSizeOz integer, ServingSizeGrm integer, NumServings integer) CREATE TABLE PROD_NUTR(ProductID integer, NutrientID integer, ProdOnlyAmt integer, ProdOnlyUnits integer, ProdSkimAmut integer, ProdSkimUnits integer, ProdWholeAmt integer, ProdWholeUnits integer) CREATE TABLE NUTRIENT (NutrientID integer, NutrientName varchar(20)) CREATE TABLE PROD_VIT_IRON (ProductID integer, VitironID integer, ProdOnlyRDA varchar(30), ProdMilkRDA varchar(40)) CREATE TABLE VITAMIN_IRON (VitironID integer, VitironName varchar(20), Description varchar(100))

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.