1 / 13

Comprehensive Overview of Database Management Systems - Course Syllabus and Requirements

This document details the syllabus for the Database Management Systems course (331 IT, Semester II, 1431/1432, Winter 2011), including instructor information, office hours, course requirements, important dates, and learning outcomes. Students will explore fundamental concepts like transaction processing, recovery management, and query processing while applying DB administrator skills. The course uses "Database Systems: A Practical Approach to Design, Implementation and Management" by Connolly and Begg as the main textbook, along with additional reference materials.

vanig
Download Presentation

Comprehensive Overview of Database Management Systems - Course Syllabus and Requirements

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Management Systems331 IT Semester II 1431/1432 Winter 2011

  2. Your Instructors Lab I. Rana Al-Murshed Office Location: Room 93 – 2nd Floor - Building 20 Office Hours: to be announced on course site, or by appointment. e-mail: almurshed.r@ccis.edu.sa Tutorial I. Abeer Al-Dayel Office Location: Room 813 – 3rd Floor - Building 9 Office Hours: XXXX e-mail: aabeer@ksu.edu.sa

  3. Textbook Database Systems A Practical Approach to Design, Implementation and Management. Thomas Connolly, Carolyn Begg 4th or 5th Edition

  4. Reference Books Fundamentals of Database Systems. Ramez Elmasri, Shamkant Navathe. 3rd Edition, 2000 Database systems, Design, Implementation, & Management Peter Rob, Carlos Coronel. 4th Edition. 2000

  5. Course Requirements 3 Quizzes (10%) Weekly Assignments (5%) DBA Lab (10%) Mini Project (5%) Final Lab Exam (5%) 2 Major Exams (25%) Final Exam (40%)

  6. Important Dates • Quiz1 Monday 21 March 2011 • Mid1 Monday 28 March 2011 • Quiz2 Monday 2 May 2011 • Mid2 Monday 9 May 2011 • Quiz3 Monday 23 May 2011

  7. Course Website http://331it.wordpress.com/

  8. Syllabus • Object-Oriented Databases and Object-Relational Databases. • Transaction Processing and Concurrency Control. • Recovery management. • Query Processing. • Distributed Databases. • Lab: DB Administrator skills.

  9. Our Work Most of the Semester Course Outcomes • You should learn how databases work internally by studying the different components of a database system: • Transaction Processing. • Recovery. • Query Processing. Select Name From Students Where Age>20 Nora Monira Hala ..

  10. Course Outcomes • You should be able to design a distributed database and decide on the best strategy for executing a query. • You should know about new database technologies such as Object-Oriented Databases and Object-Relational Databases. • You should be able to perform the basic tasks of a DB Administrator.

  11. Official Course Outcomes • Have knowledge of emerging database technologies such as Object-Oriented Databases and Object-Relational Databases. • Comprehend different techniques for concurrency control and recovery in both centralized and distributed database systems. • Apply different concurrency control and recovery techniques on the execution of databases. • Evaluate the different techniques used in concurrency control and find advantages and disadvantages of each. Also, propose improvements to them.

  12. Official Course Outcomes • Analyze and design a suitable fragmentation based on a given a set of demands and constraints. • Comprehend and apply query processing methodologies. • Be able to select from relational algebra transformation rules to achieve query optimization. • Learn and apply database administration techniques, taking Oracle as an example. Database Systems

  13. Teaching Philosophy • Absolutely NO memorizing: Cheat-sheets in exams. • No question is a stupid question: So if in doubt, just ask. • Don’t leave the lecture until you understand everything. Please. • Study from the book. Slides are just a guideline.

More Related