1st Master in Industrial sciences (2nd cycle-Industrial Engineers) Computer Science
Database’s Structure
< Back
| ECTS Credits | 7 |
|---|---|
| Number of Hours (h/year) | 90 |
| Teaching staff | HERBIET, Laurence KUTY, Ludovic |
| Course Unit | Compulsory |
| Term | Quad. 1 and 2 |
| Code | TECH-IINF0005/1 |
| Prerequisite | Mastership of Entity-Relationship and relational models Knowledge of SQL |
|---|---|
| Aims and Objectives | To master the fundamentals to normalize relational schema To know client/server model and to be able to develop an application based on it To handle the fundamentals of distributed databases To be able to develop a project in a multi-tier architecture with a WEB interface To understand the database administration principles |
| Description | The normal forms and the normalization algorithm. Functional dependence and multivalue dependence Definition and characteristics of client/server model Definition of distributed databases Distributed databases architecture: Fragments, distribution transparency level Different techniques of replicated information. Definition et characteristics of muti-tier architecture. The object-relational extensions
To administer and to optimize relational databases Programming in dynamic SQL To realize an application in a multi-tier architecture with a WEB interface and distributed data |
| Bibliography | DELMAL (P.), SQL2-SQL3, Applications à Oracle, De Boeck Université, 2000 KIMBALL (R.), Entrepôts de données, Guide pratique du concepteur de Data Warehouse, Paris, Wiley, 1997. |
| Teaching and Learning Methods | Lectures Laboratory work |
| Assessment Methods | 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.