Assume you have these tables.. Q) Write in SQL queries to populate the above tables by inserting minimum 4 tuples in each one. CREATE TABLE Student (studid Char(9) Primary Key, FirstName Varchar2(50) NOT NULL, LastName Varchar2(50) NOT NULL, Email Varchar2(50) NOT NULL UNIQUE, PhoneNumber Number(8) NOT NULL UNIQUE, DateOfBirth Date NOT NULL, GPA Number(1,2) NOT NULL); CREATE TABLE Club (clubID Number(3) Primary Key, ClubName Varchar2(20) NOT NULL, studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid)); CREATE TABLE MemberOf (ClubID Number(3) Primary Key, Studid char(9), JoiningDate date, Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid)); CREATE TABLE Activities (Actid Number(3) Primary Key, Acdt DATE NOT NULL, Place Varchar2(50) NOT NULL, durationNbHour Number NOT NULL); CREATE TABLE Organize (actid Number(3) Primary Key, clubID Number(3), Fee Number(4,2), Foreign Key(actid) references Activities(Actid), Foreign Key(clubID) references MemberOf(ClubID));
Assume you have these tables..
Q) Write in SQL queries to populate the above tables by inserting minimum 4 tuples in each one.
CREATE TABLE Student (studid Char(9) Primary Key,
FirstName Varchar2(50) NOT NULL,
LastName Varchar2(50) NOT NULL,
Email Varchar2(50) NOT NULL UNIQUE,
PhoneNumber Number(8) NOT NULL UNIQUE,
DateOfBirth Date NOT NULL,
GPA Number(1,2) NOT NULL);
CREATE TABLE Club (clubID Number(3) Primary Key,
ClubName Varchar2(20) NOT NULL,
studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid));
CREATE TABLE MemberOf (ClubID Number(3) Primary Key,
Studid char(9),
JoiningDate date,
Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid));
CREATE TABLE Activities (Actid Number(3) Primary Key,
Acdt DATE NOT NULL,
Place Varchar2(50) NOT NULL,
durationNbHour Number NOT NULL);
CREATE TABLE Organize (actid Number(3) Primary Key,
clubID Number(3),
Fee Number(4,2), Foreign Key(actid) references Activities(Actid),
Foreign Key(clubID) references MemberOf(ClubID));
Step by step
Solved in 2 steps
