3rd Bachelor in Computing and Systems : Network and Telecommunications

Data base management system

< Back

ECTS Credits3
Number of Hours (h/year)30
Teaching staff
Course UnitCompulsory
TermQuad. 1
CodeTECH-INS00017/3
Prerequisite
  • Knowledge of relational model and SQL
  • Mastership of application development on a centralized database
Aims and Objectives
  • To get a good knowledge of client/server model
  • To be able to develop an application based on client/server model
  • In a second generation client/server approach, to be able to develop stored procedures, packages and triggers
  • To understand the multi-tier architecture concepts and the working of an application server
  • To be able to integrate a lot of analysis and programming techniques to develop an application with a Web interface on distributed databases in a heterogeneous environment
  • To know dynamic SQL
Description
  • Client/server model and et distant access to a database
  • Definition and practical interrogation of an SQL database, storage of procedures and triggers and development of applications (3GL) accessing it.
  • Exceptions management
  • Multi-tier architecture approach
  • Development of an Intranet application with dynamic pages generation on a database
  • Dynamic SQL
Bibliography
  • DELMAL (P.), SQL2 - SQL3 : applications à Oracle, De Boeck Université, 3rd edition, 2001.
  • Oracle 10gR2 documentation.
Teaching and Learning MethodsLectures
Project or fieldwork

practical work

Assessment MethodsOral examinations
NotesYes
LanguageFrench

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