Interested to Buy Any Domain ? << Click Here >> for more details...
please explain Nomalization in dbms?
- 5 Answers
- 8436 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankit srivastava
Normalization is the technique that removes redundancy in
table.It ensures that there is no any duplicate data in table.
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / venkatesh kumar.s
Normalization is the process of the analyzing given
relations schema based on functional dependencies and
primary key to acheive the desirable properties of
1)Minimizing the redundany
2)Minimizing the insertion,update and deletion problems
is called a normalization.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / voota durga prasad
Normalization is the process of designing a data model to
efficiently store data in a database. The end result is that
redundant data is eliminated, and only data related to the
attribute is stored within the table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ilaya
normalization is the process of the analyzing the related
database is functional dependencies and primary key is called
a normalization.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / ilaya
normalization is the process of the analyzing the related
database is functional dependencies and primary key is called
a normalization.
| Is This Answer Correct ? | 2 Yes | 1 No |
What is dbms language?
What is a Database Schema and Why is It Important?
How do I check my drivers?
How to debug stored procedures?
How do you handle your own transaction?
Can you explain fourth normal form and fifth normal form ?
What do you mean by fill factor concept with respect to indexes?
Is it good to save image in database?
What integrity rules exist in the dbms?
What is database development process?
What are the benefits of database management system?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
-
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)
