Please attach a revised copy of your E/R schema from the first deliverable. Even if you have modified your design (due to feedback or any other reason), the new design will not be graded but will be compared with your relational design.

1. (25 points)
   Use the method for translating an E/R diagram to relations described in class to produce a set of relations from your E/R design. Specify your relational schema using the notation of
    
   Relation-name(attribute₁, attribute₂, ..., attribute_n).
    
   Please be sure to underline primary key attributes and explicitly specify all other integrity constraints that hold and/or should be enforced on your relations (i.e. specify foreign key info (bold or italics), data type info, value range, etc.).
    
   
2. (25 points)
   Is your relational schema in third-normal form (3NF)? If not, why not? Are there opportunities to combine relations without introducing redundancy? If so, indicate which relations, and if not, tell us there are none. For each opportunity to combine or decompose relations, decide whether or not to do so, and explain your reasoning briefly (e.g., tell what queries you expect will be typical for your database, and tell how the design you pick facilitates them).
    
   
3. (0 points)
   Is there anything you still do not like about the schema (e.g., attribute names, relation structure, duplicated information, etc.)? If so, modify the relational schema to something you prefer. You will be working with this schema quite a bit, so it is worth spending some time to make sure you are happy with it.