Databases (5op)

Osaamistavoitteet

Tieto puuttuu

Sisältö

The Students can design, define and implement databases. They know the tools for database administration.
Pedagogical arrangements Lectures, exercisesand self studying
Material Moodle environment with lessons and exercises, and self-study material
Content DATABASE THEORY
What is a databaseOperational DataData independenceRelational system and othersTHREE LEVELS OF THE ARCHITECTURE
External levelConceptual levelInternal level
ER-MODEL (Entity Relationship)
INTERACTIVE SQL
DATA DEFINITION LANGUAGE (SQL)
Base tablesIndexesData typesKeysReferential Integrity, Mto1, 1to1, MtoM relationsNormalizationFunctional dependenciesFirst, Second, Third Normal formSQL languageCREATE codeDROP (delete)ALTER (change)DATA MANIPULATION LANGUAGE (SQL)
TriggersProceduresViewsQuery analyzerSQL queriesSELECTJOINWHEREFunctionsAggregate functionsUNION
Assessment
The assessment criteria are the following:
Grade 0: You did not submit the course assignments or these assignments is not meeting the minimal quality requirements presented in the class.
Grades 1-2: You have delivered the assignments, which is prepared generally according to the requirements. You understand mostly correctly the subject matter concepts, are able to design and implement a general lever database solution. However, there is a room for development in your assignments. Your ER-diagrams are very basic, and not taking into consideration all aspects of requirements. Your database solutions are following your design. You are able to use basic SQL-queries
Grades 3-4: You have delivered the assignment, which is prepared according to the requirements. You understand very well the subject matter concepts, are able to design and implement a databases solution well. You have also good understanding how to draw actual customer requirements to detailed ER-diagram. Your database solution is following your design. You are able to use sql-queries with functions in complicated systems.
Grade 5: You have delivered the assignment on time, which is prepared according to the requirements. You understand deeply the subject matter concepts and are able to apply them correctly. You are able to design and implement a comprehensive database solution by using different sql-syntaxes for data manipulation. Your ER-diagrams are well defined, and according the requirements.

Arviointikriteerit, tyydyttävä (1)

Tieto puuttuu