Interested to Buy Any Domain ? << Click Here >> for more details...
Describe about first three Normal forms.
- 1 Answers
- 6663 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 |
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
how to dispaly a particular row details from a given table
What is meant by referential integrity?
What is the difference between online clustering and Offline clustering?
What are the types of indexing?
How to select true false based on column value in sql server?
What are trace flags?
ow to bring suspect mode datbase online from scratch
What does the on delete cascade option do?
What is buffer cash and log cache in sql server?
IN Vs OR operator which is best to use sql server.
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
-
Oracle (3259) - 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)
