DBMS project

School / Prep
ENSEIRB-MATMECA

Internal code

EI7IT204

Description

The practical sessions take place on the Oracle system. These sessions enable students to better understand the course and the Tds, and to test SQL queries. At the end of the practical sessions, a project allows students to simulate a database application, from design to implementation.
Plan

Presentation of ORACLE
Presentation of MySQL
Architecture
SQL, SQLPLUS
SQL-host language interface
PL/SQL
Oracle project

Competencies
C2. Level 2C3. Level 2C4. Level 2C7. Level 2C8. Level 2C12. Level 2

TDTutorial20h
TIIndividual work30h

Mandatory prerequisites

Algorithms I1A, I2A

Syllabus

- ORACLE overview
- MySQL overview
- Architecture
- SQL, SQLPLUS
- SQL-host language interface
- PL/SQL
- Oracle project

Bibliography

Oracle documentation available, copy of slides.

Initial assessment / Main session

Type of assessment	Nature of assessment	Duration (in minutes)	Number of tests	Evaluation coefficient	Eliminatory evaluation mark	Remarks
Project	Report			1