CS 377 - Database Systems
Homework 2: Relational Database Design


Out: Thursday, September 08

Due: Thursday, September 15, 11:59pm




  1. Map the ER diagram from Homework 1 for the Emory College database into a relational database.  Specify all primary keys and foreign keys.
  2. Reverse engineer a website of your choice (e.g. Amazon, eBay, Delta airline reservations system) by giving an ER diagram of the information that it contains and then map it into a relational database. You can make simplifying assumptions and only represent the key information but be clear about your assumptions.




·         Please submit your homework as a PDF file in your cs377 directory as ~/cs377/hw2/hw2.pdf