• FR
  • EN

Information systems

Code: S1934, ECTS: 3

Syllabus

The aim of this course is to pass on know-how that is useful to any engineer:

  • designing structured and coherent information systems;
  • executing them in a practical fashion and exploiting them to advantage.

Requisit

knowledge of data structures, such as those acquired through basic comprehension of the first-year course on algorithms, would be useful. Even if the course contains very little programming, a reasonable interest in computer science is indispensable.

Programme

  • introduction to databases: motivations, 3-tier server-customer architectures, transactions, data models, commercial and free markets for database software (Oracle, Sybase, DB2, Acces, SQL Server, Postgres, MySQL, etc.), integration within the web context, presentation of I.S. careers;
  • modelling of data with the Entité-Association model: entities, attributes, associations, keys;
  • the relational model: definitions, normal forms, integrity constraints, redundancy, etc., and its mathematical bases, relational algebra: relational and assembly operators. Creation, interrogation and manipulation of data with the SQL language (relational layout, selection, insertion, updating, junction, involvement);
  • safety, security and performance: views, indexing, administration, duplication, request optimization. Interfacing with a programming language: example of JDBC for Java. XML format exchanges of data;
  • illustrations and applications with case studies: Geographical Information Systems, financial decision-making systems, identification systems (fingerprint bases), scaling of complex information systems;
  • the course comprises at least 50% practical work. Visits and/or lectures may take place.

Teaching team

Lecturer(s)
Fabien COELHO

Teaching staff
Nelson LOSSING

Contributor(s)
Pierre GUILLOU ; Claire MEDRALA
Code S1934
Year 2nd year
Level Graduate 1st year
ECTS Credits 3
Coefficient 3
Nb. of hours 37
Nb. of lessons 30
Course type Specialized courses
Semester 4
Period Spring
Domains
  • Informatique
Last update:
20 Jun 2017 11:20 by julien