Web Applications & Data Bases - 4MMAWM

Number of hours
- Lectures 9.0
- Projects 7.5
- Tutorials -
- Internship -
- Laboratory works 9.0
- Written tests -
ECTS
ECTS 3.0

Goal(s)

This course covers the design and implementation of static and dynamic websites by giving a survey of existing web technologies such as AJAX, PHP and JSP. It also addresses interactions with databases in a 3-tier architecture and some concepts related to security of web applications. The development process presented in this course is based on the coherence between the conceptual bases of a website and its architecture.

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

Responsible(s)

Patrick REIGNIER

Content(s)

1) Basic concepts of web applications
2) Development of dynamic web pages
3) Illustrations based on PHP
4) Overview of object oriented web technologies: JSP, JavaBeans, Servlets
5) Session management and websites security
6) Deployment of the MVC model for web applications

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

Databases
Object oriented modeling
Elementary concepts of networks

Java programing language, Principle of Database Management Systems course.

Test

One programming work with report (P)

Final report and presentation/demo.

N1 = P
N2=N1

Calendar

The course exists in the following branches: