CMIS 320 Project 4.docx - CMIS 320 Project 4 CMIS 320 UMUC Bilawal Cheema March 5 2017 2 CMIS 320 Project 4 Examine the following relation and its

CMIS 320 Project 4.docx - CMIS 320 Project 4 CMIS 320 UMUC...

This preview shows page 1 - 4 out of 7 pages.

CMIS 320 Project 4 CMIS 320 UMUC Bilawal Cheema March 5, 2017
Image of page 1
2 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 olds 5 Visual Basic Prog. Languages 199.99
Image of page 2
3 1.Is this relation in at least 1NF? Why or why not? 2.What is the primary key of the initial relation (assume the values shown are the only possible tuples for all time)? Remember that a primary key must be unique and not null.
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture