This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
teach:lbaw:sheet [25/01/2019 19:37] Correia Lopes [Table] |
teach:lbaw:sheet [09/12/2019 10:28] Correia Lopes |
||
---|---|---|---|
Line 3: | Line 3: | ||
**Master in Informatics and Computing Engineering\\ | **Master in Informatics and Computing Engineering\\ | ||
Database and Web Applications Laboratory\\ | Database and Web Applications Laboratory\\ | ||
- | Instance: | + | Instance: 2019/2020** |
\\ | \\ | ||
--- | --- | ||
\\ | \\ | ||
- | // | + | // |
===== General information ===== | ===== General information ===== | ||
Line 15: | Line 15: | ||
**Code**: EIC0085\\ | **Code**: EIC0085\\ | ||
**Programmes**: | **Programmes**: | ||
- | **Academic Year**: | + | **Academic Year**: 2019/2020\\ |
**Semester**: | **Semester**: | ||
**Credits**: | **Credits**: | ||
Line 29: | Line 29: | ||
BACKGROUND | BACKGROUND | ||
- | The unit aims at revisit | + | This unit revisits |
SPECIFIC OBJECTIVES | SPECIFIC OBJECTIVES | ||
Line 46: | Line 46: | ||
- Specify the web interfaces and business logic of the information system; | - Specify the web interfaces and business logic of the information system; | ||
- Implement the web components of the system using web-based, server-based and client-based technologies; | - Implement the web components of the system using web-based, server-based and client-based technologies; | ||
- | - Ensure that the web interfaces | + | - Ensure that the web interfaces |
===== Working method ===== | ===== Working method ===== | ||
Line 59: | Line 59: | ||
===== Programme ===== | ===== Programme ===== | ||
- | * Development of a web application supported by a database: requirements gathering, design, modelling, implementation and documentation. | + | * Development of a web application supported by a database: requirements gathering, design, modelling, implementation and documentation; |
- | * General notions | + | * General notions |
- | * Use of frameworks and API for data access. | + | * Use of frameworks and API for data access; |
- | * Design of relational databases using data modelling languages (UML), the SQL language and procedural extensions to SQL. | + | * Design of relational databases using data modelling languages (UML), the SQL language and procedural extensions to SQL; |
- | * Identification and maintenance of business rules: on the interface, on the business logic and in the database (triggers); define transactions. | + | * Identification and maintenance of business rules: on the interface, on the business logic and in the database (triggers); define transactions; |
- | * General notions of usability and Web Design. | + | * General notions of web usability and accessibility. |
===== Mandatory literature ===== | ===== Mandatory literature ===== | ||
Line 79: | Line 79: | ||
===== Teaching methods and learning activities ===== | ===== Teaching methods and learning activities ===== | ||
- | The lectures will be used for presentation of the scripts of the work and representative examples | + | The lectures will be used for the presentation of work scripts, development |
The practical classes will be used for laboratory project development as a group project with the teacher as a consultant. | The practical classes will be used for laboratory project development as a group project with the teacher as a consultant. | ||
Line 85: | Line 85: | ||
* PostgreSQL | * PostgreSQL | ||
- | * PHP e Laravel | + | * PHP |
* Docker | * Docker | ||
* Git | * Git | ||
Line 97: | Line 97: | ||
Distributed evaluation without final exam | Distributed evaluation without final exam | ||
- | ===== Registered evaluation and occupation components | + | ===== Assessment Components |
- | ^ Description | + | ^ Designation |
- | | Attendance (estimated) | + | | Test | |
- | | User requirements specification | + | | Practical |
- | | Database specification | + | | Total: |
- | | Architecture specification and Vertical prototype | + | |
- | | Product | + | ===== Amount of time allocated to each course unit ===== |
- | | Demonstration | + | |
- | | Individual Questionnaire | + | ^ Designation |
- | | | + | | Autonomous study |
+ | | Class frequency | ||
+ | | Total: | | ||
===== Eligibility for exams ===== | ===== Eligibility for exams ===== | ||
Line 115: | Line 117: | ||
The theoretical concepts are evaluated using an individual questionnaire with multiple choice questions. | The theoretical concepts are evaluated using an individual questionnaire with multiple choice questions. | ||
- | The approval | + | The approval |
- | A student that does not participate in an evaluation component may have an assessment | + | A student that does not participate in an evaluation component may have an assessment |
- | Given the laboratory nature of the course | + | Given the laboratory nature of the course, it is not possible to make an overall evaluation based on a single moment and therefore the practical work can not be replaced by a single exam. |
===== Calculation formula of final grade ===== | ===== Calculation formula of final grade ===== | ||
Line 136: | Line 138: | ||
The final classification of the practical component (NP) can vary from element to element in the same group, plus or minus 2 values, | The final classification of the practical component (NP) can vary from element to element in the same group, plus or minus 2 values, | ||
+ | |||
+ | Students who do not get approved in the final classification have to repeat the two evaluation components (NI and NP) in a new enrolment to the unit. | ||
===== Examinations ===== | ===== Examinations ===== | ||
Line 145: | Line 149: | ||
The project evaluation, conducted in a group, is the same for all students regardless of the enrolment regime. | The project evaluation, conducted in a group, is the same for all students regardless of the enrolment regime. | ||
- | Students exempted from classes must agree to conduct regular meetings with teachers to keep up with the practical work. | + | Students exempted from classes must agree to conduct regular meetings with the teachers to keep up with the practical work. |
Regarding the final presentation and the individual assessments, | Regarding the final presentation and the individual assessments, | ||
Line 153: | Line 157: | ||
\\ | \\ | ||
- | --- //João Correia Lopes, Sérgio Nunes/ | + | --- //João Correia Lopes, Sérgio Nunes |