Module : Databases
| Semestre 3, CP | VHS C/TD/TP |
VHH Total C/TD/TP |
V.H. Hebdomadaire | Coef | Crédits | ||
|---|---|---|---|---|---|---|---|
| C | TD | TP | |||||
| UE Methodologiques 3.1 | 67.5 | 4.5 | 1.5 | 1.5 | 1.5 | 3 | 5 |
Course Description :
The object of this course is to teach students the general concepts of relational databases and how to design a database that is anomaly free. Students will learn to design, create, populate, and query a database by working with a relational database engine and the SQL language. Students will also learn basic database administration skills such as creating users, granting/revoking privileges individually or collectively to several users through the use of roles. Further, students will learn how to create constraints with triggers in addition to the use of PL/SQL language.
Prerequisite : Programming, Data Structures
Evaluation Method : Coursework (40%) + Final Exam (60%)
Course Content
- Database Systems
- The Relational Database Model
- Entity Relationship (ER) Modelling
- Normalisation of Database Tables
- Introduction to Structured Query Language (SQL)
- Advanced SQL (LABS)
- Transaction Management and Concurrency Control
References
- Carlos Coronel and Steven Morris. Database Systems: Design, Implementation, & Management, 13th Edition, 2018.
- Raghu Ramakrishnan, Johannes Gehrke. Database Management Systems, McGraw-Hill Higher Education; 3rd edition. 2002
- Ramez Elmasri, Shamkant B. Navathe. Fundamentals of Database Systems, Pearson; 7th edition, 2015.