Question: Create new database named schoolDB with two tables Student and Courses. Attributes for Student are: studentID, firstName, lastName, dateOfBirth, gender Attributes for Courses are: courseId,

Create new database named "schoolDB" with two tables "Student" and "Courses".
Attributes for Student are:
studentID, firstName, lastName, dateOfBirth, gender
Attributes for Courses are:
courseId, courseName, credits, department
Insert at least 5 rows into student table
Insert at least 3 or 4 rows in course table.
Queries :
Write a query to display all records from the Students table.
Write a query to update the CourseName in the Courses table where CourseID =2.
Add a new column called PhoneNumber to the Students table
Write a query to delete a student record from the Students table where StudentID =3.
Write a query to truncate all data from the Courses table without deleting the structure.
Write a query to drop the Courses table from the database.

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!