1) What are the primary two objectives of normalization (logical data modeling)? 2) A 2nd normal form violation is calle
Posted: Sun Jul 03, 2022 11:21 am
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?
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?