MySQL Question
Objectives
Create a MySQL Schema
Create and drop a database tables using appropriate data types and indexing
Describe and create table constraints
Code primary key constraints
Create and drop indexes
Create a backup file of your database
Description
This database will be used by a college to build a class schedule from courses that are available in the curriculum. The database tables need to be built with appropriate fields and relationships defined.
Requirements
Read Murach textbook: Chapter 11 and 19.
Review the linked lecture article(s).
Create new MySQL database tables.
Identify the attributes, their data types and lengths for each field in your tables.
Write a script to create the table structures for each of your tables.
Be sure to include all primary key constraints.
Add sample data to each of your tables.
Create a single file table definition using mysqldump or the WorkBench.
Add the SHOW TABLE STATUS for all tables at the end of the script.