DBAS27198 Exhibits DB

In this project, your team is asked to design and implement the database component of a Web app for Toronto attractions and events. Few wireframe screens (you will find them at the end of this document) were made during the requirements analysis of the project and those screens will be your main source of information on the entities, attributes and relationships between the entities.

More specifically, your tasks are:

1. Design all the necessary tables where all the relevant data can be efficiently stored

Include ER-diagram, data structure diagram,

- if using bottom-up approach include normalization/integration report (showing the steps of normalization/integration)

- or use top-down approach (include bubble diagram, ER-diagram, data structure diagram)

2. Write all the SQL code to support the application

SQL code:

• You must submit the SQL code to create all the tables in proper order using MySQL or MS SQL Server standards (please specify at the beginning of your project which software platform you are using).
• You must write the SQL code to populate the tables in correct order.
• You must also write the SQL queries to pull the data from the various tables into the grid formats shown on the mock-up pages. (Please note that you might have to join or sub-query your tables together to produce the grids exactly as shown.)

Appendix: Wireframes

Figure 1: see image.

Figure 2: see image.

Figure 3: see image.