Menu

DATABASES

Code Cours
2122-Icam-I1S2-IN-1 BD
  1. Home
  2. ECTS Courses
  3. DATABASES
Teaching content
Computer science
Training officer(s)
JL.LARBOT
Level
Diplôme d'ingénieur
Program year
1
Period
S2

Présentation

Prerequisite
Knowledge in algorithms and programming.
Goal
- Students are to know how to proceed to the modelling of a relational database
- Moreover they are also to know how to set up a database structure,
- And to know the basic command lines of the SQL language
Presentation
- Goals of a database
- Presentation of the various models of RDBMS
- Normalization
- SQL language
- Security of databases

Modalités

Forms of instruction
Theoretical course with additional practical solutions (scheme of practical use and implantation in a company, equipment used, etc.)
Organization
Type Amount of time Comment
Face to face
Lecture 8,00
Lab 12,00
Independent study
Estimated personal study time 7,00
Overall student workload 27,00
Evaluation
- Assessment of practical work will be based on the quality of the database and inquiries developed by the student
- Written test for which students will be required to proceed to the modelling of a given situation

Ressources

Bibliography
Gestion et administration des bases de données - N. Boudjlida

Paris : Dunod

Introduction aux bases de données - C. Date

Paris : Vuibert, 2004

SQL - F. Brouard

Paris : Campuspress, 2001