Question: 1. Create a function to accept a student ssn as parameter and return the number of course sections the student registered. Create table Student
1. Create a function to accept a student ssn as parameter and return the number of course sections the student registered. Create table Student ( ssn numeric primary key, name char(50), address varchar(100). major char(10) ); Create table Course ( code char(10) primary key. title varchar(50) Create table Registered ssn numeric, code char(10), year int semester char(10). foreign key (ssn) references Student(ssn), foreign key (code) references Course(code), primary key (ssn,code, year,semester)
Step by Step Solution
3.34 Rating (157 Votes )
There are 3 Steps involved in it
To create a function in SQL to accept a student SSN as a parameter and return the number of course s... View full answer
Get step-by-step solutions from verified subject matter experts
