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:
CMP 338 (Data Structures and Algorithms).
Course Objectives:
Textbook:
References:
Grades Policy:
Makeup exam might be given only when a student's absence is unavoidable. In such a case, the student must file formal written request.
The final exam is comprehensive. If you do better on the final exam than exam 1, the final grade will replace the low score from the midterm.
We will also drop one of the lowest scoring homework assignments. While exams will have extra credit points, there will be no extra credit assignments or projects.
Homework Assignments
Several homework assignments will be given during lectures and some work will be posted on Blackboard. Students need to work on the homework to prepare for exams but may not need to submit the homework assignments to the instructor. Some selected homework problems will be assigned as formal assignments to be submitted for grading. Students must work on their own assignments unless stated otherwise. No late assignments will be accepted.
Exam Schedule:
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 student handbook. For more information, refer to http://www.lehman.cuny.edu/student-affairs/documents/student-handbook-02.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, Blackboard and Email:
We will be using a Blackboard site for much of the class activities. It can be accessed through the Lehman website at www.lehman.cuny.edu. You will also need to have access to your Blackboard 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 Blackboard. 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 (Tentative):
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
Homework Assigments:
Sample Exams:
Software Used For the Course:
Classroom Policies