Question: Write the following SQL queries based on the following relational schema: Student(stdID: char(5), stdName:varchar(50), age: number, addr Course(crscode: char(5), crsName:varchar (50), crscredit:numbe Enrol(stdID: char(5), crscode:

 Write the following SQL queries based on the following relational schema:
Student(stdID: char(5), stdName:varchar(50), age: number, addr Course(crscode: char(5), crsName:varchar (50), crscredit:numbe Enrol(stdID:

Write the following SQL queries based on the following relational schema: Student(stdID: char(5), stdName:varchar(50), age: number, addr Course(crscode: char(5), crsName:varchar (50), crscredit:numbe Enrol(stdID: char(5), crscode: char (5), trimester:number(1), e Programme(prgCode: char(5), prgName: varchar(25)) Add a new student record into the student table: [5 marks] name=Joey Whales; stdID=JW136; age=17; address =85 Wimmer Write the following SQL queries based on the following relational schema: ar(50), age: number, address: varchar(250), prgcode: char(5)) lar(50), crscredit: number(1)) trimester: number(1), enrYear:date, mark: num(2), tuitionfee: archar(25)) Add a new student record into the student table: [5 marks] ; address =85 Wimmera St, Balywn, VIC 3134; prgCode=CS100

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 Databases Questions!