| Course label : | Information System and Applications |
|---|---|
| Teaching departement : | MIN / Applied Mathematics and General Computing |
| Teaching manager : | Mister MAXIME FOLSCHETTE |
| Education language : | French |
| Potential ects : | 0 |
| Results grid : | |
| Code and label (hp) : | LE1_2_IF_MIN_SIA - Syst. d'info. et applications |
Education team
Teachers : Mister MAXIME FOLSCHETTE / Madam ISABELLE LE GLAZ / Mister HERVE CAMUS
External contributors (business, research, secondary education): various temporary teachers
Summary
This course is an introduction to information systems from the perspective of relational databases: what they are used for, and how to create and use them. Its content focuses on the relational model and SQL. The course is divided into lectures in tutorials, allowing students to immediately apply these concepts on paper, and practical sessions, allowing them to put them into practice on computers. By the end of the course, students should be able to read and create a simple relational model and, based on a relational model, write SQL queries according to a statement. It will serve as a basis for other subjects related to information systems or those that use them (web, modeling, etc.).
Educational goals
The objectives of this module are: - to understand what a database is, and more specifically a relational database, - to know how to use a relational database with the specific language of relational models: SQL (DQL, DDL, DML), - to understand to the design of an information system through the design of a relational model. Knowledge covered: - general concepts of information systems, - understanding the value of databases and DBMS, - concepts of relational database modeling (relational model, table, attribute, primary key, foreign key, etc.). Skills developed: - designing a complex SQL read query (DQL: SELECT with WHERE, GROUPY BY, ORDER BY…) from a statement, - designing an SQL query to create (DDL) or populate (DML) a table, - understanding a given simple relational model, - designing a simple relational model from a statement.
Sustainable development goals
Knowledge control procedures
Continuous Assessment / Fixed Exam
Comments: Continuous assessment:
- written tests in tutorials,
- final practical assessed on the basis of the report produced during the session,
- possibly: partial assessment of other practical reports.
Final assessment:
- final written exam, without calculators or documents.
Online resources
Course slideshows. Use of a MySQL/MariaDB database with phpMyAdmin interface + an online modeling/diagrams tool such as dbdiagram.io or diagrams.net.
Pedagogy
A lecture introduces the subject matter and key theoretical concepts. Students then learn SQL in tutorials: the lecture content is immediately followed by exercises on paper. Finally, students apply what they have learned in practical sessions on provided database instances, using a MySQL or MariaDB engine and a phpMyAdmin interface.
Sequencing / learning methods
| Number of hours - Lectures : | 2 |
|---|---|
| Number of hours - Tutorial : | 12 |
| Number of hours - Practical work : | 12 |
| Number of hours - Seminar : | 0 |
| Number of hours - Half-group seminar : | 0 |
| Number of student hours in TEA (Autonomous learning) : | 0 |
| Number of student hours in TNE (Non-supervised activities) : | 0 |
| Number of hours in CB (Fixed exams) : | 0 |
| Number of student hours in PER (Personal work) : | 0 |
| Number of hours - Projects : | 0 |
Prerequisites
Mathematical logic, concept of mathematical sets