DataBases I

Information

Teacher coordinatorGéraldine Del Mondo
Teacher(s)Géraldine Del Mondo, Pierrick Tranouez, Laurent Vercouter
LanguageFrench
Credits2
TeachingLectures : 12h Exercises : 16h30
Web sitehttp://moodle.insa-rouen.fr/course/view.php?id=31

Aim and objective

Understand the main principles underlying modeling and manipulation of relational databases

Outcome learning

  • INSA reference data :
    • Maîtriser un langage d'interrogation de base de données [3P]
  • CNISF reference data :
    • J10A [3P]
    • J40B [3I]
    • J80Y [3P]
1 - Notion, 2 - Concept, 3 - Application, I - fully, P - incomplete

Course description

  • Introduction
  • Relational model
  • Database conception (normal forms)
  • Relational algebra
  • SQL
  • Grants/Integrity
  • Views
  • Basic principles of concurrence and storage

Prerequisites

Bibliography

Principles of database and knowledge-base systems / Jeffrey D. Ullman

Assessment

  • Final exam: 70%
  • Practical exam: 30%
  • Online self assessment: penalties apply if not done