File Structures
DATABASE THEORY & APPLICATIONS
DTA(M)
Dr Chris Anagnostopoulos
Associate Professor in Pervasive Data Science &
Distributed Computing
GENERAL COURSE INFORMATION
Course Delivery
Pre-recorded Lectures (Weeks 1-9) & Guest Lecture (Week 10)
Access Passcode for ALL recordings: DBH2021!
Lectures Discussion/Q&A: Thu 11h00 – 12h00 @Zoom (live)
Meeting ID: 938 1732 8566; Passcode: DTAM
Using sli.do for Q&A Sessions (event codes will be sent over)
Labs online @MS Teams and on-campus @BO 1028 (Weeks 1-9) on Fridays
Fri 11h00 – 12h30
Fri 12h30 – 14h00
Fri 15h00 – 16h30
You attend one of them; check the registration lists on Moodle
Office hour: devoted slot Thu 10h00 – 11h00 @ Zoom (live) (Weeks:1-9)
Meeting ID: 948 5541 5886; Passcode: DTAOFFICE
Individual Assessed Coursework (Practice 2022): 20%
Exam: 80%
2
RESOURCES
Textbooks
Fundamentals of Database Systems, Elmasri & Navathe, 7th Edition,
Pearson, 2017.
Online access via UoG Library
Database Systems: The Complete Book, H. Garcia-Molina, J.D. Ullman
and J. Widom, Pearson Education Ltd 2014.
Online access via UoG Library
Course Web Page on Moodle
Updated regularly as we go
News/information regarding the course will be posted on Moodle
Lecture Notes/Recordings/handouts will be provided on Moodle.
Pre/post-session activities are completely optional!
3
COURSE CONTENTS
Part A: Relational Database Design (~4 weeks)
Entity-Relationship Conceptual Modelling
Relational Schema
Functional Dependency Theory
Normalization Theory
Part B: SQL (~3 weeks)
Basic SQL (Part I)
Basic SQL (Part II)
Advanced SQL: Analytics (Part III)
Part C: Optimization & Semantic Modelling (~ 3 weeks)
Relational Algebra
Heuristic Query Optimization
Guest lecture
4
R
e
la
t
io
n
a
l D
e
s
ig
n
P
r
in
c
ip
le
s
D
a
t
a
b
a
s
e
F
u
n
d
a
m
e
n
t
a
ls