Ms Access (5 cr)
Code: TT00FP95-3004
General information
- Enrollment
-
05.08.2024 - 31.12.2025
Enrollment is ongoing
Enroll to the implementation in OMA
- Timing
-
05.08.2024 - 31.12.2026
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
- Finnish
- Seats
- 0 - 500
- Degree programmes
- Information and Communication Technology
- Teachers
- Virve Prami
- Teacher in charge
- Janne Salonen
- Groups
-
CAMPUSONLINE_TIVI_NONSTOPCampusOnline implementations (Tivi Nonstop)
- Course
- TT00FP95
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
Student shall first do all of lectures and after that Final Exam.
Evaluation scale
Hyväksytty/Hylätty
Assessment criteria, approved/failed
Pass/Fail.
Assessment methods and criteria
Pass after all of lectures has been done and the Final Exam passed.
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.