CS4347.001 Database Systems
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.
* Some contents are borrowed from Prof. Jalal Omer at UTD.