Question: Create a database by following below questions. 1 . [ 3 pt ] Create a Database Named ` School ` . 2 . [ 3

Create a database by following below questions.
1.[3 pt] Create a Database Named `School`.
2.[3 pt] Create the following tables with the specified columns and data types:
Students
-`student_id`(INT, Primary Key, Auto Increment)
-`first_name`(VARCHAR(50))
-`last_name`(VARCHAR(50))
-`email`(VARCHAR(100))
Courses
-`course_id`(INT, Primary Key, Auto Increment)
-`course_name`(VARCHAR(100))
-`course_code`(VARCHAR(10))
Enrollments
-`enrollment_id`(INT, Primary Key, Auto Increment)
-`student_id`(INT, Foreign Key references Students(student_id))
-`course_id`(INT, Foreign Key references Courses(course_id))
-`enrollment_date`(DATE)
3.[3 pt] Insert at least three records into each table.
4.[3 pt] Update the email of one student in the `Students` table.
5.[3 pt] Delete one record from the `Enrollments` table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!