hw3 - CSC 134 Spring 2009 Homework 3 Total: 300 points This...

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

View Full Document Right Arrow Icon
CSC 134 Spring 2009 Homework 3 Total: 300 points 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. Project_ID Contact_Details Conact_Type Zip Address Organization CP_Name Title Project_ID Last_Name First_Name SSN Last_Name First_Name SSN Project_Status Archived Phone PROJECT CONTACT HISTORY REVIEWER INVESTIGATOR Inv_Role SSN WORKS_ON Reviewer_Role SSN REVIEWS Contact_ID Project_ID Project_ID Language Project_ID LANGUAGE Contact_Remainders Project_ID Contact_ID CONTACT_ REMAINDER OSHPD Database 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
Figure 2 ER Diagram Section 2 Populate the database. Please check sections 3 for details.
Background image of page 2
Section 3 Use SQL to specify the following queries. When you populate the database, insert data such that at least one row will be display as the result of running each query. 1)
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 - CSC 134 Spring 2009 Homework 3 Total: 300 points This...

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