1) What are the primary two objectives of normalization (logicaldata modeling)?2) A 2nd normal form violation is called a______________________________________.
What does this mean?What will a 2NF violation lead to?3) Show an example of a first normal form violation.How would you fix it?4) Why do good database designers do logical data modeling?
5) To follow sound relational design principals, every attributein a relationship should be_____________________________ on the primary key.6) What is the general rule for knowing where to place foreignkeys?7) How do you show a foreign key in a logical data model?
1) What are the primary two objectives of normalization (logical data modeling)? 2) A 2nd normal form violation is calle
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am