ISE 324 - Database Systems
Semester 1 5771

Topics     Reading     Assignments   Quizzes  Grading     Lectures     Policies

Time: Wednesday 14:00 - 16:00 in Computer Room 214
Targil: Wednesday 16:00 - 18:00 in Computer Room 214

Instructor:

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

The full detailed syllabus for the course is available here.

Reminder: Assignment 4 solutions on Telem.  Quiz 5 grades on Telem.

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.  Solutions on Telem.

Assignment 2: ERD Translation. Solutions on Telem.

Assignment 3: Relational Algebra and SQL. Solutions on Telem.
                      Suppliers/Parts/Catalog insert file. Student/Class/Enrolled/Faculty insert file.

Assignment 4: Triggers, Stored Procedures, Transactions. Solutions on Telem.
                      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.

Quizzes

There will be (a minimum of) four in class short quizzes at the beginning of lectures during the course of
the semester. The quizzes will take place from 2:00-2:10pm.  Students may skip or drop the grade of one of the quizzes without penalty. Students who miss a quiz due to Miluim duty will be allowed to (additionally) drop the missed quiz.

Tentative Quiz Schedule


#
 Date
 Topic
 Source (RG)
1
 27 Oct
 Entity Relationship Models
 2
2
 17 Nov
 Relational Model
 3
3
 24 Nov
 ERD Translation
 3.5
4
 15 Dec
 SQL Queries
 5
5
 5 Jan
 Triggers, Stored Procedures 5.8-5.9, 6.5

Grading Criteria

  •   4%   Quizzes
  • 16%   Project
  • 80%   Final Exam

Lecture Slides and Notes

Schedule
Date
 Topic
 Notes
13 Oct Database uses, Introduction to the Relational Model
 [pdf][mssql, targil, data]
20 Oct
 Into to the Realational Model 2, Entity Relationship Models 1
 [pdf] [targil, data]
27 Oct
 Entity Relationship Models 2
 [pdf][targil]
3 Nov
 Relational Model 1
 [pdf][targil]
10 Nov
 Relational Model 2
 [pdf][targil, emp, dept, works, emp-up]
17 Nov
 Translating from Entity Relationship Models
 [pdf][targil]
24 Nov
 ERD Translation 2, SQL Queries- Basics
 [pdf][targil, insert-script]
1 Dec
 Relational Algebra
 [pdf][targil]
8 Dec
 Division, Nested SQL Queries
 [pdf][targil, classes-insert]
15 Dec
 Aggregate SQL Queries
 [pdf][targil, classes-insert]
22 Dec
 Nulls, Constraints, Triggers
 [pdf][targil, classes-update]
29 Dec
 Triggers, Stored Procedures [pdf][targil]
5 Jan
 Transaction Management 1 [pdf][targil, worker-insert]
12 Jan
 Transaction Management 2 [pdf][targil]
30 Jan
 Final Exam A from 9:00am - 12:00pm in Room 203
16 Feb
 Final Exam B from 12:00pm - 3: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.