LV EN RU DE FR

Database Design

Course developer

Course abstract

The aim of the course is to acquire theoretical and practical knowledge about data base design tasks and possible solutions using data and data base modelling and design tools and techniques

Learning outcomes and their assessment

Knows about database design tasks execution options and automation tools (1. test, exam).
Have skills to develop and analyze database models, to identify modeling errors and perform error correction, to transform developed models to physical database structures with data and database modeling and design tool (practicals, 2. test, exam).
Acquire competences of analysis and modeling of object environment, development of data conceptual, logical and physical models (practicals, 3. test, exam).

Course Content(Calendar)

1 Data base life cycle (2h lecture).
2 Data base design concepts (2h lecture).
3 Analysis of data requirements (2h lecture, 4h practicals).
4 Data base design methods (2h lecture).
5 Data and data base modelling and design tools and techniques (2h lecture, 4h practicals).
6 Data and data base modelling and design tool Oracle SQL Developer Data Modeler (2h lecture, 4h practicals).
7 Data flow modelling using data flow diagrams (2h lecture, 4h practicals).
8 Extended entity-relationship model (2h lecture).
9 Extended entity-relationship model notations (2h lecture).
10 Data storage structure generation from concept models (2h lecture, 4h practicals).
11 Concept model generation from data storage structures (2h lecture, 4h practicals).
12 Initial population of the target database (2h lecture, 4h practicals).
13 Tuning of Structured Query Language queries (2h lecture, 4h practicals).
14 Implementation of data base (2h lecture).
15 Quality control of data base design development (2h lecture).
16 Data base design tools and techniques further development (2h lecture).

Requirements for awarding credit points

To be allowed to participate in the exam, students need to develop and successfully defent assigned practicals and receive at least 4 points or above as average mark from 3 tests.
1.test: Data base design theoretical foundation
2.test: Data base model development and transformation
3.test: Physical data model development and tuning

Description of the organization and tasks of students’ independent work

During the course students independently might need to finish practical assignments in case they do not manage to complete them during lesson. Practical assignments must be defended within 3 weeks after task is assigned. During practicals students create data base project using data base modelling tool.

Criteria for Evaluating Learning Outcomes

As the end of the course students need to pass exam.

To be allowed to participated in the exam students need:
1.successfully complete and defend practical tasks
2.successfully pass tests (average mark from tests is above 4 points)
In the exam students receive practical assignment to design data base and provide written answers to theoretical questions about data base design.

Compulsory reading

1.Teorey T., Lightstone S., Nadeau T. and Jagadish H.V. Database Modeling And Design: Logical Design. 5th Ed. Burlington, USA: Morgan Kaufmann, 2011. (Pieejama pie kursa atbildīgā pasniedzēja)
2.Date C.J. Introduction to Database Systems. 8th Ed. Boston, USA: Addison Wesley, 2004.
3.Toby J.T. Physical Database Design. 4th Ed. San Francisco, USA: Morgan Kaufmann, 2007. (Pieejama pie kursa atbildīgā pasniedzēja)
4.Powell G. Beginning Database Design. Indianapolis, USA: Wiley Publishing, 2006. (Pieejama pie kursa atbildīgā pasniedzēja)

Further reading

Hansen, K.B. Practical Oracle SQL: Mastering the Full Power of Oracle Database, APress, 2020. 460 p. ISBN-10: 1484256166 (pieejama Datoru sistēmu katedras bibliotēkā) (Available in the library of Department of Computer Systems)

Periodicals and other sources

1.Oracle Magazine. Oracle Press. Pieejams (Available): http://www.oracle.com/technetwork/oramag/magazine/home/index.html
2.The International Journal on Very Large Data Bases. Springer Berlin Heidelberg. ISSN: 1066-8888. Pieejams (Available): https://www.springer.com/journal/778
3.Oracle SQL Developer Data Modeler Technical documentation. Pieejams (Available): https://docs.oracle.com/en/database/oracle/sql-developer-data-modeler/

Notes

ITF Master's Academic Study Program "Information Technologies".