Applied Information Systems

Basic Programming Skills. For example in C or another language.

• Lectures with projection of theoretical slides on different subjects;
• Laboratorial classroom lessons with resolution of different exercises/real problems. Mandatory attendance of
75%;
• Laboratory work in group (40% of the evaluation) – validation by individual oral evaluation, with the presence of
teachers assigned to the course;
• Final written exam (60% of the evaluation, minimum of 30%).

To understand the role of Database Management Systems (DBMS) in Information Systems (IS) applied to Electrical
Engineering problems;
To understand the need for modelling in a relational database design;
To understand the concepts of relational databases: relational model, integrity, normalization, relational operations;
To model, design and implement a relational database;
To manipulate and extract data in relational databases using SQL language;
Developing and designing application interfaces in PHP using database management systems;
To understand and know the PHP language;

To understand Web programming philosophies: program running on the server and program running in the client
browser;
To learn the basic commands of Javascript and HTML.

1. Introduction to databases
2. Database management systems
3. Relational model
4. Modelling databases
5. Data manipulation, integrity and security
6. Database conception
7. The SQL language
8. Interaction language – HTML / PHP
9. Applications in PHP using the SQL language.

NAO