Advanced Database Systems

Student Learning Outcomes, Goals, Objectives:

The goal of this course is to help students understand the fundamentals of the design, data models, and analysis of modern databases through assignments/projects. Particularly, the topics covered in this course include modern database models, database languages and design, user interface and operations, applications design, and other selected topics of current interest such as big data, data analytics, XML, and complex data types. 

Students successfully completing this course will be able to:

• Design a database satisfying a set of requirements using Entity-Relationship model,

• Understand relational data model, relational algebra, and SQL language,

• Understand theories of relational database design including functional dependencies and normalization,

• Understand XML technologies,

• Understand complex data types,

• Understand big data,

• Explore data warehousing and data mining technologies.

By developing a real-world web application step by step, the students can enhance their understanding of the fundamental concepts and theories of databases.

Course Grading Information:

Activity/Performance Measure	Percentage/Points
Assignments	30%
Project	30%
Tests	40%

Grading Scale

Percentage	Letter Grade
94-100	A
90-93	A-
87-89	B+
84-86	B
80-83	B-
77-79	C+
74-76	C
70-73	C-
67-69	D+
64-66	D
60-63	D-
<59	F

Attendance/Participation:

Attendance/participation is not a graded component included in the student's final grade for this course.

Course Materials Purchased by the Students:

A. Silberschatz, H. F. Korth, and S. Sudarshan, Database System Concepts, Seventh Edition, McGraw-Hill, 2020. ISBN: 978-0-07-802215-9.