Embedded Files
Course information:
Course information:
Semester year: Spring 2025
Time/Location: Tuesday/Thursday 5:00 pm - 6:30 pm, Electrical & Computer Eng 00101
Class material will be posted here and on Blackboard.
Piazza link is now alive. Please ask all questions/discussions via Piazza
Staff information:
Staff information:
Instructor: Tara Salman email: tsalman@ttu.edu Office: EC211D
TAs: Lead TA: Samin Dehbashi Sani (samin.dehbashi@ttu.edu) Grader:
Instructor office hours: Tue/Thu 1:00 pm – 3:00 pm, EC211D or by appointment
TA office hours: TBA
Description
Description
This course overviews a database system and its components, physical organization of data, data models, relational databases, and query processing.
This course overviews a database system and its components, physical organization of data, data models, relational databases, and query processing.
It has several objectives, including 1) an understanding of data modeling concepts, 2) a relational model for storage and retrieval of information, 3) formal query languages, and 4) current database technologies such as SQL.
It has several objectives, including 1) an understanding of data modeling concepts, 2) a relational model for storage and retrieval of information, 3) formal query languages, and 4) current database technologies such as SQL.
Key topics include, but are not limited to:
1. Relational Model
2. Relational Algebra
3. Data Definition and Manipulation with SQL;
4. Formal query languages
5. Normalization
6. Database Design Methodology
Textbook:
Textbook:
The textbook for the course is Fundamentals of Database Systems 7th edition, Ramez Elmasri and Shamkant B. Navathe, Pearson, 2015, ISBN: 9780133970777
Learning Outcomes & Assessment Methods
Learning Outcomes & Assessment Methods
Students who have completed this course should have the ability to:
1. Understand the fundamental principles of the relational data model
2. Formulate an Entity-Relationship (ER) diagram as conceptual design of database requirements
3. Map ER diagrams to relational schemas
4. Formulate a correct relational algebra expression to answer a query using a query language such as SQL that involves select-project-join, negation, union, intersection, minimum/ maximum, and a limited form of counting
5. Apply database theory to practice by creating a database application using a commercial database product
Prerequisites
Prerequisites
Course Prerequisites: CS 3364 Design and Analysis of Algorithms
Course Prerequisites: CS 3364 Design and Analysis of Algorithms
Expected Prior Knowledge and Skills: logic, some programming knowledge, teamwork proficiency
Expected Prior Knowledge and Skills: logic, some programming knowledge, teamwork proficiency
Grading Policy
Grading Policy
Your course grade shall be based on the following weights.
Assignments: 15%
Quizzes: 5%
Class contributions: 5%
Course project: 40%
Midterm 1: 20%
Midterm 2: 20%
See the syllabus for details.
Assignments and Project Descriptions
Assignments and Project Descriptions
HW 1 due on Feb 25th
The project proposal is due Feb 29th
HW2 due on March 11th
HW3 due on April 15th
HW4 due on April 29th.
Lectures
Lectures
Note: Please access the passcode for the video from Blackboard
Lecture 1 (Introduction to the course)
Date: Jan 16th.
Reading Resources:
Your Syllabus
Chapter 1 (up till 1.3)
Lecture 2 (Intro and DB architectures )
Date: Jan 21st
Reading Resources:
Chapters 1.3-1.7 &Chapter 2 (up till 2.3)
Lecture 3 (DB architectures and ER diagram start)
Date: Jan 23rd
Reading Resources:
Chapter 2 (2.5-end) &Chapter 3 (3.1-3,3 (not all))
Lecture 4 (Data modeling by ER diagram)
Date: Jan 28th
Lecture material: 1PP 4PP video summary In-Class_Problems
Reading Resources:
Chapter 3 (3.1-3,3 (not all))
Lecture 5 (Data modeling by ER diagram)
Date: Jan 30th
Lecture material: 1PP 4PP video summary In-Class_Problems In-Class_Problems_solution Quiz
Reading Resources:
Chapter 3 (3.1-3,3 (not all))
Lecture 6 (Data modeling by ER diagram)
Date: Feb 4th
Lecture material: In-Class_Problems_solution Quiz
Reading Resources:
Chapter 3 (3.1-3,3 (not all))
Lecture 7 (Data modeling by EER diagram)
Lecture 8 (Data modeling by EER diagram)
Date: Feb 11th
Lecture material: 1PP 4PP video summary In-Class_Problems In-Class_Problems_solution
Reading Resources:
Chapter 4(4.1-4.5)
Lecture 9 (EER/ER mapping to relational schema)
Lecture 10 (EER/ER mapping to relational schema)
Date: Feb 18th
Lecture material: 1PP 4PP video summary In-Class_Problems In-Class_Problems_solution Quiz
Reading Resources:
Chapter 9
Lecture 11 (Functional dependencies and normalization)
Lecture 12 (Functional dependencies and normalization)
Date: Feb 25th &Feb 27th
Lecture material: 1PP 4PP video summary In-Class_Feb_27 In-Class_Feb_27_Key In-Class_Feb_27_Key_details
Reading Resources:
Chapter 14
Week of March 3rd to March 7th
Exam review and exam
Lecture 13 (Basic SQL)
Lecture 14 (Basic SQL2)
Lecture 15 (Basic SQL3)
Date: March 27th
Lecture material: 1PP 4PP video summary In_class_March_27 In_class_March_27_solution Quiz3
Reading Resources:
Chapters 6 to 8
Lecture 16 (Advanced SQL)
Lecture 17 (Advanced SQL)
Date: April 3rd and 8th
Lecture material: 1PP 4PP video summary In class April3 In class April3 solution Quiz4
Reading Resources:
Chapters 6 to 8
Lecture 18 (Relational Algebra)
Lecture 18 (Relational Algebra 2)
Date: April 15th
Lecture material: 1PP 4PP video in-class_excercies solution
Reading Resources:
Chapters 8
Page updated
Google Sites
Report abuse