Course introduction
General information
| Name | Advanced Databases |
| Course is provided by | JAMK, School of Information Technology |
| Teacher | Jouni Huotari |
| Number of ECTS Credits | 7 |
| Period | Spring 2022, see the homepage for detailed schedule |
| Target group | JAMK students (3rd year), bachelors's Degree |
| Field of Study | Technology, communication and transport |
| Grading scale | 0-5 |
| Language of Instruction | English |
| Prerequisite(s) | Basics of Databases |
Objectives / Learning outcomes
The student
- understands database design, conceptual modeling and logical data modelling as parts of the development of information systems, and
- is able to make a normalised relational database based on a conceptual and logical data model.
- knows the basics of database administration and
- is able to specify users and their access rights, and monitor, maintain, and optimise databases.
Assessment Methods and Criteria
The course is evaluated summatively following its completion and presentation, on a five-point scale according to the points achieved during the course:
- To Pass (S or 1), the student can design and implement a normalized database (comprising of approximately 10 tables) and perform the most typical database administrative tasks such as creating a database, importing data to it, giving access rights, and monitoring the performance.
- Excellent 5: The student 1) provides detailed, clear, error-free, and complete documentation about database design (at least five concepts and 10 tables in 3rd normal form) and database management; 2) carries out database assignments and exams without major flaws or errors in database design and management.
These, including the final presentation, show
1) ability to document and argument design decisions understandably, 2) knowledge and understanding of concepts, and 3) practical skills of database design and management.
Communication during the course
Besides the contact lectures, we offer the following channels for communication:
- Zoom (enabling virtual/online participation) => the lectures will be recorded and saved.
- Teams
- Moodle (for returning assignments).
Feedback
Mid-term feedback by using Padlet or similar. The official feedback will be asked if this course is selected for that. There is also a button for continuous feedback (can you see it in the bottom right corner?).