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
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