Question

QUESTION 1 The following tables form part of a database held in a relational DBMS for storing the information of Customer, Item, Transaction, and temSale A transaction can contain multiple items and an item can be in multiple transactions as depicted in the following sample data Item(itemid, name, category, price Itemid pk) name category price Iteml Pencil Stationery $30 paperStationery Item2 $25 $15 Item3 Cards Stationery S40 Item4 Ink Stationery S13 Item5 Sprite Itemo Food S4 Milk Food Transaction ctransid, custid, date) Click Save and Submit to save and submit. Ciok Save all Anseers o saee all ansuers Transid(pk) Custid fk) Date Trans1 C1 March 1, 2019 Trans2 C1 March 2, 2019 Trans3 C2 March 2, 2019 Trans4 C3 March 10, 2019 Trans5 C3 March 20, 2019 Item sale(transid, itemid, qty) transid (pk,fls) itemid(pk,k) Trans1 Item 1 Item2 Trans1 Trans2 Item3 Item2 Trans3 Item3 Trans3 Item5 Trans4 Item6 Trans5 Click Save and Submit to save and submit. Click Save All Ansvers to save all ansvers Question Completion Status: Customer(custid, name, street-addr, city) street-addr Custid(pk) name Ci Don Wei 199 Chambers st New York C1 1 First St Eric Smith C2 New York Mary C3 Nicholas New York where primary keys are underlined, and item contains item details and itemid is the primary transaction contains transaction details and transid is the primary key itemsale contains the details of item sold with quantity through a particular transaction and (transid, itemid) together is the primary key customer contains customer details and custid is the primary key (a) If one tries to insert a new row into the item table with (item5, Orange, Food,5). Does this insertion operation cause a violation of any integrity rule? Why? (5 pts) Ciok Save and Submit to save and submit, Cliek Save -0 Anaeere ro sov all ansoers a Question Completion Status contains customer details and custid is the primary key (a) If one tries to insert a new row into the item table with ('items, Orang cause a violation of any integrity rule? Why? (5 pts) ', Food 5). Does this insertion operation (b) If one tries to insert a new row into the itemsale relation with (Transs, Item7, 4). Does this insertion operation cause any violation of any integrity rule? why? (5 pts) (c) If one tries to insert a new row into transaction relation with (Transs', C5', March 19,2019'). Does this insertion operation cause any violation of any integrity rule 2why?(5 pts) TT Í 쫓 Paragraph.. Arialー." 3(12pt)-,ー:1= . T.. Click Save and Submit to save and submit. Click Save All Anstvers to save all answers 02 02

Answer 1

The integrity rules in dbms are:

1) No component of the primary key of a base relation is allowed to accept nulls.

2)Nulls cannot be in primary keys, but can be in alternate keys.

3) A foreign key is an attribute of one relation R2, whose values are required to match those of the primary key of some other relation R1

a) If one tries to insert a new row into the item table with (item5, orange, food, 5), the insertion will violate the third integrity rule because the primary key here is doubled as there is already item5,food present in the column.

Part b and c does not violate the integrity rule .