logo Insalogo Insa

OS, C Language, Computer networks, data bases

Presentation

Programme (detailed contents):

 

Operating systems :

The operating system is considered as resources managers: processors management (processes, scheduling) memory management (virtual memory, allocation), access to resources (synchronisation, mutual exclusion) and file system.

 

C Language :

Usual notions of programming languages (such as variables, types, control flow instructions) are presented as well as notions more specifically associated with the C language (generalized use of pointers, function parameters, input/outputs functions, etc.).

 

Computer Networks :

The first part of the course introduces features and requirements of the main network applications. The second part details fundamental concepts associated with the design of a network: connectivity, bandwidth sharing, switching, QoS and architecture. The third part presents the local area networks architecture with a study on the Ethernet network. Illustrations of those concepts are provided through directed and practical labs.

 

Bases de données :

 

The aim is to introduce the basic concepts of designing relational databases in UML.  From the UML data model, the process of derivation and validation of the relational model will be briefly introduced. Finally, the focus will be on relational algebra and SQL to manipulate and request databases.

 

Organisation:

Système d'exploitation :

11,25h lecture followed by 3,75h sessions of exercises.

Langage C :

lect : 10h, sem: 6,25h, Labs : 11h

Réseaux Informatiques :

18,75h lect. Then 3,75h directed labs then 2,75h practical lab.

Bases de données :

Lectures accompanied of course material will be given to students. Directed labs during which the students will practice the different seen concepts. The latest directed labs are devoted to the introduction and study of a concrete project. Finally, in practical labs, students will realize their project. At the end of these labs, students will provide a report.

Objectives

At the end of this module, the student will have understood and be able to explain (main concepts):

 

Operating Systems :

At the end of this module, the student will have understood and be able to explain the operating system problems with a global overview of its functions and architecture.

 

C Language :

This course aims at presenting to students the fundamental notions of the C programming language so that they can be autonomous with this  language.

 

Computer Networks :

At the end of this module, the student will have to know and to be able to explain the main concepts associated to computer networks: LAN, WAN and Internet (TCP/IP).

 

Database :

 

-       The different data models, their advantages and limits

-       What is DBMS (Database management system)

-       UML based data model

-       The different concepts of the relational model

-       The normalization and its importance

-       Data integrity constraints

-       Relational algebra and SQL languages

 

The student will be able to:

 

Operating Systems :

The student will be able to identify the different parts of the operating system and know how they work.

 

C Language :

The student will be able to elaborate simple program illustrating algorithmic problems, but also more complex programs requiring a good knowledge of specific notions (pointer, etc.).

 

Computer Networks :

The students will be able to identify: the features of the main distributed applications, the different kinds of connectivity and addressing scheme, the solutions of resource sharing and their consequences on the transfer quality, and finally the notions of service, protocol, architecture and quality of service. The services and the functionalities of the protocols and the architecture of the Ethernet LAN and of the Internet will have to be known on the theoretical point of view.

 

Database :

 

-       Understand an UML based database model

-       Understand the relational model derived from UML model and vice versa

-       Write requests based on relational algebra and implement them in SQL for database interrogation and manipulation

Needed prerequisite

Operating Systems :

- Notions in computer’s structure.

C language :

- Notions in assembling language and in another programming language are welcome.

Computer Networks :

- Notions in operating systems and in programming.

Form of assessment

The evaluation of outcome prior learning is made as a continuous training during the semester. According ot the teaching, the assessment will be different: as a written exam, an oral exam, a record, a written report, peers review...