Ms Access 2019 (5 ECTS)

Learning outcomes

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.

Teaching methods

Course is 100% online (Self-Study) course and it includes Excercises and Final test.

Location and time

Because course is 100% online (Self-Study) course, study place and timetable is up to Student her-/himself.

Learning materials and recommended literature

Can be find on study environment.

Alternative completion methods of implementation

N/A

Internship and working life connections

N/A

Exam dates and retake possibilities

Can be find on study environment.

International connections

N/A

Student workload

Can be find on study environment.

Content scheduling

Up to Student her-/himself.

Further information for students

ENROLMENTS
Open UAS, 3UAS and CampusOnline Students via eform

Metropolia's Degree Student
Go to Moodle -> https://moodle.metropolia.fi/course/view.php?id=1199
Enrolment key: Ms-Access-2019-v2020

Assessment methods and criteria

You shall return excercises and do Final Exam.

Notice! Final Exam don't get active before you have returned all of excercises.

Final exam is pass if you get more than 250/500 points.

Evaluation scale

Hyväksytty/Hylätty