Database DesignLaajuus (5 cr)
Course unit code: IIO30120
General information
- Credits
- 5 cr
- Teaching language
- English
Objective
The students
- understand conceptual modeling and database designing as parts of the development of information systems
- can perceive information and related rules of the application area at a conceptual level
- can make descriptions (with a CASE tool) of the information objects of the application area and their interrelations
- can make a normalised relational model database description based on a conceptual model
Content
The design process from concept and needs analysis to normalisation and the physical design of a database;
the use of a CASE (Computer Aided Software Engineering) tool for data modelling;
designing a database
Qualifications
Basics of Databases or equivalent
Assessment criteria, satisfactory (1)
- excellent (5): exemplary performance in all the subareas; the choices are well justified and the meta data has been saved, innovative solution, excellent modelling competence
- good (3-4): the database has been designed and documented rather comprehensively and nearly faultlessly, good knowledge of modelling
- satisfactory (1-2): mastery of the basics