Explain in approximately one paragraph why the requirements analysis phase of the database lifecycle is so important. Include the type of information you typically want to discover and the types of outputs you typically want to have in this phase.

Explain the difference between an entity type and an entity occurrence.

Explain the difference between a relationship type and a relationship occurrence.

What is the difference between a candidate key and a primary key?

Which of the following would be more appropriate primary keys for the given entity types? Why?

Employees: Last Name vs. Social Security Number

Employees: Address vs. Employee ID

Branches: Branch Number or Branch Name

Courses: Course Name or Course ID

Draw an ER diagram (excluding structural constraint notation), showing the relationships for the following descriptions (all you need to include for this example is the labeled entity types and the labeled relationship type, with arrow indicating direction):

Instructors & Courses

Courses & Students

Customers & Orders

Stores & Products

Albums & Songs

Now, draw the same ER diagrams as you did in Question 4, but now write below the diagram what the cardinality is for each relationship. Additional info about each relationship has been added below.

Instructors & Courses (An instructor can teach many courses. A course can be taught by only one instructor)

Courses & Students (A course can be taken by many students. A student can take many courses)

Customers & Orders (A customer can make many orders. An order can be made by only one customer)

Stores & Products (A store can sell many products. A product can be sold in only one store)

Albums & Songs (An album can contain many songs. A song can be included on many albums)

Lastly, draw the same ER diagrams but include both the cardinality and participation notation within the diagram. Additional info has been added to help you determine each entity types participation type.

Instructors & Courses (An instructor can teach many courses and has to teach at least one. A course must be taught by one and only one instructor.)

Courses & Students (A course can be taken by many students but must have at least one student. A student can take many courses but must take at least one)

Customers & Orders (A customer can make many orders but must make at least one. An order can be made by one and only one customer)

Stores & Products (A store can sell many products but must sell at least one. A product can be sold in one and only one store)

An album can contain many songs but must contain at least one. A song can be included on many albums but must be included on at least one)