Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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: 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started