1st Bachelor in Management Computing
Data organisation and operation
< Back
ECTS Credits | 4 |
---|---|
Number of Hours (h/year) | 60 |
Teaching staff | COSTA, Corinne SERRHINI, Souad |
Course Unit | Compulsory |
Term | Quad. 1 and 2 |
Code | ECO-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 Methods | Lectures Tutorials Laboratory work Lecture with laboratory work |
Assessment Methods | Written and/or oral examination Projects or practical work Continuous assessment end-of-term examination Evaluation continues + realization of a complete project in laboratory. |
Notes | Yes |
Language | French |
The information contained herein is intended for informational purposes only. The Higher Education Institution disclaims any responsibility with regard to its content.