CRN#
CSC 261 - 49283 (uGrad CS) CSC 461 - 49878 (Grad CS) TCS 461 - 55992 (TEAM CS)Prerequisites
CSC 172, CSC 173 recommendedTeaching staff
Instructor: Tamal Tanu Biswas Office: CSB 728 Office Hours: TuTh 2pm - 3pm, or by appointment Email: tbiswas2 [at] cs.rochester.edu TA: Md Kamrul Hasan Office: CSB 727 Office Hours: TuTh 4:30pm - 5:30pm, or by appointment Email: mhasan8 [at] cs.rochester.edu TA: Vojtech Aschenbrenner Office: CSB 727 Office Hours: MW 10:30am - 11:30am, or by appointment Email: vaschenb [at] cs.rochester.eduCourse description
This course presents the fundamental concepts of database design and use. It provides a study of data models, data description languages, and query facilities including relational algebra and SQL, data normalization, transactions and their properties, physical data organization and indexing, security issues and object databases. It also looks at the new trends in databases, for example, Big Data, MapReduce, and NoSQL. The knowledge of the above topics will be applied in the design and implementation of a database application using a target database management system as part of a semester-long group project.Topics covered
The course covers foundational material in the field of database systems. In this course, we will cover:- Basic introductory concepts necessary for a good understanding of database models.
- Database Management System (DBMS) concepts, terminology, and architecture.
- Entity relationship modeling and database design.
- Relational database and SQL for efficiently storing, retrieving, and updating data in a database.
- File organization on disk, indexing and hashing
- Concurrency and database recovery,
- Distributed databases, NoSQL storage systems, Big data, Hadoop and MapReduce
- Database Security
Course schedule
Faculty | Location | Days | Time |
---|---|---|---|
Tamal Biswas | DEWEY 1101 | MW | 3:25PM - 4:40PM |
Required textbook

Fundamentals of Database Systems, 7th Edition (ISBN: 0133970779) by Ramez Elmasri & Shamkant B. Navathe (© Pearson Education, 2016).
Workload
- In-class Quizzes
- Assignments and Projects
- 1 Mid Term
- 1 Final
Grading policy
- Quiz (20% of the course grade)
- There will be 10+ (about 13) quizzes. Best 10 quizzes are considered for grading.
- Each quiz carries 2% of the course grade
- All the quizzes will be held during the lectures on Mondays.
- No quiz on Mar 06, Mar 13, and May 01.
- Exams (30% of the course grade)
- 1 midterm (15%)
- 1 final exam (15%)
Midterm on Mar 08, 2017
Final on May 08, 2017 (9:00 am) - Labs/Assignments/Projects (45% of the course grade)
- Class Participation
- 5 points will be awarded based on in-class participation and posts on Piazza.
- Term Paper (Only for CSC/TCS 461)
- Students need to review one or more conference/journal papers, implement or add features to it.
- Students need to submit a report based on their results or findings.
- 20 additional points (making the total grade 120. The score will scaled to 100 for final letter grade)