MySQL Database Schema (20 Points)
Provide a self-contained file of your database. This file should contain all necessary DDL and
DML for creating your database. Please include tuples within your database so the system can
be easily evaluated. (For example it should contain the create commands for the objects within
your database: tables, indexes, constraints etc. It should also contain a dump of the data as well
as the user-defined functions, procedures and triggers). The schema should contain the
following:
1. SQL: There should be at-least 4 tables in your SQL schema. All tables should be
normalized to 3rd normal form. There should not be any unnecessary redundancy in
your tables. (1-5 Points)
2. Tables should have a primary key and if applicable foreign keys representing
relationships in your class diagram. (1- 5 Points)
3. Project is modular and uses server side user defined functions, procedures, triggers,
events. Front end code does not contain excessive SQL code. (1-5 points)
4. Provide integrity constraints such as action to be performed for foreign keys ON
DELETE, ON UPDATE on tables. Also provide additional constraints on fields that are
not part of the key (1-5 Points)
5. BONUS POINTS: Complicated schema (1-5 points)
6. BONUS POINTS: Identifying fields for secondary indexes. ( 1-5 points) Succinctly
justify your index choice within code comments. (Total bonus points that can be
allotted for the project is 10 points)
MongoDB Database Schema (20 points)
1. The schema should contain all necessary data/commands for recreating your database. It
should identify the containers of the system, the embedded objects and containers that
may reference other documents. You should have at least one container in your
MongoDB database with an embedded object or an array field. (15 points)
2. Schema should identify known optional fields. (5 points)
3. BONUS POINTS: Identifying fields for secondary indexes. (1- 5 points) Succinctly
justify your index choice within comments in your code.