Physical Database model Tutor

Focusing on only the Event and Facility tables, define a revised database schema using SQL DDL source code. Note that you can assume that Contact and Location are existing tables. You should all SQL needed to fully implement the tables including:

their columns with appropriate data types, lengths, and constraints (if any)

their integrity constraints (domain, entity, and referential)

their appropriate indexes

Use MySql

Use MySql SQL syntax for the purposes of this exercise. In the Related Course Materials section, you will find a quick reference guide to earlier version of MySql that is sufficient to accomplish the work.

Identifying Indexes

Sample Solution