Question

1. To be in the third normal form,

   Hint: In order to in 3NF you must first have attained 1NF and 2NF so all of the above is the correct answer. In the database design world the saying is that to be completely normalized the data be represented "by the key, the whole key, and nothing but the key so help me Codd". Ted Codd was the person behind the development of the relational theory back in the 1960s and 70s.

   	a.	each non-key column must depend only on the primary key
   	b.	all of the above
   	c.	the non-key columns must not contain repeating values
   	d.	each non-key column must depend on the entire primary key

10 points

Question 13

1. To enforce referential integrity, the database can

   	a.	return an error instead of doing the requested action
   	b.	do the requested action and do the related changes to the related tables
   	c.	do the requested action and mark any orphans in related tables
   	d.	a or b
   	e.	a or c

10 points

Question 14

1. When you identify the data elements in a new database, you typically subdivide data elements into

   	a.	the smallest practical components
   	b.	components that can be easily parsed each time you use them
   	c.	the largest practical components

10 points

Question 15

1. Which of the following diagrams best represents the relationship between a table of customers and a table of orders placed by customers?

   	a.
   	b.
   	c.
   	d.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question 12:

Answer :b.all of the above

Explanation :To be in the 3NF table should be in 1NF and 2NF and repeating group of columns are not allowed.

*******************************

Question 13:

Answer :d.a or b

Explanation :return an error instead of doing the requested action and do the requested action and do the related changes to the related tables.

*******************************

Question 14:

Answer :a.the smallest practical components

Explanation :When you identify the data elements in a new database, you typically subdivide data elements into the smallest practical components.

*******************************

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.