Interested to Buy Any Domain ? << Click Here >> for more details...
Explain 1st, 2nd, 3rd normalization form of data base
- 3 Answers
- 23022 Views
- KH, Thermotech, I also Faced
- E-Mail Answers
Answer Posted / padma
1st normal form: first identify the repeating group of
fields n group them into separate table
2nd normal: it should be in 1st normal form and check all
fields are dependent on primary key
3nd normal form: it should be in 2nd normal form and check
all the fields r independent of any other non-key attribute
ie removes the fields that dependent on non-key
1st normal: first identify repeating fields and group them
another table
2nd normal: it should be in 1st normal form and identify
that all fields all dependent on primary key.
3nd normal: it should be in 2nd normal form and check all
fields all indpendent of other non-key attribute
| Is This Answer Correct ? | 49 Yes | 5 No |
Post New Answer View All Answers
What is the quickest way to export a table to a flat file?
How to create a single index for multiple columns?
What is analyze command used for?
What are the differences between primary key and unique key?
How to return top 5 rows in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the difference between 10g OEM and 11g OEM?
What is set verify off in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is meant by joins?
What are the limitations oracle database 10g xe?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Write a trigger example in oracle?
How to use fetch statement in a loop?
