Explain 1st, 2nd, 3rd normalization form of data base
Answers were Sorted based on User's Feedback
Answer / padma
1st normal form: first identify the repeating group of
fields n group them into separate table
2nd normal: it should be in 1st normal form and check all
fields are dependent on primary key
3nd normal form: it should be in 2nd normal form and check
all the fields r independent of any other non-key attribute
ie removes the fields that dependent on non-key
1st normal: first identify repeating fields and group them
another table
2nd normal: it should be in 1st normal form and identify
that all fields all dependent on primary key.
3nd normal: it should be in 2nd normal form and check all
fields all indpendent of other non-key attribute
Is This Answer Correct ? | 49 Yes | 5 No |
Answer / misam ami
1st normal: A relvar is in 1NF if and only if,in every every legal value of that relavar,every tuple contains exactly one value for each attribute.
3rd normal: A relvar is in 3NF if and only if for all time,each tuple consist of a primary key value that identifies some entity,together with a set of zero or more mutually independent attribute values that describes values that describe that entity in some way.
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / ramprasad.s
HI
First Normalisation is "Primary Key"
Second Normalisation is " Composite Key"
bye
sun_ramprasad@yahoo.com
Is This Answer Correct ? | 8 Yes | 36 No |
What is oracle used for?
Will you be able to store pictures in the database?
What is a trigger oracle?
what is a view?
Is there an oracle sql query that aggregates multiple rows into one row?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How do we create privileges in oracle?
What is catalog in Oracle?
What happens to the current transaction if a ddl statement is executed?
Explain about functional dependency and its relation with table design?
How to remove a row in a database table?