Answer Posted / babu vincent
Normalization:
normalization is used to reduce the repetition..
for example if a table contains a column repeating same datatype and for same purpose..
look at simple example a item purchased of a customer may contain many which also include separate prices so instead of creating repeated column for each item and price.. one table is created with one column for item name and one for column name.. then relationship(one to many) can be created and records in item table can be connected with cstomer table which includes order no as primary key..
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Can we create database in oracle using command line ?
What do you mean by group by clause?
How a tablespace is related to data files?
What is the dynamic sql in oracle?
State the difference between a primary key and foreign key?
What is the order of defining local variables and sub procedures/functions?
What is MTTR advisor in Oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is archive log in Oracle?
How to write an inner join with the where clause in oracle?
Write a syntax for update query in oracle?
How to assign values to variables?
Explain self joins in oracle?
What happens if you set the sga too low in oracle?
What is rowid and rownum in oracle?