Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database 11g SQL

Authors: Jason Price

1st Edition

0071498508, 978-0071498500

More Books

Students also viewed these Databases questions

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago