Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DATABASE Administrator Make A Difference

Authors: Mohciine Elmourabit

1st Edition

B0CGM7XG75, 978-1722657802

More Books

Students also viewed these Databases questions

Question

differentiate the function ( x + 1 ) / ( x ^ 3 + x - 6 )

Answered: 1 week ago

Question

LO6 Describe how individual pay rates are set.

Answered: 1 week ago