Computer Science Homework Help

I need someone to tutor mExamine the Catering LDM

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

For each table, consider which individual or grouped attributes would you want to find rows quickly by or would want to sort by. The individual and groups of attributes will form the keys for each index.e on physical database modeling i.e indexing and schemas