- Describe what a relational database is and explain the basics of how a relational database works
- Describe what a transaction is, what properties it has and explain why databases use transactions
- Characterize different kinds of database systems
- Compare and debate different database concepts
- Create a data model using ER diagrams
- Design a relational databases based on a data model following standard methodology
- Develop queries to the database using SQL
- Develop a program that uses the database
- Apply a database as a part of a software development process
This course includes data modeling, use of relational databases, query optimization and transactions. Data modeling means to set up a model or overview of the data that one wants to store. Relational databases are the most commonly used form of database system today. Query optimization is how to make sure that your queries run as quickly as possible. Transactions are important for all database systems that can be used by more than one user at the same time.
Required prerequisite knowledge
|Written exam||1/1||4 hours||A - F||Valid calculator. |
Completion of mandatory lab assignments is to be made at the times and in the groups that are assigned and published. Absence due to illness or for other reasons must be communicated as soon as possible to the laboratory personnel. One cannot expect that provisions for completion of the lab assignments at other times are made unless prior arrangements with the laboratory personnel have been agreed upon.
Method of work
|Database systems (BID190_1)||10|
|Data modelling (BID120_1)||6|
|Data modelling (TE0569_1)||6|
Bachelor studies at the Faculty of Science and Technology.
Master studies at the Faculty of Science and Technology.
Last updated: 24.01.2020