Course unit

Database Applications

Last updated: 26/09/2022

Edit

Course Director(s):

YUGMA Claude

General Description:

The course focuses on the implementation of a JEE model with access to databases.

Key words:

ODBC interface Java applet

Number of teaching hours

18

Fields of study

Teaching language

French

Intended learning outcomes

On completion of the unit, the student will be capable of: Classification level Priority
Applying all subjects covered in data design 2. Understand Essential

Learning assessment methods

Percentage ratio of individual assessment Percentage ratio of group assessment
Written exam: 0 % Project submission: 100 %
Individual oral exam: 0 % Group presentation: %
Individual presentation: 0 % Group practical exercise: %
Individual practical exercise: 0 % Group report: %
Individual report: 0 %
Other(s): %

Programme and content

Type of teaching activity Content, sequencing and organisation
Course/ Practical course

Access to a data base through a servlet and the API JDBC

- implementation of different types of EJB, controlling persistance in Entity Beans DB, mapping with a DB

- presentation and utilisation of EJB-QL, definition of designated requests

- managing associations between entities linked to foreign keys of the relational scheme

- presentation of the transactional model proposed by the EJB

-managing exceptions generated by DB access or applications

Students work on a supervised exercise throughout the different sessions and gradually cover the elements presented in theoretical form. They then apply it to their data base designed in the data design course and present at the end an extract of the application.