Interested to Buy Any Domain ? << Click Here >> for more details...
Describe about first three Normal forms.
- 1 Answers
- 6724 Views
- HP, I also Faced
- E-Mail Answers
1)1NF
->it has a primary key.
->Each column is atomic.
2)2NF
->It is in 1NF
-> Every non-key column is fully functinally dependend on
primary key.
3)3NF
->It is in 2NF
->Every non-key column is functinally dependend only on
primary key.
->non-key column cant be dependend on another non-key colum.
| Is This Answer Correct ? | 6 Yes | 0 No |
What does it mean to invest in the index?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
what is a join and explain different types of joins? : Sql server database administration
How do I edit a stored procedure in sql server?
What program is used to store the data source file?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain contrast amongst grouped and non-bunched records?
Explain cross join or cartesian product in sql?
What is row_number () and partition by in sql server?
what is statistics
Can foreign key be deleted?
What are ddl triggers and types of ddl trigger?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
