| IIO30120 Database design - schedule 2015 | |||||||||
| Teaching in D331 on Mondays at 08.15 - 11.15 (coffee break at 9.00) | |||||||||
| Week | Date | Hrs | Themes | Additional material | Assignments | Due | Kirja | suomeksi | |
| 36 | 31.8. | 2,0 | Course introduction | Examine Optima workspace | |||||
| 0,2 | Learning report | Setting your own goals | 10.12. | Oppimisraportti | |||||
| 0,3 | Previous projects | Check Asio description | |||||||
| 0,5 | Assignment: database project | Choose topic and project group | Harjoitustyöohje | ||||||
| 1,0 | Brain storming | In Optima (exercise 1) | 2.11. | (Luku 1) | Aivoriihi: keskeiset osattavat asiat | ||||
| 37 | 7.9. | 2,0 | Design goals | Objectives of DB Design | In Optima (exercise 2) | 2.11. | Luvun 2 alkuosa | Tietokannan suunnittelun tavoitteet | |
| 2,0 | Modelling exercise: car rental enterprise | ||||||||
| 38 | 14.9. | 3,0 | Database Analysis | Data modelling | Examine CASE tools | Luvun 2 loppuosa | Käsiteanalyysi (osin kertausta tk-perusteista) | ||
| 1,0 | Conceptual Modelling | In Optima (exercise 3) | 2.11. | Luku 3, s. 32 - 60 (-67) | Käsitemallin tekeminen | ||||
| 39 | 21.9. | 2,0 | Logical data model | Luku 4, s. 80 - 85 | Tietokantakaavion tekeminen | ||||
| 1,0 | Analysing data needs; interviews | In Optima (exercise 4) | 2.11. | Luku 3, s. 68 - 71 | Tarveanalyysi; haastattelu ja sopimus | ||||
| 1,0 | Requirements Specification | Start writing the req. spec. about your topic | Vaatimusmäärittelyn tekeminen | ||||||
| 40 | 28.9. | 4,0 | Normalization | Discussion | In Optima (exercise 5) | 2.11. | Luku 5, s. 86 - 103 | Normalisointi (ja denormalisointi) | |
| 41 | 5.10. | 2,0 | From UML class diagrams to relational model | Championzone example | Luku 3, s. 71 - 79, liite 1 | UML-kuvaukset, notaatioiden vertailua | |||
| 1,0 | ORM | Object-relational mapping | In Optima (exercise 6) | 2.11. | Luku 7 | ORM, luokkakaaviosta käsitemalliin | |||
| 1,0 | Physical modelling | From logical to physical | In Optima (exercise 7) | 2.11. | Luku 6 | Taulujen muodostaminen käsitemallista | |||
| 42 | 12.10. | No lectures | Etäopetusviikko | ||||||
| 43 | 19.10. | 1,0 | Intermediate evaluation | Feedback given in Optima | 19.10. | Väliarviointi | |||
| 1,0 | Modeling principles and approaches | Check MetaEdit+ (by MetaCase Consulting) | |||||||
| 2,0 | Modelling exercise and model checking | Modelling exercise #2 | Harjoitustöiden ohjausta | ||||||
| 44 | 26.10. | 2,0 | Data warehouse design; OLAP | Data warehouse explained | Luku 8 | Tietovarastojen suunnittelu | |||
| Data analysis; reporting | Examine tools and services | Hovin Tietovarastot-kirja | Tietovarastointi ja raportointi | ||||||
| 45 | 2.11. | 4,0 | Answers to Optima exercises | Modelling exercises | Luvut 1 -7 | Yhteenveto; tietokannan luonti kuvauksesta | |||
| 46 | 9.11. | 2,0 | Instructions for exam and presentation | Document your database project | Ohjeita esitykseen ja osaamistestiin (kertaus) | ||||
| 2,0 | Group work and personal guidance | Harj.työn ohjausta | |||||||
| 47 | 16.11. | 4,0 | Exam, part 1 | Theoretical part | Osaamistesti: kirjallinen osio | ||||
| 48 | 23.11. | 4,0 | Exam, part 2 | Example test (applied part) | Osaamistesti: mallinnuskoe (soveltava osio) | ||||
| 49 | 30.11. | 2,0 | Exam return; quidance for group work | Write the final report | 14.12. | Loppuraportin tekeminen | |||
| 50 | 7.12. | 4,0 | Presentations; course evaluation | Return all assignments to Optima | 14.12. | Esitykset; yhteenveto ja arviointi | |||
| 51 | 14.12. | 4,0 | Presentations; course evaluation | Course evaluation | 20.12. | Osaamistestin uusinta 15.12. klo 8.15 alkaen | |||
| Total | 56,0 | ||||||||
| Choose a topic and ask a virtual machine if you need one. | See also Database management course | ||||||||
| Last update: 14.12.2015 | © Jouni Huotari | ||||||||