HW

Question 1 (3 points) This normal form is violated when a single cell has a list of values or repeated columns (3 word answer or 1 word acronym): A This form of a table is violated when only part of a composite primary key is the determinant of a functional dependency for the table (3 word answer or 1 word acronym): A/ This form is violated when the determinant for a functional dependency is not a key for the table (3 word answer or 1 word acronym starting with a number): A Question 2 (5 points) Normalize the following table in first, second, and third normal forms. Be sure to show each of these forms separately. For second normal form, be sure to indicate what columns constitute the primary key of the incoming table before converting into 2NF. For your answer, it is critical that you maintain all the data from the original table. Your answer must either be an image (more than one is acceptable) uploaded using the camera icon or a document which can be uploaded using the "play" button to the left of the camera icon. No other mechanism for uploading answers will be accepted. Be sure to put your name and today's date on your answer. Please note that this question will not be automatically graded