logo Insalogo Insa

Database 1 and Web programming

Presentation

Programme (detailed contents):

 

Database 1:

 

The aim is to introduce the basic concepts of designing relational databases in UML.  From the UML data model, the process of derivation and validation of the relational model will be studied. The normalization process will be investigated.

 

Web programming

 

The languages HTML5, CSS, and  JavaScript will be studied.

 

Organisation:

Database 1:

10h of courses, followed by 10h of directed labs.

 

Web programming

3,75h of courses, followed by 8,75h of directed labs, followed by 8,25h of pratical labs

 

Lectures accompanied of course material will be given to students. Directed labs during which the students will practice the different seen concepts. The latest directed labs are devoted to the introduction and study of a concrete project. Finally, in practical labs, students will realize their project. At the end of these labs, students will provide a report.

Objectives

At the end of this module, the student will have understood and be able to explain (main concepts):

 

Database 1:

-       The different data models, their advantages and limits

-       What is DBMS (Database management system)

-       UML based data model

-       The different concepts of the relational model

-       The normalization and its importance

-       Data integrity constraints

 

Web programming

 

  • Understand the concepts and technologies of the Web
  • HTML5 language
  • CSS language
  • JavaScript language

 

The student will be able to:

 

Database 1:

 

-       Design a relationnal database based on UML

-       Derive the relational model from UML model and vice versa

-       Normalize and validate a relational model

 

Web programming

-       Design a static Web site with HTML5

-       Define a CSS file

Write scripts with JavaScript

Form of assessment

The evaluation of outcome prior learning is made as a continuous training during the semester. According ot the teaching, the assessment will be different: as a written exam, an oral exam, a record, a written report, peers review...