What is Normalization ?
Answer Posted / gaurav agrawal
Database normalization is a data design and organization
process applied to data structures based on rules that help
building relational databases. In relational database
design, the process of organizing data to minimize
redundancy is called normalization. Normalization usually
involves dividing a database into two or more tables and
defining relationships between the tables. The objective is
to isolate data so that additions, deletions, and
modifications of a field can be made in just one table and
then propagated through the rest of the database via the
defined relationships.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to return top 5 rows in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Explain a private synonyms?
Why do you create or replace procedures rather that drop and recreate.
What is an oracle and why it is used?
What is the use of aggregate functions in oracle?
What is execute immediate in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Explain the importance of .pll extension in oracle?
What are the roles of dba?
What is oracle server autotrace in oracle?
How to write text literals in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What are the ways tablespaces can be managed and how do they differ?
What is rowid and rownum in oracle?