QUESTION 1 6-1 Question 1 Match the type of Unique identifier to the entity. A. Composite UID STORE # address (#) city B. Simple UID C. Primary key & Secondary Key D. Composite UID comprising an attribute and a relationship ACCOUNT #number o balance COMPANY #number o name RACER #last name #phone number BOAT #vin QUESTION 2 6-1 Question 2 Consider an entity for Library Member. Sometimes an entity can have more than one can-didate UID. Describe a scenario where you would want more than one candidate UID for a Library Member - why would you want to find the member in the database using alterna-tive information? QUESTION 3 6-1 Question 3a Describe how you would identify the entity below, making up any attributes and relationships you consider appropriate. For example, for the Student entity you may say that the UID is comprised of the first name, last name, and address. Or you might suggest that the Student entity contains an artificial UID called student number. City QUESTION 4 6-2 Question 1 When checking a database model for first normal form what are you doing exactly? QUESTION 5 6-2 Vocab Match the vocabulary word for each definition A. Normalization The outcome of the first step of database normalization. 1NF eliminates repeating groups by putting each into a separate table and connecting them with a 1:M relationship B. First Normal Form (1NF) A series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redun-dancy and the chances of data becoming inconsistent