Course Description

This course emphasizes the concepts and structures necessary for the design and implementation of database management systems. Topics include data models, data normalization, data description languages, query facilities, file organization, index organization, file security, data integrity, and reliability. After successful completion of this course, the student should: 

•  Understand Data Modeling 

•  Understand the Relational Model and theory. 

•  Understand the normalization of relations. 

•  Gain a fundamental understanding of SQL programming. 

•  Understand and protect against SQL attacks. 

•  Understand data organization methods, indexing, and query processing. 

•  Understand database integrity and concurrency. 

Course Information

Instructor: Xinda Wang

Time: Spring 2024 Tuesday & Thursday 11:30pm–12:45pm

Location: ECSS 2.306

Office Hours: ECSS 4.705 Tuesday 1pm–3pm

Grading Policy

Grades will be computed as follows: 

•  25% Individual assignments (5 assignments)

•  20% Team project (delivered in milestones)

•  25% Midterm exam

•  25% Final Exam

•    5% Class participation

Academic Integrity

Students are required to follow UTD's student policies, as described in the student handbook.

Textbook and Materials

• Required textbook: Fundamentals of Database Systems (7th Edition), by RamezElmasri, Shamkant B. Navathe, ISBN-13: 9780133970777.

• Recommended textbook: Database System Concepts (7th Edition), by AviSilberschatz, Henry F. Korth, S. Sudarshan, McGraw-Hill Book Company 2020, ISBN 9780078022159.

• Something interesting: The Manga Guide to Databases, by Mana Takahashi, Shoko Azuma, Trend-Pro CO., LTD, No Starch Press 2019, ISBN 9781593271909. 

* If there are any inconsistencies, please refer to the required textbook.

Class Schedule (tentative) 

Note: the schedule will change as the course progresses. Please check frequently.