Question: CASE STUDY: Having reviewed your logical models, Relationships and Normalization with the appropriate entities, you are now ready to move to the project - logical

 CASE STUDY: Having reviewed your logical models, Relationships and Normalization with

CASE STUDY: Having reviewed your logical models, Relationships and Normalization with the appropriate entities, you are now ready to move to the project - logical design and normalization. Your deliverable is the creation of a normalized dataset, tables ,relationship and keys identification. med element - Deliverables: Do Normalization by Applying UNF, 1NF, 2NF and 3 NF and List Dataset Find Tables and Set PK, FKs and Composite Keys. Establish a relationship between tables Note: you can use Access S/w or a Power point s/w to complete the task. Print screen the same and attach in word document TASKS You are to work with your group of 6 members to complete these tasks. 1. Normalize for inventory management system , identify dataset by applying UNF, 1NF, 2NF and 3 NF (10 marks) 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!