Question: 3. Create the following tables, using MySQL CLI. Take a screenshot of each CREATE TABLE command being successfully executed Teacher Column Name Data Type Length
3. Create the following tables, using MySQL CLI. Take a screenshot of each CREATE TABLE command being successfully executed
Teacher
| Column Name | Data Type | Length | Decimal Places | Primary Key? |
| TeacherId | Integer |
|
| yes |
| firstName | VarChar | 50 |
|
|
| lastName | VarChar | 50 |
|
|
| hireDate | Date |
|
|
|
Subject
| Column Name | Data Type | Length | Decimal Places | Primary Key? |
| subjectNumber | Integer |
|
| yes |
| name | VarChar | 100 |
|
|
| gradeLevel | VarChar | 2 |
|
|
Class
| Column Name | Data Type | Length | Decimal Places | Primary Key? |
| teacherId | Integer |
|
| yes |
| subjectNumber | Integer |
|
| yes |
| studentNumber | Integer |
|
| yes |
| grade | Integer |
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
