Cet espace sera supprimé le 31 janvier 2024 - Pour toutes questions, vous pouvez nous contacter sur la liste wikidocs-contact@univ-lorraine.fr

GIMAS7AG

Information Systemes and Databases

 

ECTS Credits: 2

Duration: 21 hours

Semester: S7

Person(s) in charge:

Wahiba RAMDANE CHERIF, Associate Professor, wahiba.ramdane-cherif@mines-nancy.univ-lorraine.fr

Kewords: Information systèmes, Databases, Entity – Relation Model, Relational Model, SQL.

Prerequisites: None

Objective:

Design and implementation of databases

Program and contents:

The purpose of this course is to introduce information systems and to delve deeper into their static aspect. The goal is to acquire the necessary skills for modeling information and learning the methods and tools to implement database applications, from their design to their definition and all the way to their interogation.. Two models will be studied: the relational model and the entity association model.

 

Content

  • General Concepts: system information, Databases
  • Entity – Relation Model (the data conceptual model)
  • Relational Model  (the data logical model)
  • Relational algebra
  • SQL Language

Assessment methods

Design and implementation of databases using Access

 

Abilities: 

Levels

Description and operational verbs

Know 

 

Understand 

 

Apply 

 

Analyze 

 

Summarise

 

Asses

 

Evaluation:

  • Written test
  • Continuous Control
  • Oral report
  • Project
  • Written report
  • Aucune étiquette