Q2.3 marks (1 mark each)

Given the table of data below:

Products

ProductID

ProductName

BarcodeNumber

ManufacturerID

1

Baked beans

1234567890

3

2

Flakes of corn

8877665544

1

3

Fish bites

2233445566

3

Primary key = ProductID

Mahufacturers

ManufacturerID

ManufacturerName

1

Mellogs

2

Quality Foods

3

HFC inc.

4

Organic Supplies P/L

Primary key = ManufacturerID

a)For the tables above, which two rows of data could be deleted from one of the tables (specify the table) without generating a referential integrity error?

b)What is the problem with just putting the ManufacturerName in the Products table instead of the ManufacturerID and just doing away with the Manufacturer's table altogether?

c)What is the difference between an Entity and an Attribute in Entity Relationship (ER) modelling?

Q2. 3 marks (1 mark each) Given the table of data below: Products ProductID ProductName BarcodeNumber ManufacturerID 1 Baked beans 1234567890 2 Flakes of corn 8877665544 1 3 Fish bites 2233445566 3 Primary key = ProductID Mahufacturers ManufacturerID ManufacturerName 1 Mellogs 2 Quality Foods 3 HFC inc. 4 Organic Supplies P/L Primary key = ManufacturerID