assignment4 - make sure your data preserves foreign key...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
IS 620 Assignment 4 Due 2/24 Suppose you have created tables in assignment 1 (listed in textbook page 116 Figure 3.12, also listed below). Tables: Employee(employee_name, street, city) Works(employee_name, company_name, salary) Company(company_name, city) Manages(employee_name, manager_name) Problem 1. Write ONE anonymous PL/SQL program to do all the following: [50 points] Declare a rowtype variable for employee, a row type variable for works (specify where the employee works), and a row type variable for manages (specify who manages the employee) Assign some values to these 3 variables (use assignment statement). You want to
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: make sure your data preserves foreign key constraints. For example, the manager_name of the new employee shall already appear in the employee table, and the company_name shall already appear in the company table. • Insert these rows into employee, works, and manages table. Problem 2. Write an anonymous PL/SQL program to compute the sum of 2, 4, 6, 8, 10. You must use a loop. Tip: consider how to update your loop variable. [50 points] Please submit print-out of code....
View Full Document

This note was uploaded on 02/28/2012 for the course IS 620 taught by Professor Chen,z during the Spring '08 term at UMBC.

Ask a homework question - tutors are online