Question

In: Computer Science

Can a table that is already in 1NF be in 2NF and 3NF without making any...

  1. Can a table that is already in 1NF be in 2NF and 3NF without making any changes? Explain and give one specific example of such table.

Solutions

Expert Solution

Sol.

Claer Answer Is NO....

Why? First understand what is first normal form...

First normal form eliminate all multiple entries for single attributes. like one student have more than 1 contact no.

Ex.

Name id contact no. state
Rohan 1 83****2772, 99**162161 RAJ
Aksthat 2 99***72737 U.P
Ramesh 3 98***66262 M.P

So, in this table we have entry anme rohan which is having multiple contact no. so thsi table is not in first normal form.

And above quetion author examiner about If a table which is already in 1NF can be in 2NF and 3NF..

let's understand when we eleminate multiple entries then relation come into 1NF and after if we want to convert this rellation in 2NF then we need to eleminate partial dependencies. And we convert into 3NF if we have relation in 2NF to convert into 3NF we need to eleminate transitive dependencies from the relation or table..

So,the map of the normal form will be .

plzz upvote..


Related Solutions

Normalize the following table into 1NF, 2NF and 3NF. Salesperson name Sales area Customer Number Customer...
Normalize the following table into 1NF, 2NF and 3NF. Salesperson name Sales area Customer Number Customer Name Warehouse Number Warehouse Location Sales Amount 76458 Hariharan East 17658 Asani 3 Govandi 13545 17645 Madhuram 6 Vasai 10600 17623 Sumit 6 Vasai 9700 76567 Dheerendra North 18190 Dhanram 4 Thane 11560 18173 Toshi 4 Thane 2590 18150 Ganesh 1 Kalyan 8090
Covert the schema into 2NF and 3NF TableD (D1,D2,D3,D4,D5) functionally dependencies: D4 --> D2 Answer: Relation1:...
Covert the schema into 2NF and 3NF TableD (D1,D2,D3,D4,D5) functionally dependencies: D4 --> D2 Answer: Relation1: Relation2:
For this question, normalize the table to 3NF and draw the relational schema showing cardinalities. UCLA...
For this question, normalize the table to 3NF and draw the relational schema showing cardinalities. UCLA just purchased several servers that are to be used for enterprise resource planning (ERP). The individual servers were purchased from different suppliers and these servers are running different software applications. UCLA also trained several of its staff to use these servers and each trained staff has an authentication code that allows the staff to use a specific software application on a specific server for...
in c++, without using any built-in random library already exist, instead,write your own function to generate...
in c++, without using any built-in random library already exist, instead,write your own function to generate random char from a list of: 10 letters T 10 letters H 10 letters A 10 letters N 10 letters K
Decision making can be viewed as an eight-step process, use these steps in making any decision....
Decision making can be viewed as an eight-step process, use these steps in making any decision. Please use your own example and do not take the examples from the PowerPoint presentation (buying a car or a computer)
I'm not clear with decompose to 3NF for database. Can someone explain to me with example...
I'm not clear with decompose to 3NF for database. Can someone explain to me with example please?
Consider following table - Convert it to 3NF StdSSN StdCity StdClass OfferNo OffTerm OffYear EnrGrade CourseNo...
Consider following table - Convert it to 3NF StdSSN StdCity StdClass OfferNo OffTerm OffYear EnrGrade CourseNo CrsDesc S1 SEATTLE JUN O1 FALL 2006 3.5 C1 DB S1 SEATTLE JUN O2 FALL 2006 3.3 C2 VB S2 BOTHELL JUN O3 SPRING 2007 3.1 C3 OO S2 BOTHELL JUN O2 FALL 2006 3.4 C2 VB
I saw that this was solved already, but it's hard to learn it without an explanation...
I saw that this was solved already, but it's hard to learn it without an explanation on how the figures were calculated. Using the following information you are to prepare a comprehensive budget for River City Micro Systems, Inc. The Company assembles a specialized device used in airports to detect certain types of explosives to prevent terrorist attacks. Arrangements have been made for the component parts (bundled in packets, one per unit) to be produced in Indonesia, shipped to Boise,...
How can you be invited to the table to be an active participant in decision making...
How can you be invited to the table to be an active participant in decision making that influences your practice?
Create a table in SQL with foreign key reference: 1.Create the three tables without any columns...
Create a table in SQL with foreign key reference: 1.Create the three tables without any columns 2.Alter the tables to add the columns 3.Alter the tables to create the primary and foreign keys
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT