home » classes » 312

CPTR–312 Database Management Systems

Fall 2008
Raheel Ahmad
Science Rm. 142, MWThF, 9:00 – 9:50 pm

Course description and objectives

With the advent of the age of computing, we have seen a rapid increase of digital data. For managing a large collection of (related) data, databases are being used by all types of organizations, from large businesses, and government departments to individuals who want to manage their growing collection of personal data.

This course will introduce you to databases and database management systems (DBMSs). We will study the basic concepts of relational databases, the process of database design, the query language SQL, databases in a client/server environment, object–oriented databases. The course will also cover interacting with databases with a programming language such as Java.

Resources

• PHP code:
  • Displaying a date
  • Displaying the client (browser's) address
  • Conditional statements
  • Reading form values
  • Connecting to a database
  • Inserting values in a table
  • Displaying a database table
  • Displaying a database table wih some table formatting

Assignments

(Send all assignments to rahmad@manchester.edu. Make sure that subject line starts with CPTR312.)

• Assignment 5. Due Dec. 5, Friday.
• Assignment 4. Due Nov. 3, Monday.
• Assignment 3. Due Sept. 30, Tuesday.
• Assignment 2. Due Sept. 19, Friday.
• Assignment 1. Due Sept. 8. List four popular DBMS (besides Microsoft Access!) and also name at least one unique/differentiating feature of each.

Slides

• Lecture 1, Sept. 3. Introduction and Objectives
• Lecture 2, Sept. 4. View, Data Models, and Data Languages for Manipulation and Definition
• Lecture 3, Sept. 5. Intro to the Relational data model, and SQL
• Lecture 4, Sept. 8. Other Data Models, Database design
• Lecture 5, Sept. 10. Last bit of Introduction and Relational Model basics
• Lecture 6, Sept. 12. Union, difference and Cartesian product operations
• Lecture 7, Sept. 15. Cartesian product and Rename operations
• Lecture 8, Sept. 17. Natural Join
• Lecture 9, Sept. 18. Division, and some examples
• Lecture 10, Sept. 19. Assignment, Aggregate Functions, Outer Join
• Lecture 12, Sept. 22. Beginning SQL
• Lecture 13, Sept. 25. The selct clause
• Lecture 14, Sept. 26. Modifying content and the full select statement.
• Lecture 15, Sept. 29. Using MySQL server.
• Oct. 1. Starting with MySQL queries.
• Oct. 3. Set comparisons.
• Oct. 6. Set comparisons and Views.
• Modification operations: Insert, Delete, Update.
• Transactions, Join operators.
• The Date type, using LIMIT.
• Introduction to Database Design.
• Database Design %E2%80%93 Going deeper.
• Some issues in transforming ER-model to relational schemas.
• Normalization: First three normal forms.
• Normalization: Fourth normal form.
• Introduction to XML.
• More about XML.
• Database Storage and File Management.
• Database Indexes.
• Parallel and Distributed Databases.

Course syllabus