Introduction to Databases
mr. sc. Mario Fabijanić, dipl. ing.
2. M. Radovan: Baza podataka, Informator, Zagreb, 1993.
2. D. J. Ullman: Database and Knowledge - base Systems, Computer Science Press, 1999.
3. Clare Churcher, Beginning Database Design: From Novice to Professional, Apress, January 2007.
4. E. F. Codd, The Relational Model for Database Management: Version 2, Addison Wesley Publishing Company, April 1990.
Minimum learning outcomes
- Construct relational model based on user requests
- Use DDL instructions to implement relational model
- Use basic SQL instructions for data manipulation in relational database
- Use joins for data retrieval in relational database
- Recognize normal form of relational database
- Use system and aggregate functions and grouping for data retrieval
- Use subqueries
Preferred learning outcomes
- Choose most efficient relational model
- Differentiate effects of constraints on relational model
- Analyze effects of SQL instructions on data consistency
- Solve problem by using joins
- Suggest changes in relational schema in order to achieve higher normal form
- Solve problem by using system and aggregate functions and grouping
- Compare data retrieval by using joins and subqueries