ISE 324 - Database Systems
Semester 1 5772

Topics     Reading     Assignments  Grading     Lectures     Policies

Time: Monday 12:00 - 14:00 in Computer Room 715 in the Library
Targil: Thursday 11:00 - 13:00 in Computer Room 209

Instructor:

    Michael J. May
      e-mail: mjmay (AT) kinneret,ac,il
      office hours: Wednesday 12:30-13:30 (and by appointment) 

Metargel:

      Elisar Mamen
      e-mail: elisar25@
      office hours: TBA

The full detailed syllabus for the course is available here.

Reminder: Project presentations on 26 Jan 2012.

Topics:

  • Fundamentals of Database Systems
  • Entity-Relationship Models
  • Relational Algebra
  • SQL
  • Constraints
  • Stored Procedures
  • Advanced Topics: Introduction to Transactions, Transaction Management, Normalization

Reading

The following book contains useful course material, and much of the lecture content is derived from them (and other sources). Copies of these books are on reserve in the Kinneret Library.

  • Database Management Systems (3rd edition) by Ramakrishnanand and Gehrke
In addition, the following books, papers, and web sites provide supplementary material. Reading selections from these sources will be announced in class.
  • Database System Concepts (5th edition) by Silberschatz, Korth, and Sudarshan
  • First Course in Database Systems (2nd edition) by Ullman and Widom
  • An Introduction to Database Systems (6th edition) by Date
  • Fundamentals of Database Systems (3rd edition) by Elmasri and Navathe

Assignments (Self-Checked)

Assignment 1: Entity Relationship Diagrams.  Due: 21 November 2011
                        Answers on Telem.

Assignment 2: ERD Translation. Due: 19 December 2011

Assignment 3: Relational Algebra and SQL. Due: 5 January 2012
                      Suppliers/Parts/Catalog insert file. Student/Class/Enrolled/Faculty insert file.

Assignment 4: Triggers, Stored Procedures, Normalization. Due: 29 January 2012
                      Employees/Departments/Works insert file.

Semester Project:


New: Submission instructions: You may submit work using Telem, in person, or by sending email to the address ise324 at gmail.  If you send email to the ise324 address, you will receive an auto-answer response acknowledging that a message has been received.

Grading Criteria

  • 20%   Project
  • 80%   Final Exam

Lecture Slides and Notes

Schedule
#
 Date
 Topic
 Notes
1
 31 Oct Database uses, Introduction to the Relational Model
 [pdf][mssql, targil, data]
2
 7 Nov
 Into to the Relational Model 2, Entity Relationship Models 1
 [pdf][targil, data]
3
 14 Nov Entity Relationship Models 2
 [pdf][targil]
4
 21 Nov
 Relational Model 1
 [pdf][targil]
5
 28 Nov
 Relational Model 2
 [pdf][targil]
6
 5 Dec
 Translating from Entity Relationship Models
 [pdf][targil]
7
 12 Dec
 ERD Translation 2, SQL Queries- Basics
 [pdf][targil, data]
8
 19 Dec
 Relational Algebra
 [pdf][targil]
9
 26 Dec
 Division, Nested SQL Queries
 [pdf][targil, sailors, classes]
10
 2 Jan
 Aggregate SQL Queries
 [pdf][targil, sailors, classes]
11
 9 Jan
 Nulls, Constraints, Triggers
 [pdf][targil, class-update]
12
 16 Jan
 Triggers, Stored Procedures [pdf][targil]
13
 23 Jan
 Normalization
 [pdf]

TBA Jan
 Final Exam A from 00:00am - 00:00pm in Room TBA

TBA Feb
 Final Exam B from 00:00am - 00:00pm in Room TBA

Since Kinneret College does not have a unified code of academic integrity, this course will abide by the University of Pennsylvania's Code of Academic Integrity. In particular, for individual projects and group projects, the following guidelines should be followed:
  • For individual projects, you must type in and edit your own code, documentation, and any other materials submitted for grading.
    • Copying someone else's file is not allowed.
    • Allowing someone else to copy a file of yours, either explicitly or implicitly by leaving your code unprotected, is not allowed.
    • Editing each other's files is not allowed
  • Regarding the ethics of what you may or may not discuss with others:
    • "High level" discussions are fine.
      For example, discussions about the problem statement.
    • "Low level" discussions are fine.
      For example, discussions about C syntax or using gdb, understanding compiler error messages, understanding the mechanics of the tools and libraries used for the projects.
    • "Mid level" discussions require discretion. In this CIS course, discussions at this level must be limited.  Unless explicitly stated otherwise, you may not collaborate significantly with classmates (except group project members) at this level.  If you have minor discussions with others at this level or get help from outside resources (tutors, web sites, etc), you must cite at the top of the submitted projects the names of the people or websites who helped you and how they did. For example: 
            /**
             * Chris Brown
             * Project 1
             * 5/6/2008
             * I received tips from Jo Johnson on the i/o and example.com/mem.htm on memory
             */
  • If there is any doubt about the use of external sources or collabortation, please ask for clarification by the course staff.