News
Our Degree Programs
Establishment
Language of instruction
French, English
Teaching content
CSI3-CIR3
Training officer(s)
D.DELANNOY
Stakeholder(s)
D.DELANNOY, P.RICQ, Jean-Philippe DELCROIX, Yves DUPRAT
Présentation
Prerequisite
--- Network part---
none
--- Database part ---
none
none
--- Database part ---
none
Goal
--- Network part---
- Local Area Network (LAN) concepts
- Ethernet and IP protocols
- Links between logical and physical addresses
- IP Addressing and routing with internet
- Name resolution with DNS
- Application protocols over UDP and TCP
--- Database part ---
- How to design a database model for a small information system,
- Read a model and convert it into tables
- Create a database with Postgress,
- Select datas from the database.
- Local Area Network (LAN) concepts
- Ethernet and IP protocols
- Links between logical and physical addresses
- IP Addressing and routing with internet
- Name resolution with DNS
- Application protocols over UDP and TCP
--- Database part ---
- How to design a database model for a small information system,
- Read a model and convert it into tables
- Create a database with Postgress,
- Select datas from the database.
Presentation
--- Network part ---
- OSI model
- Ethernet, IP, ARP protocols
- IP routing
- TCP/UDP transport protocols
- DNS, HTTP, SMTP, POP application protocols
--- Database part ---
Design data model :
- Role of the design,
- Relational concepts,
- MERISE method,
- Conceptual, Logical and Physical aspects.
Implementation :
- Relational databases,
- Database management system,
- Description Language (SQL),
- Query Language (SQL).
- OSI model
- Ethernet, IP, ARP protocols
- IP routing
- TCP/UDP transport protocols
- DNS, HTTP, SMTP, POP application protocols
--- Database part ---
Design data model :
- Role of the design,
- Relational concepts,
- MERISE method,
- Conceptual, Logical and Physical aspects.
Implementation :
- Relational databases,
- Database management system,
- Description Language (SQL),
- Query Language (SQL).
Modalités
Organization
| Type | Amount of time | Comment | |
|---|---|---|---|
| Face to face | |||
| Lectures - face to face | 3,50 | BDD | |
| Lab | 8,00 | BDD | |
| Lectures - face to face | 7,00 | Réseaux | |
| Exercises | 8,75 | Réseaux | |
| Exercises | 3,50 | BDD | |
| Independent study | |||
| Independent study | 30,00 | ||
| Overall student workload | 59,00 | ||
Evaluation
| Control type | Duration | Amount | Weighting |
|---|---|---|---|
| Continuous assessment | |||
| Written Test | 2,00 | 1 | 40,00 |
| Lab grade | 1,00 | 1 | 20,00 |
| Final Exam | |||
| Written test | 2,00 | 1 | 40,00 |
| TOTAL | 100,00 | ||