Database and Web Applications Laboratory
Keywords |
Classification |
Keyword |
OFICIAL |
Information Systems |
Instance: 2010/2011 - 2S
Cycles of Study/Courses
Acronym |
No. of Students |
Study Plan |
Curricular Years |
Credits UCN |
Credits ECTS |
Contact hours |
Total Time |
MIEIC |
92 |
Syllabus since 2009/2010 |
3 |
- |
7 |
70 |
189 |
Teaching language
Portuguese
Objectives
In this course, the students will learn how to design and develop web-based information systems backed by database management systems.
After completing this course, the student will be able to:
1. Elicit the requirements of an information system
2. Identify the actors and their Use Cases
3. Prepare Use Case Diagrams using UML
4. Obtain the Domain Object Model
5. Obtain the Logical Relational Database Schema
6. Validate the relational schema based on functional dependencies
7. Obtain the database Physical Schema
8. Tuning the Logical Relational Schema
9. Explore the database using the Database Management System PostgreSQL
10. Write queries to the database using SQL
11. Implement integrity constraints and triggers
12. Define transactions
13. Define an architecture for handling errors in the data accesses
14. Set privileges of users and user groups
15. Use the scripting language PHP and libraries to build the user interface and business logic of the Web Application
16. Obtain the user interface in HTML
17. Set presentation styles using CSS
18. Validate integrity rules on data entry forms through the use of JavaScript
19. Use the JavaScript library jQuery to interact with the document and to make AJAX requests
20. Ensure that Web pages are obtained in accordance with the accessibility and usability standards
Program
1. Development of web application supported by a database: requirements gathering, design, modeling, implementation, testing and documentation.
2. General notions of architecture of web applications using client scripting languages (JavaScript) and server (PHP, Ruby, etc.). Models of representation of XML documents (DOM), use of Ajax framework and APIs for data access.
3. Design of relational databases using data modeling languages (UML), the SQL language and procedural extensions to SQL.
4. Identification and maintenance of business rules: on the interface (JavaScript), on the business logic and in the database (triggers); define transactions.
5. 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
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 PEAR-MDB2
PHP
PostgreSQL
Biblioteca Smarty
Biblioteca jQuery
Evaluation Type
Distributed evaluation without final exam
Assessment Components
Description |
Type |
Time (hours) |
Weight (%) |
End date |
Attendance (estimated) |
Participação presencial |
70,00 |
|
|
|
Trabalho laboratorial |
27,00 |
|
|
|
Trabalho laboratorial |
27,00 |
|
|
|
Trabalho laboratorial |
27,00 |
|
|
|
Trabalho laboratorial |
36,00 |
|
|
|
Participação presencial |
5,00 |
|
|
|
Participação presencial |
0,00 |
|
|
|
Total: |
- |
0,00 |
|
Eligibility for exams
Minimum required to pass this course: 40% in each practical assignment.
Calculation formula of final grade
Classification = 10% REI + 20% REBD + 20% RAP + 40% PA + 10% DI
Legend:
RER - Requirements Specification Report
REBD - Database Specification Report
RAP - Architecture Report and Vertical Prototype
PA - Product and Presentation
DI - Individual Performance
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 subject's next edition.