Answer Posted / 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 |
Post New Answer View All Answers
Define database model.
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
Why would someone use a database?
What do you know about Master Data & Transaction Info Package?
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????
Explain about the properties of cursors?
How do you create a database?
What is ddl in dbms?
Explain the difference between primary and foreign key?
What are the advantages of a database?
What are the characteristics of dbms?
Mention some disadvantages of query?
What is database transaction?
What are vdl and sdl?
What is primary key in database?