Tyger Valley Pet Shelter (TVPS) receives food donations from a group of pet food manufacturers. TPS relies on each manufacturing company for a particular need. For example, Veggie Land supplies all the vegetables and Premier Seed Suppliers supplies all the seeds. The different food types are allocated to the animals according to their category. For example, food type 'seeds' is allocated to category 'Birds', while food type 'vegetables' is allocated to the categories 'Mammals' and 'Birds'. Each animal category is subdivided into different pet types. For example, the mammal record could relate to pet types 'Dog' and 'Cat'. TPS has recruited you to be their database designer. The database will store information on their suppliers, food types, animal categories and pet types: Record a unique ID, company name, contact number and possibly an e-mail address for each manufacturer. When recording information about the different food types, ensure that the expiry date is also stored. When recording how much food will be allocated per animal category, specify the quantity and the unit of measurement as two separate fields. For example, if 8.5 kg of Roast Chicken Pellets is allocated to category 'Mammals', '8.5' and 'kg' will be two different fields. The number of pets for each pet type must also be stored together with the pet type so that the number is known for each category. For example, there are 10 dogs and 20 cats for category 'Mammals', or 40 parrots for category 'Birds'. PLEASE GIVE ME THE FOLLOWING USING THE INFORMATION ABOVE : Normalisation 0NF Normalisation 1NF Normalisation 2NF Normalisation 3NF
Tyger Valley Pet Shelter (TVPS) receives food donations from a group of pet food manufacturers. TPS relies on each manufacturing company for a particular need. For example, Veggie Land supplies all the vegetables and Premier Seed Suppliers supplies all the seeds.
The different food types are allocated to the animals according to their category. For example, food type 'seeds' is allocated to category 'Birds', while food type 'vegetables' is allocated to the categories 'Mammals' and 'Birds'.
Each animal category is subdivided into different pet types. For example, the mammal record could relate to pet types 'Dog' and 'Cat'.
TPS has recruited you to be their
Record a unique ID, company name, contact number and possibly an e-mail address for each manufacturer.
When recording information about the different food types, ensure that the expiry date is also stored.
When recording how much food will be allocated per animal category, specify the quantity and the unit of measurement as two separate fields. For example, if 8.5 kg of Roast Chicken Pellets is allocated to category 'Mammals', '8.5' and 'kg' will be two different fields.
The number of pets for each pet type must also be stored together with the pet type so that the number is known for each category. For example, there are 10 dogs and 20 cats for category 'Mammals', or 40 parrots for category 'Birds'.
PLEASE GIVE ME THE FOLLOWING USING THE INFORMATION ABOVE :
- Normalisation 0NF
- Normalisation 1NF
- Normalisation 2NF
- Normalisation 3NF
Step by step
Solved in 3 steps
