hw3 (1) - X CSC 134 Fall 2008 Homework 3 Total: 300 points...

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

View Full Document Right Arrow Icon
X CSC 134 Fall 2008 Homework 3 Total: 300 points Due: Nov. 18, 2008, at 11:00 pm This homework allows students to practice the development of a database using Oracle. Section 1 Using SQL, create tables according to the given schema shown in Figure 1. The ER diagram is shown in Figure 2. CourseNo Course_Name CourseNo SSN First_Name Last_Name Capacity Building RoomNo COURSE STUDENT EXAM CLASS ROOM Street CourseNo SECTION Deparment SectionNo ExamNo SectionNo CourseNo ExamNo SectionNo SSN Result TAKES CourseNo ExamNo SectionNo Building CONDUCTED_IN SSN ENROLLS CourseNo SectionNo City Zip RoomNo Figure 1 Schema
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 UNIVERSITY DATABASE Building name Figure 2 ER Diagram
Background image of page 2
Section 2 Populate the database. Please check sections 3 for details. Section 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

hw3 (1) - X CSC 134 Fall 2008 Homework 3 Total: 300 points...

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

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