CIS331 S04

Principles of Database Systems

Course Information - Topics

• Database System Architecture: ANSI/SPARC Architecture; data abstraction; external, conceptual, and internal schemata; data independence; data definition and data manipulation languages.
• Data models: Entity-relationship and relational data models; data structures, integrity constraints, and operations for each data model; relational query languages: SQL, algebra, calculus. Query by Example.
• Theory of database design: Functional dependencies; normal forms; dependency preservation.
• Query Processing and Optimization: Equivalence of expressions, algebraic manipulation.
• Storage Strategies: Indices, B-trees, hashing, advanced access methods.
• Transaction Processing: Recovery and concurrency control.
• Object-oriented and object-relational data model.
• Distributed Databases.
• Introduction to Data mining.

Instructor

• Vasilis Megalooikonomou, email: vasilis@cis.temple.edu
• Office: 314 Wachman Hall, phone: 215-204-5774
• Office Hours: Tu 1-2:30pm, Th 1-2:30pm, and by appointment

TA

• Vladimir Vacic (Vlada), email: vladimir@vacic.org
• Office: 321 Wachman Hall, phone: 215-204-7230
• Office Hours: M 2-3pm (Wachman 321), F 2:30-4:30pm (Wachman 215) and by appointment

Class

• Meets: Tu Th 11:40-1:00pm, room: Tuttleman Learning Center 305A

Lab

• Meets: M 8:40-10:30am, room: CC200

Prerequisites

• CIS207 (Introduction to Systems Programming and Operating Systems) and CIS223 (Data Structures and Algorithms). If you have not taken these courses, please see me asap.

E-mail

• The mailing list CIS331-S04 will been created for the class and it will be used to send messages about the homework, presentations, projects, and other topics. I expect that you read your email regularly. Otherwise you may miss important information. Please send an email to vasilis@cis.temple.edu with your preferred email address so that I put you on this mailing list.

Web Page

• The web page for the course is http://knight.cis.temple.edu/~vasilis/Courses/CIS331. This page will contain handouts, and other information related to CIS 331.

Text

• Required:
  A. Silberschatz, H.F. Korth, and S. Sudarshan, Database System Concepts, 4th edition, McGraw Hill Inc.
  
• Optional:
  C. J. Date, An Introduction to Database Systems, 8th edition, Addison Wesley
  Raghu Ramakrishnan, Database Management Systems, McGraw Hill
  Jeffrey Ullman, Principles of database and knowledge-base systems
  Patrick O'Neil, Database Principles Programming Performance, Morgan Kaufmann
  Raymond Lorie and Jean-Jacques Daudenarde, SQL and Its Applications
  Michael Stonebraker, Readings in database systems, Morgan Kaufmann.
  

Project

• The course load involves a project in Oracle. Through this project you will get hands-on experience, designing and implementing an application on a database system. For extra credit there will be a second project. The goal of the second project is to give students the opportunity to tackle a large, interesting problem, which may lead to a publication.

Exams, Project and Grading

• Homeworks: 20%
• Project: 30%
• Midterm: 20%
• Final: 30%

  Late Policy: The project parts and homework assignments are due in class, on the specified due date. No late submissions will be accepted. For fairness, this policy will be strictly enforced.

  Exams: All aids are allowed (open books, open notes, calculators, etc).

Honor Code

• All work submitted for credit must be your own.
• You may discuss the homework problems with your classmates, the teaching assistant, and the instructor. You must acknowledge the people with whom you discussed your work, and you must write up your own solutions and code. Any written sources (apart from the text) used must also be acknowledged; however, you may not consult any solutions from previous years' assignments whether they are student or faculty generated. Any software given to you (by us or by other sources) must also be acknowledged.
• Please ask if you have any questions about the Honor Code. Violations of the honor code will be treated seriously. Please check the Temple University policy on Plagiarism and Academic Cheating.

Disabilities

Switch to:

• CIS331 S04 Home Page