Admission requirements
Not applicable.
Description
A DataBase 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.
Course objectives
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 (normal forms)
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
Timetable
In MyTimetable, you can find all course and programme schedules, allowing you to create your personal timetable. Activities for which you have enrolled via MyStudyMap will automatically appear in your timetable.
Additionally, you can easily link MyTimetable to a calendar app on your phone, and schedule changes will be automatically updated in your calendar. You can also choose to receive email notifications about schedule changes. You can enable notifications in Settings after logging in.
Questions? Watch the video, read the instructions, or contact the ISSC helpdesk.
Note: Joint Degree students from Leiden/Delft need to combine information from both the Leiden and Delft MyTimetables to see a complete schedule. This video explains how to do it.
Mode of instruction
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 SQLite, a database management system that works on all platforms.
Assessment method
A final exam will form 70% of the grade, and a group assignment and digital test will form together 30% of the final grade. The teacher will inform the students about precise testing modalities during the first lecture.
The test will take place during the time scheduled for a lecture. There will be a retake possibility for the final exam (not for the group assignment and test).
Reading list
Ramakrishnan, R. & Gehrke, J. (2003). Database Management Systems (Vol. 3), McGraw-Hill.
Slides available on Brightspace.
Registration
As a student, you are responsible for enrolling on time through MyStudyMap.
In this short video, you can see step-by-step how to enrol for courses in MyStudyMap.
Extensive information about the operation of MyStudyMap can be found here.
There are two enrolment periods per year:
Enrolment for the fall opens in July
Enrolment for the spring opens in December
See this page for more information about deadlines and enrolling for courses and exams.
Note:
It is mandatory to enrol for all activities of a course that you are going to follow.
Your enrolment is only complete when you submit your course planning in the ‘Ready for enrolment’ tab by clicking ‘Send’.
Not being enrolled for an exam/resit means that you are not allowed to participate in the exam/resit.
Contact
Education coordinator LIACS bachelors
Remarks
Software
Starting from the 2024/2025 academic year, the Faculty of Science will use the software distribution platform Academic Software. Through this platform, you can access the software needed for specific courses in your studies. For some software, your laptop must meet certain system requirements, which will be specified with the software. It is important to install the software before the start of the course. More information about the laptop requirements can be found on the student website.