CS4430/5430 --- Database Management Systems

(Spring 2019, Sections 13031/13251)

Instructor: Li Yang
Lecture Time: MW 4:30-5:45pm
Classroom: CEAS D202
Office: CEAS B248
Office Hour: TR 1-2pm

TA: Rajani Pingili (rajani.pingili AT wmich.edu)
Office Hour: TR 2:30-3:30pm
Office: B125


Announcements:

Important announcements will come here.

Assignments:

There will be 5 assignments. Assignments will be posted on e-learning portal with due dates. They must be submitted to the e-learning portal exactly when they are due. No late submission will be accepted.


Catalog Data:

Name: CS4430 - Principles of Database Management Systems
Credit Hours: 3
Prerequisite: CS1120 - Computer Science II

Course Description:

This is our first course in DBMS. It gives an application-oriented introduction to DBMS. Topics we cover include basic concepts, data models (Entity-Relationship, relational), relational operations, SQL, database application development and database design theory. After this course, students are expected to be familiar with basic concepts in databases. Students are also expected to be able to design and use relational databases and to develop database applications. Students are required to complete a database project by the end of the semester.

Objectives:

The general objective of this first course in DBMS is to introduce students basic concepts, techniques and systems for data management so that students are able to design their own databases, write database queries, and develop database applications. Specific objectives include:

  1. Understand basic concepts in databases and DBMSs
  2. Understand the relational theory.
  3. Develop skills needed to design relational databases.
  4. Develop skills to write database queries.
  5. Get experience of database programming and application development.

Learning Outcomes:

Upon completion of this course, students will be able to:

  1. explain basic concepts in databases and benefits of databases to organizations,
  2. explain relational model and query relations using algebraic expressions,
  3. create database schema and query database using SQL,
  4. write database programs and develop Internet applications,
  5. design database schema using the Entity-Relationship model,
  6. transform database schema into normalized design,
  7. use XML to share data.

Textbook:

Evaluation:

There will be assignments, an implementation project, a midterm exam and a final exam. Your final grade is determined based on a weighted sum of your scores. Weights of the scores are:

Academic Integrity

The following code is required to be included in this syllabus:

You are responsible for making yourself aware of and understanding the policies and procedures in the Undergraduate (pp. 271-272) [Graduate (pp. 24-26)] Catalog that pertain to Academic Integrity. These policies include cheating, fabrication, falsification and forgery, multiple submission, plagiarism, complicity and computer misuse. If there is reason to believe you have been involved in academic dishonesty, you will be referred to the Office of Student Judicial Affairs. You will be given the opportunity to review the charge(s). If you believe you are not responsible, you will have the opportunity for a hearing. You should consult with me if you are uncertain about an issue of academic honesty prior to the submission of an assignment or test.