Role | Name | Office Hours | Location | |
---|---|---|---|---|
Instructor | Viswanath Gunturi | gunturi at iitrpr dot ac dot in | Room num: 204 | |
Teaching Assistant | Mansi Sahi | |||
Teaching Assistant | Anurag Agarwal |
The objective of this course is to introduce some of the fundamental ideas at conceptual, logical and physical levels of databases. At the end of the course, the student would be able to write SQL queries, design database schemas which are free from data-redundancy and have lossless joins, design and implement database applications, understand and interpret key databases related concepts such as index structures, query processing algorithms and ACID properties of database transactions.
Topics: Fundamental topics relating to Database Systems including relational model, SQL queries, ER models and Normalization, file structures, access methods, query processing algorithms, transactions and some trend topics (e.g., Data Warehousing, Deductive databases, etc.). Please visit the schedule page for lecture slides and other relavant reading material provided by the instructor.
Required Work: This course would have 2 exams, 1-2 in-class quiz, lab assignements (and or lab tests) and a database application project. Lab assignments (and lab tests) would include questions requiring SQL and a high-level language (C/C++/Java). Lab assignments need to be done individually. Database application project can be done in teams of size 2 or 3. Projects of teams of size 3 should be significantly more complicated than that of teams of size 2, but they would have same weightage and same deadline. Following is the distribution of weightage for each of the course deliverables:
Policies
Makeup Exam or Quiz Policy: Makeup exams will not be offered except in case of critical travel (e.g., paper presentation at a conference) that cannot be reschedules or medical emergency as documented by a doctor and approved by the academic office of IIT Ropar. Make-up exams will cover significantly more syllabus than the original missed exam. For example, if you miss an exam or a quiz which covered 5 topis, then the make-up exam is likely to cover 10 topics.
Late submission policy: All course deliverables must be submitted within the specified deadline. However, we understand that it may not always be possible on part of students to do so. In order to accomodate this, we would allow at grace period of 24 hours where the students are allowed to submit with a score reduction of 30%. Within 24 hours and 48 hours, there would be a score reduction of 50% beyond which the submission would not receive any score for that deliverable.
Policies from TAs:
Note: All of the academic dishonesty polcies of IIT Ropar apply. Visit this link for more information. If you are caught in a case of academic dishonesty in a course deliverable with a weight x% then you would be awarded -x% in that deliverable. This means that in addition to obtaining 0 in that deliverable, "x" would also be deducted from the course total.
Auxillary Information
Sample Database Management Systems:
PostgreSQL,
Oracle Database 11g,
MySQL,
IBM DB2
Resources for literature on Database Research: Proceedings of the Intl Conference on Data Engineering (ICDE), Proceedings of the ACM SIGMOD , Proceedings of Very Large Database Systems (VLDB), Proceedings of the Intl. Symposium on Spatial and Temporal Databases , IEEE Transactions on Knowledge and Data Eng. , and ACM Transactions on Database Systems.