Due to the Corona virus education methods or examination can deviate. For the latest news please check the course page in Brightspace.

Prospectus

nl en

Databases

Course
2021-2022

Entry Requirements

Does not apply.

Description

A Datanase Management System (DBMS) is an indispensable tool for managing large amounts of data. Today, databases exist in just about every branch of science, technology and business. This course is oriented at introductory databases courses at leading US universities and it provides a comprehensive introduction to database design and application. The course provides practical experience in designing a database and working with a DBMS. Basic theoretical topics will also be discussed. Finally, the course provides a first overview of recent topics in the field of databases such as Data Warehousing, Data Mining and Internet database management. Recommended prior knowledge: basic programming skills.

Learning goals

  • Translate real-world data organization and constraints into a relational database design using Entity-Relationship models

  • Learn how to create, manipulate, and query databases using SQL

  • Understand the mathematical foundation of databases (relational algebra)

  • Understand how to tune databases for access efficiency, concurrent access and redundancy avoidance (normalformen)

  • Learn how data is stored and how to prevent data loss, and how indexes and file-organizations can be used to accelerate access to data

  • Get an overview of advanced techniques such as OLAP, data mining, and data warehousing

Schedule

The most recent timetable can be found on the Student website:

  • [Schedules Informatica](https://www.student.universiteitleiden.nl/studie-en-studeren/studie/onderwijsinformatie/roosters/mathematics-en-natuurwetenschappen/informatica-bsc?cf=wiskunde-en-natuurwetenschappen&cd=computer- science-msc#tab-2)

  • [Schedules Computer Science & Economics](https://www.student.universiteitleiden.nl/studie-en-studeren/studie/onderwijsinformatie/roosters/wikunde-en-natuurwetenschappen/informatica-economie-bsc?cf=wiskunde-en- natural sciences&cd=computer science-economy-bsc#tab-2)

  • [Schedules Bioinformatics](https://www.student.universiteitleiden.nl/studie-en-studeren/studie/onderwijsinformatie/roosters/mathematics-en-natuurwetenschappen/bioinformatica-bsc?cf=wiskunde-en-natuurwetenschappen&cd=bioinformatica- bsc#tab-2)

  • [Schedules Artificial Intelligence](https://www.student.universiteitleiden.nl/studie-en-studeren/studie/onderwijsinformatie/roosters/mathematics-en-natural sciences/artificial-intelligentie-bsc?cf=wiskunde-en-natural sciences&cd =computer science-bsc#tab-2)

Educational form

  • 2 hours of lectures per week followed by 2 hours of practical/seminar led by an assistant(s) (including at least 5 lab sessions).

  • We will work with SQLlite, a database management system that works on all platforms and

Review

A final exam will form 70% of the grade,
a group assignment and a mid-term test (with retake possibility) will form together 30% of final grade.. The teacher will inform the students about precise testing modalities during first lecture.
The test will take place during time scheduled for lecture and there will be a retake possibility for the test (not for the group assignment).

Literature

  • Ramakrishnan, R. & Gehrke, J. (2003). Database Management Systems (Vol. 3), McGraw-Hill.

  • Slides available on the webpage.

Sign Up

You can enroll via uSis . More information about signing up for classes and exams can be found [here ](https://www.student.universiteitleiden.nl/en/administrative-matters/registration--de-registration/course-and-exam-enrolment/course -and-exam-enrolment/science/computer-science-economics-bsc?cf=science&cd=computer-science-economics-bsc#tab-2).

MyTimetable

In MyTimetable you can find all subject and training schedules, with which you can compose your personal schedule. Educational activities for which you are registered in uSis are automatically shown in your timetable. In addition, you can easily link My Timetable to a calendar app on your phone and schedule changes are automatically implemented in your calendar; moreover, if desired, you will receive a notification of the change by e-mail.

Questions? Watch the video instruction, read the instruction or contact the ISSC helpdesk.

Brightspace

Registration for courses is via uSis. When you register here for a certain course, you automatically receive access to the environment of this course via Brightspace.

For more information about Brightspace, you can click on this link to view the university manuals.

Contact

For other questions or problems, please contact the coordinator BSc informatics Riet Derogee.