Database Management Systems - Prof. Holowczak

Zicklin School of Business - Baruch College
City University of New York

Database Management Systems
Fall 2009

Class Assignments and Exercises

Visit this page to learn about homework assignments and their due dates. Please be aware of the policy stated in the syllabus about turning in late assignments. There are also a few exercises you might also want to try.

When turning in an assignment, you must include the following information on a separate cover page:
Your Name, Course Number (3400), Section (TV24A), the name and number of the assignment and the date.

You may submit your assignments via e-mail to richard.holowczak@baruch.cuny.edu. However, please remember to include all of the above information (your name, etc.) in the body of the message as well as in any attachments. I strongly recommend you send me a test message with an attachment to make sure I can decode it and read it properly.

Date Issued Due Date Assignment
Tuesday 9/1/09 Friday 9/5/09 Access the Course Home Page at http://cisnet.baruch.cuny.edu/holowczak/classes/3400
The first assignment is to access the course home page. Take the time to view the on-line syllabus, locate the page for the course notes and read my statement on Conduct and Academic Honesty.

Then send the Professor e-mail at:
richard_holowczak@baruch.cuny.edu
with the Subject Line: CIS 3400 First Assignment
Supply the following information in your e-mail:
Full name, e-mail address (both your Baruch e-mail address and at least one other), program and major (undergrad business, MBA, MS/CIS), semesters completed, when you expect to graduate, list of CIS courses completed, list of CIS courses being taken this semester, and your reasons for taking this course.

Please let me know if you have a class right before this class or directly after it.

Please let me know where you intend to carry out homework and project work that involves MS Access (e.g., work, school, home). Also let me know what version of MS Access you have or will use.

Finally, include in your note an acknowledgement that you have read and understood my statement on Conduct and Academic Honesty.

Note that all students must actively maintain an e-mail account while enrolled in any of my advanced courses.

Thursday 9/10/2009 Tuesday 9/22/2009 2. E-R Modeling Assignment
Create an ER model for the restaurant case study and convert to relations
Follow this link for the complete instructions
Tuesday 10/06/2009 Thursday 10/22/2009 3. Structured Query Language Assignment
Write SQL Queries based on the given schema .
Follow this link for the complete instructions

Exercises

The following exercises are for your own amusement.

[Home]
File: assign.html Date: 1:39 PM 10/6/2009
All materials Copyright, 1997-2009 Richard Holowczak