DATABASE TO USE MYSQL

Phase 1: Database and Table Design

Phase 2: Queries and Joins

Phase 3: Programming and DML Automation using SPs, Triggers, etc.

With reference to the given diagram, please perform the following:

STEP 1: Design / Create a database with Files and File groups. Assume size is 100 MB per file for now.

STEP 2: Design / Create Tables with appropriate columns, provide correct/relevant data types and keys. Include Schemas for ease of access (as and where needed).

STEP 3: Define Relations between the tables (based on the arrow marks in the given schema)

STEP 4: Insert some data in each table (minimum of 3 to 10 values in each table) based on the relations. This way you would easily verify the correctness of if the data type for each column.

/**** PHASE 2 ****/

DEFINE DATASHEET ALL TABLES WITH SCHEMAS AND DATA TYPES : GO INTO INTO SHEET TABLES WITH DATA AND POSSIBLE SAMPLE INSERTS: ANOTHER SHEET

STEP 6: DEFINE ALL POSSIBLE QUERIES WITH JOINS [STORE IN VIEWS] ON DATABASE 45 SUCH COMIBINATIONS BASED ON GIVEN TABLE RELATION TEST EVERY VIEW USING EXCEL

ON LIVE SERVER: STEP 7: DEFINE SYNONYMS ON ALL TABLE AND POSSIBLE? THEN ON VIEWS ALSO