1st Bachelor in Computing and Systems:
Database Management System
< Back
| ECTS Credits | 6,5 |
|---|---|
| Number of Hours (h/year) | 75 |
| Teaching staff | COSTA, Corinne; HERBIET, Laurence; LEONARD, Anne; SAGOT, Pierre; SERRHINI, Souad |
| Course Unit | Compulsory |
| Term | Quad. 1 and 2 |
| Code | TECH-INS00017/1 |
| Prerequisite | None |
|---|---|
| Aims and Objectives | Knowledge of file organizations and access methods Capacity to choose an appropriate method in real situation Knowledge of relational database system principles and entity relationship model Master the relational algebra principles Knowledge of SQL (DML only)
|
| Description | Definition of file, structure (record), field, fixed and variable record format View of the data: logical versus physical view File organization: physical sequential, physical linked sequential, full indexed, indexed sequential, ISAM, direct (hash coding) Introduction to relational databases Introduction to MySQL Project management and development plan, abstraction models of data systems The entity-relationship model The relational diagram Data Base integrities Relational algebra(basic and additional operations) Structured Query Language : - basic SELECT/FROM/WHERE - union - joins operations - order by - group by - subqueries - data modification statements
|
| Bibliography | P. Delmal SQL2 – SQL3 Jouffroy et Létang Les Fichiers |
| Teaching and Learning Methods | Lectures Tutorials practical works |
| Assessment Methods | Written examinations 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.