581328 Introduction to Databases (luonnos )
Principal theme | Prerequisite knowledge | Approaches the learning objectives | Reaches the learning objectives | Deepens the learning objectives |
---|---|---|---|---|
Data and data modelling |
Can explain how structured data differs from unstructured data Can describe the principles of processing data Can explain the difference of data and its description
Can explain the the difference of data contents and data representation Can explain the main concepts of a conceptual level data model Is able to interpret conceptual level data descriptions
Knows data representation and access principles
Is able to explain the principle of XML data structures
|
Can explain the use of abstraction levels in desribing data
Can explain the data model concept
Is able to interpret and construct a conceptual level data model for a small amount of data
Knows the most important quality constraints for data desrciptions and is able to analyse the quality of a data description
Is able to describe the ways to access data in different types of data stores. Can explain the principles of the XML structure and compare the structure to other data modelling techniques
|
Is able to independently get acquainted with data modelling techniques and their notations
|
|
Principles of the relational model of data
|
The concept of a mathematical relation The operations of mathematical set theory and associated notations
Principles of logical expressions and connectives (and, or. -not)
|
Can explain the basic concept of the relational model (relation, tuple, attribute, domain, key, foreign key)
Can explain the principle of connecting data in the relational database Can explain the operations of the relational algebra and the constraints for these operations Is able to interpret different notations to define relational database structures
|
Knows well the concepts and notations of the relational model
Knows how to connect data in the relational model and is able to apply this knowledge in practice Knows how the operations of the relational algebra work and is able to estimate the sizes of operation results
|
Is able to express queries in relational algebra
Gets acquainted to extensions of the relational model and variations of the operations
Familiarizes oneself to the principles of query optimization.
|
Databases
|
Knows how the traditional files are used in programs
|
Is able to identify features that separate databases from traditional files Can explain what is metadata
|
Cand explain extensively how realtional databases differ from traditional files
Is able to identify the kernel component of a database management system and describe their responsibilities Is able to explain the principle of data independence
|
Knows how to utilize metadata
|
SQL |
Logical expression in programming languages
|
Is able to interpret a database description in SQL
Is able to express a simple need for data as an SQL query
Is able to carry out simple database maintenance operations with SQL
|
Is able to define a database in SQL
Is able to express his/her data needs as SQL queries
Is able to carry out database maintenance operations in SQL Knows the transaction concept and is able to compose database maintenance operations in transactions.
|
Is able to utilize manuals and uses SQL fluently in database processing
Is able to estimate the sizes of query results and the time of processing the query
|
Database design
|
Is able to describe the principles of desining a relational database structure based on the conceptual model of data
Can explain the concept of functional dependency
Can explain the Boyce-Codd normal form
|
Is able to design relational database structures based on the conceptual model of data
Is able to interpret and identify functional dependencies Is able to analyse database structures using functional dependencies
Is able to define keys for relations
|
Is able to analyse database structures using extensive criteria Masters the syntactic design theory for relational databases
|