 |  |
| INFO0076-1 | Computing in management engineering : partim II
 |
 |
| Duration : | 30h Th, 15h Pr |
 |
| Credits/ECTS : |
|
 |
| Holder(s) : | Daniel Dubois |
 |
| Language : | Langue française |
 |
| Course contents : | 1. Theoretical course:
Introduction to the Relational Databases of Codd. The relational algebra and the normal forms.
Introduction to the DataBases Management Systems, MySQL DBMS.
Introduction to the SQL language: DATA DEFINITION LANGUAGE (DDL), DATA MANIPULATION LANGUAGE (DML) and QUERIES.
Introduction to the PHP scripts language.
Design of a PHP-MySQL dynamic website.
Examples of applications in management and exercices.
2. E-learning:
Research on Internet : To be able to effectively carry out the stages of a research on Internet aiming an informational need.
3. Project in group:
The students will realize a project of dynamical websirte in PHP-MySQL, and will write a report on this work. |
 |
| Course objective : | 1. To design and realize a Relational DataBase with the relational algebra and the normal forms.
2. Carry out a complex informations research on Internet
3. To develop management applications with computer-based tools: MySQL DBMS, SQL queries and PHP scripts, Internet: dynamic web. |
 |
| Prerequisites : | Data processing in management engineering : partim I |
 |
| Workshops : | E-learning in applied computing.
Documentation retrieval on Internet. |
 |
| Organization : | The course is given to the second four-monthly period.
The theoretical course: 2h per week.
E-learning. |
 |
| Written notes : | Syllabi will be available on the virtual campus:
http://lola.hec.ulg.ac.be/claroline/course/index.php?cid=INFO0076_1 |
 |
| Assessment : | Written examination : on the theoretical course and the research on internet.
Oral examination: presentation of the PHP-MySQL Database project. |
 |
| Contacts : | Prof. Daniel Dubois, HEC-ULg, GSM: 04 95 510 419,
Daniel.Dubois@ulg.ac.be
Eddy Heins, Maître-Assistant, N1-bureau 201, Eddy.Heins@ulg.ac.be
Fabienne Fontaine, Maître-Assistante, N1-bureau 201, Fabienne.Fontaine@ulg.ac.be |
 |
| Remarks : | -- |
 |