Out: 16 September 2024
Due: 9 October 2024, 3:30pm, one per team

Design E-R and relational models for the database supporting your online travel reservation web site. Your E-R and relational models should conform to the specification and requirements given in the Project Specification Document. All work should be in Word, google doc, or some other appropriate document-preparation software, and submitted as a PDF file.

Please submit your assignment on BrightSpace by the due date. Make sure your names are clearly indicated on the first page. Only one member of each team should submit the assignment.

Your document is required to contain the following information:

• The name of your team (i.e. this should also be the name of your online travel resevation system).
• The names and e-mail addresses of the three team members
• E-R diagram capturing the conceptual design of your database system. Your E-R diagram should look like the ones in the course textbook. That is, rectangle shapes should be used for entity types, diamond shapes should be used for relationship types, etc.
• Brief rationale (in English) for your E-R model
• Relational model of your database system, based on your E-R design. Your relational model should be given in the form of SQL 92 or SQL 99 CREATE TABLE|VIEW|INDEX etc. statements. Try to use those features and only those features of SQL supported by MySQL or SQL Server.
• The SQL description of your relational model should include as many integrity constraints as possible, including domain, key, and referential integrity constraints.
• Brief rational (in English) for your relational model.