Syllabus

Title
1519 Database Systems
Instructors
Dr. Amr Azzam, M.Sc.
Contact details
Type
PI
Weekly hours
2
Language of instruction
Englisch
Registration
09/01/22 to 10/02/22
Registration via LPIS
Notes to the course
The subject "Database Systems" will be held in the winter semester 2022 for the last time.
Subject(s) Bachelor Programs
Dates
Day Date Time Room
Wednesday 10/12/22 03:30 PM - 06:30 PM D2.-1.019 Workstation-Raum
Thursday 10/20/22 09:00 AM - 11:30 AM D2.-1.019 Workstation-Raum
Thursday 10/27/22 09:00 AM - 11:30 AM D2.-1.019 Workstation-Raum
Thursday 11/03/22 09:00 AM - 11:30 AM D2.-1.019 Workstation-Raum
Thursday 11/10/22 09:00 AM - 11:30 AM D2.-1.019 Workstation-Raum
Thursday 12/01/22 09:00 AM - 11:30 AM D2.-1.019 Workstation-Raum
Thursday 12/15/22 09:00 AM - 11:30 AM D2.-1.019 Workstation-Raum
Wednesday 12/21/22 09:00 AM - 11:30 AM D2.-1.019 Workstation-Raum
Thursday 01/12/23 09:00 AM - 11:30 AM D2.-1.019 Workstation-Raum
Contents
  • Theoretical and Practical Aspects of DBMS.
  • Relational Model (basis, relational algebra, data description and data manipulation)
  • Relational Theory (Semantic constraints, functional dependencies, normal forms)
  • Transactions (ACID principle, correctness, parallel processing)
  • Optimization (Indexes, Query Plan)
  • Structured Query Language SQL
  • NoSQL databases (Key-Value stores, document DBs, GraphDBs, Semantic Web triple stores)
  • In-Memory DBs 
  • Big Data, Google BigTable, etc.

Learning outcomes
  • Understanding of DBMS and ability to apply DBMS in practice
  • Understanding of the relational model and the basic concepts of the relational theory
  • Understanding of the basic concepts of transactions and optimizations
  • Ability to formulate SQL statements to solve practical problems
  • Integration of DB and websites (PHP)
  • Basic ideas of non-relational DBs, including graph databases and NoSQL stores
  • Current scalability issues (Big Data)
Attendance requirements

at least 80% attendance

Teaching/learning method(s)
  • Lessons and computer exercises with DBMS on Linux servers
  • Active participation in solving tasks using DBMS
  • Repetitions of lesson content in front of your colleagues
  • Peer Review (review each others’ work)
  • Presentation of a final project
Assessment
  • 40% - Homeworks submitted via learn@WU
  • 20% - Test
  • 25% - Presentation of final project (a small database application)
  • 15% - Commitment in class
Prerequisites for participation and waiting lists

Nach Ende der Anmeldefrist werden verfügbare LV-Plätze den Studierenden der Warteliste, die noch keine gültige Anmeldung zum Planpunkt haben, gereiht nach Studienfortschritt zugeteilt, nicht nach Wartelistenplatz.

Availability of lecturer(s)
Additional information on MyLEARN.

 

Last edited: 2022-04-20



Back