Information Systems
Keywords |
Classification |
Keyword |
OFICIAL |
Informatics |
OFICIAL |
Automation, Control & Manufacturing Syst. |
Instance: 2011/2012 - 2S
Cycles of Study/Courses
Teaching language
Portuguese
Objectives
Aims:
- To know how to analyse, design, implement and document moderately complex information systems using relational database management systems;
- To know how to use SQL language in moderately complex situations;
- To be familiar and use visual programming, event-driven tools and implications associated to this type of programming;
- To know how to develop moderately complex information systems using visual programming tools and relational database management systems.
Skills:
- To design and implement an information system using PGSQL;
- To be familiar and use SQL when carrying out a moderately complex research;
- To design and implement moderately complex programs using FPC/Lazarus and PGSQL.
Program
Program
- Entity-relationship model: specification tool of information systems;
- Relational model: Change of entity-relationship model to relational model; Integrity rules
- SQL language: creation, manipulation, queries and relational databases;
- Use of PostgreSQL;
- Introduction to operating systems services;
- Visual and even-driven programming;
- Use of FPC/Lazarus;
- Design and implementation of moderately complex information system.
Mandatory literature
Raghu Ramakrishnan;
Database Management Systems. ISBN: 0-07-115508-2
Andrew S. Tanenbaum;
Modern operating systems. ISBN: 0-13-031358-0
Complementary Bibliography
Ullman, Jeffrey D;
A First Course in Database Systems. ISBN: 0-13-8687647-9
Abraham Silberschatz, Henry F. Korth, S. Sudarshan;
Database system concepts. ISBN: 0-07-228363-7
Teaching methods and learning activities
-Theoretical-classes: presentation of the themes of the course unit along with presentation and discussion of practical examples.
- Practical classes: resolution of practical exercises and supervision of a practical assignment.
keywords
Physical sciences > Computer science > Database management
Physical sciences > Computer science > Programming
Evaluation Type
Distributed evaluation with final exam
Assessment Components
Description |
Type |
Time (hours) |
Weight (%) |
End date |
Attendance (estimated) |
Participação presencial |
48,00 |
|
|
Exam |
Exame |
30,00 |
|
2012-07-09 |
Project |
Trabalho escrito |
30,00 |
|
2012-06-01 |
SQL Exam |
Exame |
30,00 |
|
2012-04-18 |
|
Total: |
- |
0,00 |
|
Amount of time allocated to each course unit
Description |
Type |
Time (hours) |
End date |
Study time during the semester |
Estudo autónomo |
30 |
|
|
Total: |
30,00 |
|
Eligibility for exams
- Attendance to practical classes;
- Minimum grade of 35% in each of the assessment components
Calculation formula of final grade
- Professor’s opinion regarding students’ attitude and performance in practical classes: 2 values
- Practical test: 4 values
- Assignment: 6 values
- Final Exam: 8 values
Comment 1: Students have to reach a minimum grade of 35% in each of the assessment components.
Comment 2: If students miss the practical assignment (the absence has to be justified) the assignment is worth 8 values and the final exam 10 values.
Examinations or Special Assignments
- Practical tests using SQL/PGSQL: laboratory exam at the computer;
- Assignment: implementation of an information systems using Lazarus and databases; the theme is chosen by the students and approved by the professor; group assignment (3 students preferentially).
Special assessment (TE, DA, ...)
Students do not need to attend practical classes and do the practical test.
Assignment: 9 values
Final Exam: 11 values
Classification improvement
Individual improvement of the group assignment
Observations
- Automatic correction may be partially or totally used during the assessment of the practical test.
- The assessment of the assignment will be based on problem modelling and on the implementation of a Lazarus visual application using a database.