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.
pt Create a Database Named School
pt Create the following tables with the specified columns and data types:
Students
studentidINT Primary Key, Auto Increment
firstnameVARCHAR
lastnameVARCHAR
emailVARCHAR
Courses
courseidINT Primary Key, Auto Increment
coursenameVARCHAR
coursecodeVARCHAR
Enrollments
enrollmentidINT Primary Key, Auto Increment
studentidINT Foreign Key references Studentsstudentid
courseidINT Foreign Key references Coursescourseid
enrollmentdateDATE
pt Insert at least three records into each table.
pt Update the email of one student in the Students table.
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
