hw5 - CIS 4301 (Information & Database Systems I),...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: CIS 4301 (Information & Database Systems I), Homework 5 - Programming Assignment Due date: 04 / 06 / 2010 Submit a soft copy through course tools by midnight March 25, 2010 This homework covers basic SQL querying capabilities. We have created a set of files for this homework. You will need some of them and some of them are just to help you get started. You can reach these files at http://www.cise.ufl.edu/ ~ tamer/teaching/ spring2010/other/hw5.tar . Make sure that you read the file readme.doc carefully. Assume that we have a relational database with the following relations. Course(courseid, coursename) Instructor(ufid, name, email) Student(ufid, name, email) Teaches(ufid, courseid, semester) Enroll(ufid, courseid, semester) Grades(ufid, courseid, semester, grade) The details of the attributes of these relations are given in the file schemas.SQL. You can use this file to create your tables....
View Full Document

This note was uploaded on 01/22/2012 for the course CIS 4301 taught by Professor Schneider during the Fall '08 term at University of Florida.

Page1 / 3

hw5 - CIS 4301 (Information & Database Systems I),...

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