Question

3.1 (12) Transform the following ER diagram into a relational schema diagram. Semester Year Cno Title SecNo Term --- ssn Name Course E belongs 0cl Section so Teaches Teacher

Answer 1

Below are the tables .

1.Table Name :Teacher
create table Teacher(
ssn int primary key,
Name varchar(20));

2.Table Name :Course
create table Course(
cno int primary key,
Title varchar(20));

3.Table Name :Section
create table Section(
SecNo int ,
Semester varchar(20),
Year int,
ssn int ,
cno int,
primary key (SecNo,ssn,cno),
foreign key (ssn) references teacher(ssn),
foreign key (cno) references course(cno));