Number of hours
- Tutorials 18.0
ECTS
ECTS 1.5
Goal(s)
This project is a direct exploitation of principles viewed in the PRINCIPLES OF DATA BASES MANAGEMENT SYSTEMS course.
Contact Christophe BOBINEAU
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.
Prerequisites
Java programing language, Principle of Database Management Systems course.
Test
Final report and presentation/demo.
N1=Note projet
N2=N1
Additional Information
Curriculum->MMIS.->Semester 3
Curriculum->ENGINEERING systm of information->Semester 3
Curriculum->For Financial Engineering->Semester 3
Curriculum->CORE->Semester 3
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