Answer Happy

DevicelD Question 19 (2.5 points),✓ Saved Enforcing referential integrity ensures that There is a matching value for the foreign key in the corresponding parent table that the foreign key is linked to Jy There is a matching value for the primary key The foreign key of the tables are unique The primary keys of the tables are unique Question 20 (2.5 points) Saved In the following E/R model shown below, which table will get the foreign key
Saved Question 16 (2.5 points) Normalize the following relation to BCNF ITEM (Itemid, ItemName, SupplierID, SupplierName) Business Rules: Every item has a unique itemld. Every supplier has a unique supplier ID. A supplier can supply many items. An item is supplied by one supplier. ITEM (Itemld. ItemName, SupplierID) SUPPLIER(SupplierID, SupplierName) ITEM (Itemld. ItemName) SUPPLIER(SupplierID, SupplierName, Itemid) The relation is already normalized in BCNF ITEM (ItemID, SupplierID) SUPPLIER (SupplierID. SupplierName, ItemID)
Based on the E/R model, which table should get the foreign key Library Account P.K. Accountid AccountDescription Only Student entity Either LibraryAccount or Student entity Only LibraryAccount entity ONeither, an intersection entity needs to be created Question 16 (2.5 points) ✔ Saved Student Studenti StudentPhone StudentAddress