ITFN 1201 Foundations of Database Design

Assignment 1: Type your answers (not bold) to questions 1, 2, and 3 on this page.

Create a Power Architect diagram. See instructions below.

Consider this table

1. Assume that the data in the table is a true representation of the functional dependencies. List the functional dependencies.

2. There are two themes represented by the data in the table. What are they?

3. For each theme, identify any attribute that could serve as a candidate key. If there is no suitable candidate key for a given theme, create a surrogate key.

Use Power Architect to create a table for each theme you identified. Experiment drawing relationship lines from one table to another. Decide on a solution that you feel best represents the relationship. Use Power Architects File menu to export the playpen to a pdf file.

Submit two documents for this assignment:

1. This page with answers typed in for questions 1, 2, and 3.

2. A pdf of the diagram you created with Power Architect.