 |  | |  |
| INFO0927-1

 | Introduction to databases

| |
| 
| |
| Duration : | 30h Th | |
|  | | |
| Credits/ECTS : |
| |
|  | | |
| Holder(s) : | Eric Vyncke | |
|  | | |
|  | | |
| Course contents :
| Introduction to database 1. Concept of computer application 2. Evolution of IS 3. Architecture of a database 4. Definition and standardization SQL data manipulation language 1. Introduction to SQL 2. data creation language 3. data manipulation on language Dtabase complements 1. Application architecture 2. Problems linked with multiuses 3. Physical and logical security Databases 1. General popints and terminology 2. research tools 3. Off line support : CD-Rom 4. On line support and introduction to communication networks 5. Data publication on the web (including HTML, and PHP with SQL interface) | |
|  | | |
| Course objective :
| Understanding the concepts of management inf. system, database and their importance for management using an inquiry tool on databases | |
|  | | |
| Prerequisites :
| Fundamentals of computer science and computer literacy Ability to use the MS-Office tools Basic command of the C ( or Pascal ) programming language SI 614 Computer Science | |
|  | | |
| Organization :
| Theory course with reference to real-life cases Proctical exercises during the course : creation, modification and inquiry in SQL ; creation of a dynamic website with links to a datbase | |
|  | | |
| Written notes :
| Aucun support n'est prévu car la matière est trop dynamique. Une copie des transparents est disponible sur Internet http://www.hec.be/~evyncke/cours. | |
|  | | |
| Assessment :
| 1st session assessment = practical group assignment, marked; written examination on exercises (SQL and HTML); oral examination on the theory 2nd session assessment : idem (the practical assignement does not need to be done if already completed) prolonged 2nd session assessment : idem (the practical assignement does not need to be done if already completed) | |
|  | | |