This project is a direct exploitation of principles viewed in the PRINCIPLES OF DATA BASES MANAGEMENT SYSTEMS course.

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.

Java programing language, Principle of Database Management Systems course.

• 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

Final report and presentation/demo.

N1=Note projet
N2=N1