CRN#
CSC 261 - 49751 (uGrad CS) CSC 461 - 50286 (Grad CS) DSC 261 - 85864 (Grad CS) DSC 461 - 85870 (Grad CS) TCS 461 - 56088 (TEAM CS)Prerequisites
CSC 172; CSC 173 recommendedTeaching staff
Instructor: Tamal Tanu Biswas Office: Wegmans 2107 Office Hours: Tu 12pm - 1pm, W 11am - 12pm, or by appointment Email: tbiswas2 [at] cs.rochester.edu TA: Haosen Wen Office: 2201 Wegmans Hall Office Hour: Th 4pm - 6pm Email: hwen5 [at] cs.rochester.edu TA: Zhuojia Shen Office: Wegmans 3203 Office Hour: Friday 4pm - 6pm Email: zshen10 [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, MapReduce
- Basics of MongoDB and Spark.
- Database Security (if time permits)
Course schedule
Faculty | Location | Days | Time |
---|---|---|---|
Tamal Biswas | LATT 201 | MW | 3:25 PM - 4:40 PM |
Required textbook
Fundamentals of Database Systems, 7th Edition
(ISBN: 0133970779) by Ramez Elmasri & Shamkant B. Navathe (© Pearson Education, 2016).
Workload
- In-class Quizzes
- Projects
- 1 Mid Term
- 1 Final
Grading policy
- Quiz (20% of the course grade)
- There will be 10+ quizzes. Best 10 quizzes are considered for grading.
- Each quiz carries 2% of the course grade
- All the written quizzes will be held during the lectures on Wednesdays.
- Exams (35% of the course grade)
- 1 midterm (15%)
- 1 final exam (20%)
Midterm on March 07, 2018 (Wednesday)
Final on May 06, 2018 at 9:00 am (Sunday) - Projects (45% of the course grade)
- Class Participation
- Maximum of 3 points will be awarded based on in-class participation and posts on Piazza.
- Term Paper (Optional)
- Maximum of 2 students can form a team
- Students need to review one or more conference/journal papers and implement the project or add features to it.
- Students need to submit a report based on their results or findings.
- 8 additional points (making the total grade 108. The score will be scaled to 100 for the final letter grade)
- Note: Does not guarantee grade improvement.