assignment1

assignment1 - Company(company_name, city)...

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

View Full Document Right Arrow Icon
IS 620 Assignment 1 Due 2/3 Problem 1. Consider the employee database with the following list of tables. Please create these tables with appropriate primary keys & foreign keys. You can assume both employee_name and company_name are unique. [50 points] The list of tables is: Employee(employee_name, street, city) Works(employee_name, company_name, salary)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Company(company_name, city) Manages(employee_name, manager_name) Problem 2. Insert at least two rows of data to each table. Make sure you keep the primary key and foreign key constraints. [50 points] Please submit print-out of SQL statements. You do not need to show screen shot....
View Full Document

Ask a homework question - tutors are online