Ms AccessLaajuus (5 cr)
Course unit code: TT00FP95
General information
- Credits
- 5 cr
- Teaching language
- English
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.
Assessment criteria, approved/failed
Pass/Fail.