CSCI 432/CSCI 632: Database Systems / Advanced Database Systems
| Name: | Database Systems / Advanced Database Systems |
| Credit Hours: | 3 |
| Meeting Time: | Tuesday & Thursday 2:10pm - 3:30pm |
| Class Room: | Mackey Building, Innovation Space |
| Instructor: | Dr. Chunmei Liu |
| Office: | LKD 2038A |
| Email: | chuliu AT howard.edu |
| Office Hours: | 11:30 am - 2:00 pm T, Th |
| Textbook: | "Database Systems: Design, Implementation, and Management ", 12th Edition , by Carlos Coronel, Steven Morris, and Peter Rob, Cengage. ISBN-13: 9781305627482 |
Course Content:
This course will present the basic concepts of database systems. Topics that will be covered include basic relational database theory, relational database modeling, relational database design and implementation, normalization, transaction management, the SQL language and other languages and facilities provided by database management systems.
Course Objectives:
The objective of this course is to introduce students to proven processes and techniques that are fundamental to database system managements.
Prerequisitesby topic:
Required Course Materials:
Student Learning Objectives:
- Understand terms related to database design and management and the database development process;
- UnUnderstand the relational data model and relational database management system;
- Be able to construct conceptual, digital and physical data models and evaluate the normality of a logical data model, and correct any anomalies;
- Be able to implement relational databases using a RDBMS;
- Be able to use structured query language (SQL) to create objects, populate tables, and retrieve data.
- Understand database performance issues;
- Understand the basics of data management and administration;
- Be able to communicate technical content orally or in writing to different audiences.
Exams:
The midterm exam will cover all the materials up to the midterm. The final exam will cover all materials taught in the class.
Grading Policy:
Your final course grade will be calculated as follows:
Assignments: 15%
Project and participation: 15%
Midterm exam: 30%
Final Exam: 40%
A: 90-100, B: 80-89, C: 70-79, D: 60-69, F: 0-59
Note: NO scale-up adjustment will be made if the grade is out of range.
Attendance policy:
All students are expected to attend classes regularly and promptly. Students are expected to participate in class discussions and group projects if any. Students should not leave the class while it is in progress unless it is extremely urgent or an emergency. Students that are absent for health reasons are expected to present documentation as soon as possible. If you are absent from classes or laboratory periods, you are still responsible for the work missed. If you miss a scheduled midterm or final exam, you must obtain your instructor's approval to take a substitute exam or you will receive a grade of zero for the exam.Plagiarism Policy
Howard University has adopted a new policy on plagiarism and cheating. In short, all instances of plagiarism will be resolved by an office of the administration, which will conduct the appropriate hearings. See the section entitled "ACADEMIC CODE OF STUDENT CONDUCT" on pages 26-27 of the "Student Reference Manual and Directory of Classes."
Resources:
Canvas: canvas.howard.edu
Tentative Schedule (please note that this schedule may be a little different from the actual schedule on Canvas):
The below slides are from the authors with some modifications from the instructor. Resources may be found at http://www.cengage.com
NOTE: The instructor reserves the right to change the course content, omit parts of the topics listed above or introduce new material midstream to supplement the course text. A is for assignments and P is for projects.
HU Class attendance policy:
Class Attendance Restricted to Registered Students: Only students whose names appear on the official course roster are permitted to attend class meetings. Students who are not registered are not permitted to attend or participate in course activities, do not have access to Blackboard, cannot submit course assignments, and will not receive a grade for this course. It is the students' responsibility to ensure that they are properly registered by the published registration deadline. Requests to add courses after the deadline will not be considered.