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
Part I Define 1NF 2NF 3NF BCNF State the difference between 3NF and BCNF. Give one...
Part I Define 1NF 2NF 3NF BCNF State the difference between 3NF and BCNF. Give one example schema that violates each of the following 1NF 2NF 3NF Your answer should contain three different schemas, one for each case.
Normal Forms (a) Briefly describe 1NF, 2NF and 3NHF
3. Normal Forms (a) Briefly describe 1NF, 2NF and 3NHF (b) The following statements are in relation to the second normal form (2NF). Which ones are true? (1) The table also has to be in INF 2) The table also has to be in 3NF 3) The table is only allowed to have atomic values in its cells 4) The primary key is not allowed to consist of multiple attributes. 5) Every non-key attribute depends on the complete primary key 6) Every non-key attribute is only allowed...
Select a Database of your own choice and apply the first three normalization processes. (1NF, 2NF...
Select a Database of your own choice and apply the first three normalization processes. (1NF, 2NF & 3NF) • The minimum number of records in the table must be 10 • Make sure you carry the same table from 1NF to 2NF and 3NF, do not use separate tables from scratch for all the three forms. • Brief explanation of the normalization processes must be specified
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?
Demonstrate 1NF Normalization Techniques Procedure Bring the following table structure to first normal form and explain...
Demonstrate 1NF Normalization Techniques Procedure Bring the following table structure to first normal form and explain the errors in the current structure. Your submission can be drawn in Word or hand drawn and attached to your submission. Be sure to write out your explanation of the errors in the normal form. Instructor Name Instructor Phone Instructor Email Course Name Course Number Course Description Student1 Name Student1 Phone Student1 Email Student1 GPA Student2 Name Student2 Phone Student2 Email Student2 GPA …...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT