welcome to tddd12 database technology - ida > home · 8 database technology topic 1:...
TRANSCRIPT
![Page 1: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/1.jpg)
Welcome toTDDD12Database Technology
Olaf Nikita Eric MatteusHartig Korzhitskii Dahlgren Laurent
![Page 2: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/2.jpg)
Topics andIntended Learning Outcomes
![Page 3: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/3.jpg)
3Database TechnologyTopic 1: Introduction
Course Topics1. Fundamental concepts
2. Relational databases
3. SQL
4. EER modeling
5. Mapping of EER dia-grams to relations
6. Functional dependenciesand normalization
7. Stored procedures and triggers
8. Data structures for DBs
9. Introduction to Transaction Processing
10. Concurrency Control
11. Database Recovery
12. Query Processing
![Page 4: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/4.jpg)
4Database TechnologyTopic 1: Introduction
After the course you should be able to ...● Design relational databases for different
types of example domains by first creatinga conceptual schema using the EnhancedEntity-Relationship (EER) model and thentranslating this conceptual schema into acorresponding logical schema capturedin the relational data model.
● Analyze and improve the quality ofgiven relational database schemasbased on the formal measure ofnormal forms.
![Page 5: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/5.jpg)
5Database TechnologyTopic 1: Introduction
After the course you should be able to ...● Employ the SQL language to query and to modify several
example relational databases, as well as to create sucha database with a given relational database schema.
● Compare the cost of finding and updating records in database storage files when using different approaches to organize and to index such files.
● Apply basic techniques that DBMSs may use to identify and to avoid problems that may occur when multiple users access a database concurrently.
● Apply recovery algorithms that DBMSs use to guarantee persistence of data even in the case of system failures.
![Page 6: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/6.jpg)
Examination
![Page 7: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/7.jpg)
7Database TechnologyTopic 1: Introduction
Final Exam● During the exam period after the course● Dates: see pointer at the course Website● Form of this examination still to be decided
![Page 8: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/8.jpg)
8Database TechnologyTopic 1: Introduction
Four Assignments1. SQL
2. Database design and EER modeling
3. Functional dependencies and normalization
4. BrianAir project, lab4a: initial design, lab4b: improved design lab4c: implementation, lab4d: urkund analysis
● Deadlines on the course Website– hard deadlines for lab4a and lab4b
● To be solved in pairs– register with a lab partner in Webreg before the end of this week
● Use MySQL server for lab1 and lab4c– need access to MySQL server provided by LiU IT– instructions on the course Website
(before lab2 and lab3!)
![Page 9: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/9.jpg)
Organization of the Course
![Page 10: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/10.jpg)
10Database TechnologyTopic 1: Introduction
Structure of the Course● Schedule see the course Website● 12 lecture sessions
– Text book: Elmasri and Navathe. Fundamentals ofDatabase Systems, Addison Wesley, 7th edition.
● 9 lab sessions– First two: focus on assignment #1– Third one: focus on assignment #2– Remaining six: focus on assignment #4c
(only three of these six lab sessions will be supervised)
● 3 teaching sessions– First one: Discussion of #4a hand-ins (mandatory!)– Second and third: practice with functional dependencies
and normalization (related to assignment #3)
![Page 11: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/11.jpg)
11Database TechnologyTopic 1: Introduction
Flipped Classroom-like Model
● Idea:– you watch a video lecture before each lecture session– we use the lecture session to do some quizzes, go through
some additional examples, and discuss questions and things that were unclear to you in these video lectures
![Page 12: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/12.jpg)
12Database TechnologyTopic 1: Introduction
Flipped Classroom-like Model
● Idea:– you watch a video lecture before each lecture session– we use the lecture session to do some quizzes, go through
some additional examples, and discuss questions and things that were unclear to you in these video lectures
● In contrast to trying to replicate traditional lectures– more flexibility in terms of when you watch the videos
(plus, you can pause, repeat, fast-forward, etc.)– role of the lecture sessions: give you ample opportunity to
ask questions and to reinforce your learning of the concepts
![Page 13: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/13.jpg)
13Database TechnologyTopic 1: Introduction
Please bear with us!
● Not everything is guaranteed to run smoothly● We are trying our best
![Page 14: Welcome to TDDD12 Database Technology - IDA > Home · 8 Database Technology Topic 1: Introduction Four Assignments 1.SQL 2.Database design and EER modeling 3.Functional dependencies](https://reader036.vdocuments.us/reader036/viewer/2022071302/60add1d2831c5f15e147bfae/html5/thumbnails/14.jpg)
www.liu.se