Map the given EER into the relational model. Three are three options for mapping

Question

Map the given EER into the relational model. Three are three options for mapping a specialization. Please use the option of "Create a table for each class (both superclass and subclass)". Please include all the relations and views (if there is any). Your homework must be typed and submitted electronically through SaC Neither hard copy nor email submission will be accepted. You must submit a PDF file. Files in other format will not be accepted TA by Tide ENT Enrolled STRUCT by No_of _Students Email SSN Address COURSE COURSE URL Class tin e CLASS Capacity

Explanation / Answer

create table STUDENT(SSN int primary key,StudentName varchar(20),Address varchar(50),Email varchar(20))

create table COURSE(CourseNo int primary key,CourseName varchar(20),NoofStudent varchar(20),references STUDENT(SSN))

create table INSTRUCTOR(InsrtuctorID int primary key,name varchar(50),Title varchar(20))

create table CLASSROOM(RoomID varchar(20) primary key,Building varchar(20),capacity int,RoomNo int, references NonWebCourse(NWebId) )

create table WebBasedCourse(URL varchar(20) refernces COURSE(CourseNo))

create table NonWebCourse(NWebId int primary key,Class_time DataTime refernces COURSE(CourseNo))

create table TA(Salary int,references STUDENT(SSN))

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---