Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Normalization Rules?
- 2 Answers
- 5727 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / p.thirugnanam
Noramlization means decomposing the tables and define well
structure to reduce the data reduntancy.
Normalization classified three types.
First Normalization form : It eliminate multiple values
atttributes.
Second Normalization form : It eliminate the partial
dependency.
Third Normalization form : It elimiate the functional
dependency.
Partial dependency means non-key value depends on one
primary key value.
functional dependency means two non-key values.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pavan
Normalization is the process of decomposing a larger table
into smaller tables inorderto free from the enamalies
reguarding insertion, deletion and alter.
Normal forms are: 1NF(Normal Form), 2NF, 3NF, BCNF, 4NF and
5NF.
The rules: No data loss.
Dependency preserving.
| Is This Answer Correct ? | 2 Yes | 1 No |
Describe the steps needed to execute a sql query using jdbc.
What are the types of statements in jdbc?
How to move the cursor in scrollable resultset ?
How to find number of records in result set?
How to insert an image or raw data into database?
Explain the difference between inner and outer join ?
Is oracle client required for jdbc connection?
What are the common jdbc exceptions?
How to check jdbc connection in java?
What is isolation level? How to set it?
What is a JDBC 2.0 DataSource?
can we define indexes on a foreign key? Explain pros and cons?
Core Java 
