Lab 2 - E-R Design

Objectives: 

• Design entities and relationships for a db problem
• Translate an E-R design into SQL table

1. Domain description:

A Professor would like to assign projects to her students.  Each project has a name and description and she needs to keep track of the deadline and whether or not the project is completed or in progress.  Each student has a unique email address.  The students can work in groups on a single project and no two groups will work on the same project.  Each student will work in only one group and after the project is finished all students in the group will be given the same grade. 

Your task is to design a database system to facilitate the assignment and grading of the projects.

1. What are the entities and attributes?
    
2. What are the relationships?  Are there any attributes and roles?
    
3. What are the constraints?
    
4. Draw the E-R diagram.
    
5. Translate the E-R diagram to a relational model, giving the SQL CREATE statements that define the tables you need.

2. Complete problem 4.9 on p124