Normalize the given table to 2NF and 3NF. (15mins) Happy Home Super market deals with groceries, household items, stationary products and gift items. They have announced a summer mela where, for every customer who holds a membership with Happy Home, any three items can be taken for free. The total price of the three items should be equal to or below Rs.1000. They record details of these free products given to their member customers in a table as below.
Answers
Answer:
xoxyoxyocohxlgxkgxogxochkditdursitfitdrits
Answer:
Is this table in the First Normal Form?
Yes. All the attributes contain only 1 atomic value.
Is this table in the Second Normal Form?
To verify this property, we need to find the functional dependencies which are holding in the User_Personal table, and have to identify a Primary keys.
Let us do that by using sample data. This leads to the following set of FD;
F = { UserID → U_email Fname Lname City States Zip,
Zip → City State }
A User ID attribute can uniquely determine all the other attributes, we can have User ID as Primary key for User_Personal table.
The next step is to check for 2NF properties;
Property 1 – The table should be at 1NF.
Property 2 – There should not be at any partial key dependencies.
Our table is 1NF, hence property 1 is holding.
Primary key of our table is UserID and UserID is the single simple attribute. As the key is not composite, there is absolutely no chance for partial key dependency to hold. Hence property 2 is also holding.
User_Personal table is 2NF.
Is User_Personal in 3NF?
To verify this we need to check all the 3NF properties;
Property 1 – Table should be a 2NF.
Property 2 – There should not be any Transitive Dependencies in table.
Table User_Personal is in 2NF, hence property1 is satisfied.
User_Personal table holds the following Transitive dependency;
UserID → Zip, Zip → City State
Hence, property 2 is not satisfied and all the tables are not in 3NF.
#SPJ2