| Course Information | ||||
|---|---|---|---|---|
| Course Section | Lecture Hours | Location | ||
| CMP 420 - 01 & CMP 758 - OA01 | Online Asynchronous | Online Asynchronous | ||
| Contact Information | ||||
|---|---|---|---|---|
| Instructor: | Steven Fulakeza | Email: | steven.fulakeza(at)lehman.cuny.edu | |
| Phone: | NA | Office Location: | NA | |
| Office Hours: | By appointment Mondays through Thursdays 4pm to 6 pm using the following link: | |||
| Instructor Availability: | I respond to students' emails regularly, but please note that I do not typically check email or Slack messages during late hours on weekdays. Additionally, I do not monitor these platforms on weekends, as I reserve and dedicate this time to family, rest, and religious observances. Any messages received during these times will be addressed when I am back online. | |||
CMP 420 Course Description: 4 hours, 4 credits
Introduction to theory of database systems and database management: theory of relational, hierarchical, and network database organization, with emphasis on the first; views of data, data organization, data dependency and redundancy, normal forms, and query language.
Prerequisite:
Course Objectives:
Textbook:
References:
Grades Policy:
Your grades will be computed based on the following:
CMP 420:
| Activity | Percentages |
|---|---|
| Brightspace Quizzes | 10% |
| Homework Assignments | 25% |
| Midterm Exam | 30% |
| Final Exam | 35% |
Make-up and Alternate Exams Policy:
Make-up exams will not be provided unless a student's absence is due to an unavoidable circumstance. In such cases, the student must submit a formal written request along with appropriate documentation to substantiate the reason for their absence.
All exams are scheduled to be taken in person on campus. If you are unable to attend the in-person exam, please consider enrolling in the course during a subsequent semester when your schedule permits.
Exam Schedule:
Final Exam Policy:
The final exam is comprehensive. If your score on the final exam is higher than your midterm exam score, themidterm grade will be replaced by the final exam grade in the calculation of your final course grade. This substitution will be applied automatically during final grade calculations. However, this policy does not apply to any student found to have committed academic dishonesty on any assignment, exam, or other course-related work.
Projects
Several projects and assignments will be given during lectures and some will be posted on Brightspace and the course website. Students must work on their own projects and assignments unless stated otherwise. Students handing in similar work will both receive a 0 and face possible disciplinary actions. No late assignments or projects will be accepted. Projects must be submitted on Brightspace. No emailed work will be accepted.
Academic Integrity and Plagiarism Policy
Students are encouraged to study together. However, you must do your own work for all your homework assignments, projects and exams. You should never copy code or anywork from the internet or another student. You are responsible for knowing and following Lehman's academic integrity code (available from the Undergraduate Bulletin, Graduate Bulletin, or the Office of Academic Standards and Evaluations). All incidents of cheating will be reported to the Vice President of Student Affairs.
Statement may be found in the student handbook. For more information, refer to https://www.lehman.edu/student-affairs/documents/Student-Handbook-Lehman-College-8-31-2020.pdf
Note: All incidents of cheating will be reported to the Vice President of Student Affairs.
Attendance:
Students are expected to attend lectures regularly and promptly. In the event of illness, or injury, students should notify me. Students who miss a class are responsible for learning materials presented in class and reading relevant textbook portions. If you need help, please do not hesitate to contact me.
Students receiving financial aid must be certified as attending classes regularly for continuing eligibility.
Accommodating Disabilities:
Lehman College is committed to providing access to all programs and curricula to all students. Students with disabilities who may need classroom accommodations are encouraged to register with the Office of Student Disability Services. For more info, please contact the Office of Student Disability Services, Shuster Hall, Room 238, phone number, 718-960-8441.
Technology, Brightspace and Email:
We will be using Brightspace and Github sites for much of the class activities. Brightspace can be accessed through the Lehman website at www.lehman.cuny.edu. You will also need to have access to your Brightspace account. You can contact the IT Center if you have any problems accessing your account.
I will be communication with you regularly throughout the semester using your email address that is available on Brightspace. Make sure you have access to your email. If you have, any questions about your Lehman email address or your password, or if you have any problems accessing the site please call the computer helpdesk at 718-960-1111.
Course Outline:
Part 1 - Introduction to Databases
Part 2 - Conceptual Data Modeling and Database Design
Part 3 - The Relational Data Model and SQL
Part 6 - Database Design Theory and Normalization
Part 7 - File Structures, Hashing, Indexing, and Physical Database Design
Part 9 - Transaction Processing, Concurrency Control, and Recovery
Tentative Schedule:
| Week | Day | Date | Topic | Reading Materials |
|---|---|---|---|---|
| 1 | 1 | 07/14/2025 | Introduction, Syllabus, Chapter 1 | Syllabus & Chapter 1 |
| 1 | 2 | 07/16/2025 | Chapter 1 | Chapter 1 |
| 2 | 3 | 07/21/2025 | Labor Day College closed – NO CLASSES | |
| 2 | 4 | 07/23/2025 | Chapter 2 - Database System Concepts and Architecture | Chapter 2.1 - 2.3 |
| 3 | 5 | 07/28/2025 | Chapter 2 - Database System Concepts and Architecture (Continued) | Chapter 2.4 - 2.6 |
| 3 | 6 | 07/30/2025 | Chapter 3 - Data Modeling Using the Entity – Relationship (ER) Model | Chapter 3.1 - 3.3 |
| 4 | 7 | 08/04/2025 | Chapter 3 - Data Modeling Using the Entity – Relationship (ER) Model | Chapter 3.3 - 3.7 |
| 4 | 8 | 08/06/2025 | Chapter 3 - Data Modeling Using the Entity – Relationship (ER) Model | Chapter 3.7 - 3.10 |
Projects, Assignments and Backboard Quizzes:
| Projects, Assignments and Backboard Quizzes | Release Date | Due Date |
|---|
Software Used For the Course:
Classroom Policies