Applied Information Systems

Programming in C or C++

Theoretical component
    Presentation of theoretical concepts;
    Presentation and analysis of examples, encouraging discussion of solutions with students throughout the class;
    Development in an interactive environment, of practical cases on theoretical concepts.

Laboratory Component
    The understanding of the acquired knowledge is promoted through the analysis, discussion and realization of practical examples;
    Resolution of several proposed exercises for students to work individually, promoting interaction between students and student / teacher.

Understand the role of Database Management Systems (DBMS) in Information Systems;
Understand the need for modeling in the design of Databases;
Understand the basic concepts in relational databases: relational model, integrity, normalization, relational
operations;
Model, design and implement a relational database;
Manipulate and extract data in Relational Databases using SQL (Structured Query Language);
Develop and structure application interfaces with database management systems;
Understand flow control in backend programs;
Understand the different possibilities of accessing a database from a language and the concept of backend;
The different programming philosophies for the WEB: program to run on the server, and program to run on
the client’s browser. Learn Javascript and HTML commands.

Theoretical Component

1. Introduction to databases:
    a. The Database management systems;
    b. Relational model;
    c. Database modelling;
    d. Data manipulation, integrity and security;
    e. Database design;
    f. The SQL language and its applications;
2. View on application development methods for Desktop/Web information systems;
3. Interaction Language: HTML, CSS, JavaScript – a brief summary
    a. The creation of web forms and their submission;
    b. Presentation of results to the user;
4. Server language: PHP / Javascript
    a. The study of object-oriented PHP language;
    b. Interaction between front-end and back-end;
    c. Validation and receipt of form data; authentication;
    d. Summary of the most common PHP frameworks;
5. Connection paradigms between front-end and back-end;
6. Documentation of an information system through graphical language.
7. Project for applying the technologies taught to a specific problem in the field of electrical engineering.

Practical Component

1: Practical example in Excel of how to manage information – recording data from membership fees of a community in Excel tables;
2: Install the tools necessary for the Curricular Unit on the students’ equipment. Use of specific embedded systems in the electrical engineering area;
3: Interaction with the database manager – managing the relational model;
4: Use of database modeling tool;
5: Modeling – exercises. Use of SQL Language;
6: Basics of HTML: designing web forms;
7: PHP – flow control, functions, form data reception methods, authentication;
8: PHP – use of external classes and libraries;
9: PHP – database access (read/delete/change/search). Testing the developed code;
10: PHP – connection paradigms between front-end and back-end;
11: Support to the development of practical work

Academic Regulation of the 2nd IPC Study Cycle - Dispatch No. 9858/2022, point c) of Article 32. (www.ipc.pt)
Type of evaluation: Periodic assessment.

Academic Regulation of the 2nd IPC Study Cycle - Dispatch No. 9858/2022, point 2) of Article 33. (www.ipc.pt)
Details:

• Written exam quoted at 8 points. Minimum 40% in the written exam;
• Practical work for 7 values – statement available in the first/second week of classes;
  - Design of a database: to be delivered in the 9th week (3 points). - Programming part: practical application of programming in PHP (2.5 points). - Research Article on the most recent state of knowledge (state of the art) in terms of technology used in the work (1.5 points), to be prepared following the work. It must be presented in article format. – see tab "Activities to promote the connection of the student to research development activities, technology transfer and knowledge and innovation";
• Work developed in classes, quoted for 5 values, with a minimum of 40%, will be assessed by Kahoot, multiple-choice tests and delivery of PHP programs. Students will be invited to participate in 3 Kahoot, 3 multiple-choice tests and 4 program submissions, spaced throughout the semester. A Kahoot (1.5 points), a multiple choice test (1.5 points) and a program submission (2 points) are considered for evaluation. After each evaluation element, the quote obtained will be quickly given and the correction will be provided. This assessment element aims to promote class attendance.
• Delivery of practical work –  1st part in the 9th week of classes, and 2nd part in the practical class of the last week of the semester;
• The practical work can be carried out by a maximum of two students or individually, with a presential defense of the work in the last week of the semester. The non-defense in person gives rise to the quotation of zero in this component;
• Delivery of the research work (to be prepared by the same authors as the practical work) – in the 8th or 9th week of classes during the semester;
• Students can only be assessed in an exam if they have attended 75% of the laboratory classes, except for students who are in the cases provided for in the law and in the Institution's regulations. In the latter case, students must, in the first/second laboratory class, express this status (via email), with additional work to be carried out on a date to be agreed upon. These can be audited/defended in the last week of classes or on a date to be agreed.

NAO