2nd Bachelor in Management Computing
Data organization and exploitation
< Back
| ECTS Credits | 14 |
|---|---|
| Number of Hours (h/year) | 150 |
| Teaching staff | HERBIET, Laurence; THIRY, Christiane |
| Course Unit | Compulsory |
| Term | Quad. 1 and 2 |
| Code | ECO-INF00018/2 |
| Prerequisite | Mastership of structured programming Knowledge of organizations et access methods of a file system |
|---|---|
| Aims and Objectives | To know the functions of database management system. To understand the internal working of database management system and these links with the operating system. To master a relational language such like SQL. To get a good knowledge of relational model. To be able to define a database from a logical model To know and to understand the properties of transaction and the update conflicts. To master the data consistency problem. To be able to define access privileges. To be able to define and understand the utility of views. To handle embedded SQL, modular SQL, dynamic SQL and the exception mechanism In a second generation client/server approach, to be able to develop stored procedures, packages and triggers |
| Description | Definition of database and database management system notions and ANSI/X3/SPARC architecture « Database management system » versus « file system » Data/Programme independence Functions of a DBMS Working of a DBMS The relational model DDL – DML – DCL Integrity constraints Transaction and coherent state. Conflicts management Working safety: backup, before and after image journals, recovery. Data confidential aspect Cursor stability, double transaction and double connection Definition and practical interrogation of an SQL database, storage of procedures and triggers and development of applications (3GL) accessing it. |
| Bibliography | Delmal (P.), SQL2-SQL3, Applications à Oracle, De Boeck Université, 2000. |
| Teaching and Learning Methods | Lectures Tutorials Laboratory work Lectures and practical work |
| Assessment Methods | Written examinations Oral examinations Projects or practical work Continuous assessment |
| Notes | In part |
| Language | French |
The information contained herein is intended for informational purposes only. The Higher Education Institution disclaims any responsibility with regard to its content.