Interested to Buy Any Domain ? << Click Here >> for more details...
What is Normalization ?
- 55 Answers
- 87978 Views
- ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault, I also Faced
- E-Mail Answers
Answer Posted / shivag
The formal classifications describing the level of database
normalization in a data model are called Normal Forms (NF)
and the process of doing this is Normalization.
First normal form :
· A table is in first normal form when it contains no
repeating groups.
· The repeating column or fields in an un normalized table
are removed from the table and put in to tables of their
own.
· Such a table becomes dependent on the parent table from
which it is derived.
· The key to this table is called concatenated key, with the
key of the parent table forming a part it.
Second normal form:
· A table is in second normal form if all its non_key fields
fully dependent on the whole key.
· This means that each field in a table ,must depend on the
entire key.
· Those that do not depend upon the combination key, are
moved to another table on whose key they depend on.
· Structures which do not contain combination keys are
automatically in second normal form.
Third normal form:
· A table is said to be in third normal form , if all the
non key fields of the table are independent of all other non
key fields of the same table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert a date to char in oracle? Give one example.
What is clustered table in Oracle?
how to join query for one source type is oracle another source type is sql server ?
How do I escape a reserved word in oracle?
When system tablespace is created?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Is rowid unique in oracle?
What is a cognitive schema?
Explain the use of record option in exp command.
How can I combine multiple rows into a comma-delimited list in oracle?
How to export data to a csv file?
How do I reset a sequence in oracle?
What is tns entry?
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.
How to use subqueries with the in operator using oracle?
