assignment 1 - Conducted_In (RoomNo, Building, CourseNo,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Ameya Deo Sac State: 211276521 CSC 134 Fall 2008 Homework #1 Map the given ER to the relational model. COURSE CLASSROOM Conducted in RoomID Capacity RoomNo Enrolls STUDENT ExamNo SectionNo CourseNo SSN First Name Last Name N M 1 M N 1 M N Takes N M EXAM Has Exam SECTION Has Section Result Department Course Name Address City Zip Street State Building name
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Ans: CLASSROOM (RoomNo, Building , Capacity)
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Conducted_In (RoomNo, Building, CourseNo, SectionNo, ExamNo ) COURSE (CourseNo , CourseName, Department) SECTION (CourseNo, SectionNo) EXAM (CourseNo, SectionNo, ExamNo ) Takes (SSN, CourseNo, SectionNo, ExamNo , Result) STUDENT (SSN , FirstName, LastName, Street, City, Zip, State) Enrolls (SSN, CourseNo, SectionNo)...
View Full Document

Page1 / 2

assignment 1 - Conducted_In (RoomNo, Building, CourseNo,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online