Based on the ERD , above you will need to draw a Schema to answer the 5 question
ID: 3709921 • Letter: B
Question
Based on the ERD , above you will need to draw a Schema to answer the 5 questions below.
(1) The table with the most number of columns in the Schema is:
(a) Aisle
(b) For
(c) Product
(d) Coupon
(e) Contains
(2) The following are non-existent tables in the Schema
(a) Has
(b) For
(c) Contains
(d) Product
(e)Aisle
(f) Coupon
(g) ID
(h) Name
(3) Which tables will the ID attribute in Product table be linked to?
(a) Coupon
(b)Department
(c) Has
(d) Aisle
(e) None of the these
(4) The table(s) with two underlined attributes is/are:
e) Coupon
(5) How many tables are there in the Schema for the above ERD ?
(a) 3
(b) 6
(c) 4
(d) 7
(e) 5
a Product Based on the following ERD, you will need to draw a Schema to answer the 5 questions below: ID ID Cont- ains Name Aisle Department Name Has Price SKU Product For Coupon SalePrice ID Name Weight Expires IDExplanation / Answer
Dear Student ,
As per the requirement submitted above , kindly find the below solution. Here based on above ERD below is schema
1. Aisle (ID -Primary Key ,Name ,Department_Id - Foreign Key_
2.Product (ID -Primary Key,Name ,Price ,SKU ,Weight,Aisle_ID - Foreign Key )
3.Coupon (ID - Primary Key , Expires ,SalesPrice ,Product_ID - Foreign Key)
4.Department (ID -Primary Key ,Name)
Following section gives answers of the above question
1.The table with the most number of columns in the Schema is:
As per the above schema product table is having maximum columns that is six.
(c) Product
2.The following are non-existent tables in the Schema
By refering above schema , tables are product , Aisle ,Coupon and Department so non existent tables are
(a) Has
(b) For
(c) Contains
(g) ID
(h) Name
(3) Which tables will the ID attribute in Product table be linked to?
As per the schema given above Aisle table primary key acts as foreign key in Aisle table.
(d) Aisle
(4) The table(s) with two underlined attributes is/are:
a.Product
(5) How many tables are there in the Schema for the above ERD ?
As per schema given above there are 4 tables so answer is
(c) 4
NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.