what is the difference between first normal form & second
normal form?
Answer Posted / manoj gogoi
1NF: NO duplicate records.
2NF: No composite primary key
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
How to execute a stored program unit?
What is literal?
What privilege is needed for a user to query tables in another schema?
What is ceil and floor in oracle?
What types of joins are used in writing subqueries?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What do you mean by a deadlock?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the quickest way to fetch the data from a table?
How to use "in" parameter properly?
What is sequence?
what is insert all statement in sql
How to define a procedure inside another procedure?