Applied Information Systems

Programming in C or C++

Theoretical component
Presentation of theoretical concepts; Use of flipped learning.
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.

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. Overview of 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 frontend and backend;
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.

Academic Regulations for the 2nd ISEC Study Cycle, Article 18,
https://www.isec.pt/PT/instituto/servicos/sgap/#servLegislacao
Assessment Model: M2

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

In accordance with Article 33 (2) of the aforementioned Regulation, the assessment consists of the following components:

• 8 points. Written examination; minimum of 40%;
• 5 points. In-class work or outside class time assessed through quizzes, mini-projects and the submission of exercises via an online platform; minimum of 40%;
• 5 points. Practical group assignment - brief available in the first/second week of classes; minimum of 0%;
  • Part 1: Database design (2.5 points).
  • Part 2: Programming: practical application of backend and frontend programming (2.5 points).
  • The practical assignment may be carried out by a maximum of two students or individually.
  • In-person presentation in the final week of the semester.
  • Students must upload the assignment to a platform provided by ISEC and ensure it remains live.
  • Failure to attend the in-person presentation or to deploy the work on the ISEC platform will result in a mark of zero for this component.
• 2 points. Literature review article on backend, frontend and database technologies. Minimum mark: 0%;
  • The assignment must be written and presented in article format. See the tab "Activities promoting student engagement in research development, technology and knowledge transfer, and innovation";

Deadlines:

• Practical group assignment
  
  • Part 1: to be submitted by the 8th week of term;
    
    • Submission after the deadline: results in a mark of 1.75 points.
  • Part 2: to be submitted by the final week of the semester;
    
    • Submission after the deadline: results in a mark of 1.75 points.
• Literature review article
  
  • To be submitted by the 9th week of the semester;

Conditions for sitting the exam:

Students who meet the conditions laid down in the regulations may sit the exam, namely:

• They must attend at least 75 per cent of laboratory classes, with the exception of students covered by the circumstances set out in the relevant legislation and the institution’s regulations:
  • Students covered by the aforementioned exceptions must notify the lecturer of this situation by email during the first or second laboratory session. In such cases, additional work may be set, to be submitted on a date to be agreed with the lecturer.
  • The additional work may be subject to assessment and/or an in-person presentation during the final week of classes or on a date agreed at a later stage.
• Have achieved a mark equal to or higher than the minimum mark required for the "In-class work or outside class time" component.

NAO