Objectives:
Introduction to basic concepts of relational databases: entity, relation, table, record,
properties, queries, etc.
Introduction to basic concepts of computer programming using visual programming
language (e.g. Scratch): algorithm, input, output, variables, flow control structures.
Content:
1. Introductory lecture and exercises.
2. Data model, entities and their properties
3. Relational database model
4. Primary and secondary key, relations between tables
5. Introduction to computing environment
6. Data integrity
7. Forms and reports
8. Queries
9. Mid-term exam
10. Introducing to visual programming language and programming enviroment.
Sprites and their attributes.
11. Colour, sound, speech, moving, effects, drowing.
12. Variables. Input and output. Control structures. Sequence.
13. Selection.
14. Iteration.
15. Final exam.
|
- Grundler, Gvozdanović, Ikica, Kos, Milijaš, Smec, Širanović, Zvonarek: ECDL 5.0 (Windows 7, MS Office 2010)
- Otvoreno društvo za razmjenu ideja (ODRAZI): SCRATCH - Vodič za korisnike i korisnice
- Čelebić, Dujlo: Baze podataka - Microsoft Access 2010, priručnik
|