1st Bachelor in Management Computing

Data organisation and operation

< Back

ECTS Credits4
Number of Hours (h/year)60
Teaching staffCOSTA, Corinne
SERRHINI, Souad
Course UnitCompulsory
TermQuad. 1 and 2
CodeECO-INF00018/1
Prerequisite

None

Aims and Objectives

Implementing data organisation either in ordinary files by means of a programming language (for example C) or in database contexts by means of DBMS. Such types of software will make students familiar with SQL requests.

Description

1st part

Study of the main file organisations: index files, direct access files, index sequence file, tree-shape files.

Analysis of some files MySQL applications. Here, we use practical exercises in order to show how to implement the different file organisations and access methods by means of a third generation language.

How to organise a file

Organising a file implies taking a certain amount of parameters into account. In this chapter we examine the main parameters and show how each of them can influence the organisation: operation, activity, size, record structure…

2nd part: DBMS

Study of the characteristics of a DBMS application. Here we focus on the way to create tables and requests. Both lead to the study of SQL language. In the first year, this study is limited: students will learn how to write selection requests on/in one or several tables as well as action requests designed to maintain a table (adding, modifying and deleting data).

Define a DBMS.

The primary and foreign keys.

The integrities.

The relational algébre.

SQL:

Basic search(research): Selection, Projection Operators ensemblistes (Union, Intersection, difference).

Search(Research) with joints Operators in SQL.

Expressions in SQL (numerics, characters and dates).

Sortings Grouping of lines Imbricated requests Requests actions(shares) (Insertion, update, abolition(deletion)

Bibliography

SQL2-SQL3 3ème édition Pierre Delmal Edition : De Boeck Université

MySQL et PHP O'REILLY Philippe Rugaux.

Bases de données Concepts, utilisation et développement DUNOD Jean-Luc Hainaut

Internet : http://fr.wikipedia.org/wiki/Syst%C3%A8me_de_gestion_de_base_de_donn%C3%A9es

                http://sgbd.developpez.com/cours/

 

Teaching and Learning MethodsLectures
Tutorials
Laboratory work

Lecture with laboratory work

Assessment MethodsWritten and/or oral examination
Projects or practical work
Continuous assessment

end-of-term examination

Evaluation continues + realization of a complete project in laboratory.

NotesYes
LanguageFrench

The information contained herein is intended for informational purposes only. The Higher Education Institution disclaims any responsibility with regard to its content.