Go to:
Logótipo
You are here: Start > EIC0085

Database and Web Applications Laboratory

Code: EIC0085     Acronym: LBAW

Keywords
Classification Keyword
OFICIAL Information Systems

Instance: 2012/2013 - 2S

Active? Yes
Web Page: http://web.fe.up.pt/~jlopes/doku.php/teach/lbaw/index
Responsible unit: Department of Informatics Engineering
Course/CS Responsible: Master in Informatics and Computing Engineering

Cycles of Study/Courses

Acronym No. of Students Study Plan Curricular Years Credits UCN Credits ECTS Contact hours Total Time
MIEIC 102 Syllabus since 2009/2010 3 - 7 70 189

Teaching - Hours

Lectures: 2,00
Practical: 3,00
Type Teacher Classes Hour
Lectures Totals 1 2,00
João António Correia Lopes 1,00
Sérgio Sobral Nunes 1,00
Practical Totals 6 18,00
João António Correia Lopes 6,00
Sérgio Sobral Nunes 6,00
André Monteiro de Oliveira Restivo 3,00
Carla Alexandra Teixeira Lopes 3,00
Mais informaçõesLast updated on 2013-02-05.

Fields changed: Improvement of final grade, Métodos de ensino e atividades de aprendizagem, Fórmula de cálculo da classificação final, Provas e trabalhos especiais, Avaliação especial, Bibliografia Complementar, Programa, URL da página, Lingua de trabalho, Componentes de Avaliação e Ocupação, Objetivos

Teaching language

Suitable for English-speaking students

Objectives

The unit aims at revisit the learning outcome of databases and web languages and technologies, providing a practical perspective on this core areas of computer engineering.

 

In this course, the students will learn how to design and develop web-based information systems backed by database management systems.

Learning outcomes and competences

After completing this course, the student will be able to:

  1. Specify the requirements of the web-based information system;
  2. Obtain the domain object model of information system;
  3. Obtain and validate the logical relational database schema of the system's database;
  4. Obtain the physical schema of the database and tune the logical relational schema;
  5. Design and implement queries to access the database using SQL;
  6. Design and implement mechanisms for maintaining the integrity of the data;
  7. Specify the web interfaces and business logic of the information system;
  8. Implement the web components of the system using PHP, HTML, CSS and JavaScript;
  9. Ensure that the web interfaces are in accordance with accessibility and usability standards.

Working method

Presencial

Pre-requirements (prior knowledge) and co-requirements (common knowledge)

Databases: data modelling with UML, relational model, SQL language.

Web languages and technologies: HTTP protocol, HTML, CSS and JavaScript languages.

Program



  • Development of a Web application supported by a database: requirements gathering, design, modeling, implementation and documentation.

  • General notions of architecture of web applications using client scripting languages (JavaScript) and server (PHP), presentation of the Document Object Model (DOM), use of Ajax framework and APIs for data access.

  • Design of relational databases using data modeling languages (UML), the SQL language and procedural extensions to SQL.

  • Identification and maintenance of business rules: on the interface (JavaScript), on the business logic and in the database (triggers); define transactions.

  • General notions of usability and Web Design.


Mandatory literature

Ramakrishnan, Raghu; Database management systems. ISBN: 0-07-116898-2

Complementary Bibliography

Jeffrey D. Ullman, Jennifer Widom; A First course in database systems. ISBN: 978-0-13-600-637-4
Alberto Manuel Rodrigues da Silva e Carlos Alberto Escaleira Videira; UML, metodologias e ferramentas CASE. ISBN: 989-615-009-5
Russ Miles and Kim Hamilton; Learning UML 2.0. ISBN: 978-0-596-00982-3
Michal Zalewski; The tangled Web. ISBN: 978-1-59327-388-0
Nielsen, Jakob; Designing web usability. ISBN: 1-56205-810-X

Teaching methods and learning activities

The lectures will be used for presentation of the scripts of the work and representative examples and their discussion, analysis of assessments and brief introductions to the technologies they use.

 

The practical classes will be used for laboratory project development as a group project with the teacher as a consultant.

Software

Biblioteca jQuery
Biblioteca Smarty
PostgreSQL
PHP

keywords

Physical sciences > Computer science > Informatics

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Description Type Time (hours) Weight (%) End date
User Requirements Document (RER) Trabalho laboratorial 27,00 15,00 2013-03-11
Database Specification Report (REB) Trabalho laboratorial 27,00 20,00 2013-04-08
Architecture Document and Vertical Prototype (RAP) Trabalho laboratorial 27,00 15,00 2013-04-29
Product (P) Trabalho laboratorial 36,00 40,00 2013-06-03
Demonstration (A) Participação presencial 5,00 0,00 2013-06-03
Individual Performance (DI) Participação presencial 0,00 10,00
Total: - 100,00

Amount of time allocated to each course unit

Description Type Time (hours) End date
Attendance (estimated) Frequência das aulas 70
Total: 70,00

Eligibility for exams

Minimum required to pass this course: 40% in each practical assignment.

Calculation formula of final grade

Classification = 15% RER + 20% REB + 15% RAP + 40% PA + 10% DI

 

Legend:

RER - Requirements Specification Report

REB - Database Specification Report

RAP - Architecture Report and Vertical Prototype

PA - Product and Presentation

DI - Individual Performance

 

Marks of any component of assessment may vary from element to element in the same group.

 

Minimum required to pass this course: 40% in each practical assignment.

 

This course, given its laboratory nature is not eligible for evaluation in a single moment, so the pratical work evaluation cannot be replaced by taking an exam.

Examinations or Special Assignments

There are no special works or tests.

Special assessment (TE, DA, ...)

All students have the same evaluation.

Classification improvement

Students may improve the mark in the course's next edition.

Recommend this page Top
Copyright 1996-2022 © Faculdade de Engenharia da Universidade do Porto  I Terms and Conditions  I Accessibility  I Index A-Z  I Guest Book
Page generated on: 2022-08-18 at 17:12:01 | Reports Portal