Ms Access (5 op)

Tavoitteet

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.

Sisältö

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.

Aika ja paikka

Course environment is Metropolia's Moodle and course can be done in own space.

Oppimateriaalit

Online.

Opetusmenetelmät

Course is 100% online and can be done in own space.

Harjoittelu- ja työelämäyhteistyö

N/A

Tenttien ajankohdat ja uusintamahdollisuudet

Online.

Kansainvälisyys

N/A

Toteutuksen valinnaiset suoritustavat

N/A

Opiskelijan ajankäyttö ja kuormitus

Depends on the student's starting level.

Sisällön jaksotus

Up to Student her-/himself.

Arviointiasteikko

Hyväksytty/Hylätty

Arviointikriteeri, hyväksytty/hylätty

Pass/Fail.

Osaamistavoitteet

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.

Sisältö

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.