CMIS 320 (CMIS 320)

CMIS 320 Project 4 Examine the following relation and its attributes and answer the following questions. Assume these are the values for “all time”. Assume girls with the same name are the same person. 1) Is this relation in at least 1NF? Why or why not? Yes, it is in 1NF. Each column only contains a single value and there are no duplicated rows in the table. 2) What is the primary key of the initial relation (assume the values shown are the only possible tuples for all time)? Rememb...

CMIS 320 Project 4 Examine the following relation and its attributes and answer the following questions. Assume these are the values for “all time”. Assume girls with the same name are the same person. GIRL GROUP AGE GAME CATEGORY PRICE Charlotte 5 year olds 5 Mirror Makeup 4.88 Susan 6 year olds 6 Lipstick Makeup 5.95 Jane 5 year olds 5 Chess Games 7.55 Susan 6 year olds 6 Checkers Games 5.95 Susan 6 year olds 6 Mirror Makeup 4.88 Carrie 6 year olds 6 Lipstick Makeup 5.95 Jacqueline 5 year...