2nd Bachelor in Computing and Systems : Network and Telecommunications
Database‘s Structure
< Back
| ECTS Credits | 5,5 |
|---|---|
| Number of Hours (h/year) | 60 |
| Teaching staff | HERBIET, Laurence KUTY, Ludovic THIRY, Christiane |
| Course Unit | Compulsory |
| Term | Quad. 1 and 2 |
| Code | TECH-INS00017/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 handle embedded SQL, modular SQL, stored procedures and the exception mechanism |
| Description | Definition of database and database management system notions « 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 Definition and practical interrogation of an SQL database and development of an application (3GL) accessing it. |
| Bibliography | Delmal (P.), SQL2-SQL3, Applications à Oracle, De Boeck Université, 2000. Loney (K.) Et Koch (G.), Oracle8i La Référence, CampusPress, 2001. |
| Teaching and Learning Methods | Lectures Laboratory work Lectures and practical work |
| Assessment Methods | Written examinations Oral examinations Projects or practical work Continuous assessment |
| Notes | Yes |
| Language | French |
The information contained herein is intended for informational purposes only. The Higher Education Institution disclaims any responsibility with regard to its content.