Question: Format the plain SQL code to JAVA SQL code. create table student (student_reg number(4) primary key, address varchar2(30), date_of_birth date, mobile_no number(12), nationality character (20),

Format the plain SQL code to JAVA SQL code.

create table student

(student_reg number(4) primary key,

address varchar2(30),

date_of_birth date,

mobile_no number(12),

nationality character (20),

phone number (15),

student_name character (20));

create table course

(course_code number (5) primary key,

course_name character (30),

credit_hrs number (2),

description varchar2 (100));

create table semester

(semester_season character (12),

semester_year number (4));

alter table semester

add constraint sems_pk primary key (semester_season, semester_year);

create table doctor

(doctor_no number (3) primary key,

doctor_name character(30),

qualification varchar2 (100));

create table student_course

(student_reg number (4),

semester_season character (12),

semester_year number (4),

course_code number (5),

grade number (3));

create table semester_course

(semester_season character (12),

semester_year number (4),

doctor_no number (3),

course_code number (5));

alter table student_course

add constraint st_reg_fk foreign key (student_reg)

references student (student_reg);

alter table student_course

add constraint sem_season_fk foreign key (semester_season, semester_year)

references semester (semester_season, semester_year);

alter table student_course

add constraint course_fk foreign key (course_code)

references course (course_code);

alter table student_course

alter table semester_course

add constraint doc_fk foreign key (doctor_no)

references doctor (doctor_no);

alter table semester_course

add constraint crs_fk foreign key (course_code)

references course (course_code);

alter table semester_course

add constraint sea_fk foreign key (semester_season, semester_year)

references semester (semester_season, semester_year);

alter table semester_course

add constraint sem_crs_pk primary key

(course_code, semester_season, semester_year, doctor_no);

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!