Question
Assume that ABC is same person and address and Mobile number are multivalued. Find out in which normalization form the table is in. Normalize the
Assume that ABC is same person and address and Mobile number are multivalued. Find out in which normalization form the table is in. Normalize the table up to 3NF
Full Name ABC DEF ABC Address 21, Uttara, Dhaka 33 Mirpur Dhaka 22, Uttara Movies rented The boss baby, Spiderman 1, Batman 2 Pirates of Carribean, Spiderman 1, Batman 2 Khoj the search, The boss baby Movie Duration 90, 120, 110 Genre 160, 90 Kids, Fantasy, Action 150, 120, Fantasy, 110 Action Funny, kids Salutation Salutation Phone ID 1 2 1 Mr. Mrs Mr 01655555555555 09666666 01911111111111
Step by Step Solution
3.53 Rating (170 Votes )
There are 3 Steps involved in it
Step: 1
The given table is in the first normal form 1NF because it has no repeating groups To normalize the ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Income Tax Fundamentals 2013
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
31st Edition
1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516
