Exercise 7: Identify the Unique Identifier and corresponding Primary keys (1 point)

Overview

In this practice you identify the unique identifiers and the corresponding primary keys from the given scenarios.

Tasks

1. How do you find a particular song in the whole collection? What would be a unique identifier for SONG?

2. Think about all the students in the classroom. Each student is described by several traits or attributes. Which attribute or attributes allow you to pick a single student from the rest of the class?

3. For each entity, select the attribute that could be the unique identifier of each entity.

Entity: STUDENT

Attributes: student ID, first name, last name, address

Entity: MOVIE

Attributes: title, date released, producer, director

Entity: LOCKER

Attributes: size, location, number