General information

Course type AMUPIE
Module title Databases for beginners
Language ENG
Module lecturer dr Iwona Gulaczyk
Lecturer's email gulai@amu.edu.pl
Lecturer position Starszy wykładowca
Faculty Faculty of Chemistry
Semester 2021/2022 (winter)
Duration 45
ECTS 5
USOS code 02-DBBA

Timetable

Module aim (aims)

• Understanding of what a relational database is
• To teach students how to design a database using Microsoft Access
• To teach students how to retrieve the required information from a database by different forms of queries
• To teach students how to create reports and forms based on the appropriate queries

Pre-requisites in terms of knowledge, skills and social competences (where relevant)

The course is dedicated to both the students with some knowledge of databases and to students who are not familiar with databases and programming at all.

Syllabus

Week 1: What is a database? Microsoft Access database design. Columns and tables. Working with data.
Week 2: Database models. Relational model.
Week 3: Types of relations (attributes, domains, a primary key, a foreign key, a superkey). Indexing. Null values.
Week 4: Database normalization. Rules of data normalization (normal forms). Denormalization.
Week 5: Examples of Access databases. Creating and working with databases.
Week 6: Creating queries in Access. Select queries in the query design grid.
Week 7: Left join, right join operations.
Week 8: Using criteria and expressions in Access to retrieve data. A parameter query.
Week 9: Creating and working with action queries in the query design grid (delete, update, append and make-table queries).
Week 10: SQL queries. Simple select queries and SQL aggregate.
Week 11: SQL action queries.
Week 12: Forms (created using the Form tool and the Form Wizard). Forms based on one table or query and based on many tables or queries. Forms with subforms.
Week 13: Forms with combo boxes.
Week 14: Forms with interactive buttons.
Week 15: Reports (created using the Report tool and the Report Wizard). Simple reports and grouped or summary reports. Reports with subreports.

Reading list

Access Database Design & Programming, Steven Roman, 2002
Database systems: A Practical Approach to Design, Implementation and Management, T. M. Connolly, C.E. Begg, 2004