Ms Access (5 cr)
Code: TT00FP95-3002
General information
- Timing
-
01.01.2025 - 31.12.2025
Implementation is running.
- Number of ECTS credits allocated
- 5 cr
- Virtual portion
- 5 cr
- Mode of delivery
- Online
- Unit
- School of ICT and Industrial Management
- Campus
- Karaportti 2
- Teaching languages
- English
- Seats
- 0 - 5000
- Degree programmes
- Information and Communication Technology
Objective
Having passed the course, the student understands the importance of databases as part of information systems. The student is familiar with the relational model and other data models. The student is able to design and implement a relational database. The student is able to use and administer the database with a manipulation language.
Content
Data models and information systems. Conceptual modelling. Principles of relational databases. Implementation and normalisation of a relational database. Data definition language. Data manipulation language. SQL. Relational algebra.
Location and time
Course environment is Metropolia's Moodle and course can be done in own space.
Materials
Online.
Teaching methods
Course is 100% online and can be done in own space.
Employer connections
N/A
Exam schedules
Online.
International connections
N/A
Completion alternatives
N/A
Student workload
Depends on the student's starting level.
Content scheduling
Up to Student her-/himself.
Evaluation scale
Hyväksytty/Hylätty
Assessment criteria, approved/failed
Pass/Fail.
Objective
Having passed the course, the student understands the importance of databases as part of information systems. The student is familiar with the relational model and other data models. The student is able to design and implement a relational database. The student is able to use and administer the database with a manipulation language.
Content
Data models and information systems. Conceptual modelling. Principles of relational databases. Implementation and normalisation of a relational database. Data definition language. Data manipulation language. SQL. Relational algebra.