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 rows into student table
Insert at least or 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
Add a new column called PhoneNumber to the Students table
Write a query to delete a student record from the Students table where StudentID
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
