Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started