Number of hours
- Lectures -
- Projects -
- Tutorials 15.0
- Internship -
- Laboratory works -
- Written tests -
ECTS
ECTS 1.5
Goal(s)
This project is a direct exploitation of principles viewed in the PRINCIPLES OF DATA BASES MANAGEMENT SYSTEMS course.
Responsible(s)
Ugo COMIGNANI
Content(s)
In this project, students will have to build an application using a database. They will analyse the specific needs, build an Entity/Relationship schema, translate it into relational schema, implant this one in the Oracle DBMS. Functionalities of the application will also be analysed and translated into transactions and queries. Those ones will be tested on Oracle and then implemented in Java using the JDBC API.
PrerequisitesJava programing language, Principle of Database Management Systems course.
Test
Evaluation : Projet (évaluation en continu et sur le rendu) + soutenance
Final report and presentation/demo.
Calendar
The course exists in the following branches:
- Curriculum - Financial Engineering - Semester 7
- Curriculum - Information Systems Engineering - Semester 7
- Curriculum - Math. Modelling, Image & Simulation - Semester 7
Additional Information
Course ID : 4MMPBD
Course language(s): 
The course is attached to the following structures:
- Team Database, IS and knwoledge
You can find this course among all other courses.
Bibliography
- C. Delobel, M. Adiba, Bases de données et Systèmes Relationnels, Dunod informatique, 1982
- G. Gardarin, Objet et Relationnel , Eyrolles, 2003
- T. Connolly et C. Begg, Systèmes de Bases de Données, Editions Reynald Goulet, 2005
- J.-L. Hainaut, Bases de données : Concepts, utilisation et développement, Dunod, 2009
- S. Navathe, R. Elamasri, Fundamentals of database systems, second ed., Adison-Wesley Pub, 1994
- J. Ullman, J. Widom, A First Course in Database Systems, Prentice-Hall, 1997