|Responsible unit:||Department of Informatics Engineering|
|Course/CS Responsible:||Master in Bioengineering|
|Acronym||No. of Students||Study Plan||Curricular Years||Credits UCN||Credits ECTS||Contact hours||Total Time|
|António Miguel Pontes Pimenta Monteiro|
This course has as main objective to provide the knowledge and practice of the planning and design of an information system, specially its data component representation and organization. The understanding and efficient use of the data relational model and its implementation in a database management system belong also to the course objectives.
Another objective is the knowledge and practice of building adequate user interfaces capable of supporting the business processes underlying the information system. That interface should execute the flow of a business process through the normal search, update, create and eliminate data operations.
The students should be able to analyze and model business processes and its information needs and design and build an efficient relational database schema from it.
Another result should be the capacity to design and implement web interfaces in a simple server technology, and the database manipulation operations identified as needs in the business process model.
1. Information Systems Introduction
Data and information
What is an information system
Information systems components
Data, business logic, interface
Information systems architecture
Life cycle and development phases
2. Data, Databases and Database Management Systems
Information and data modeling
Entity / Relationship model
Representation using the Universal Modeling Language (UML)
The relational model of data
Relational algebra and set operations
The design of a database
3. The database language SQL (Structured Query Language)
The data definition language (DDL)
Defining and modifying database schemas and properties
The data manipulation language (DML)
Selections and simple queries
Queries and operations involving more than one relation
Data modification: insertions, deletions and updates
Transactions in SQL
4. Web interfaces
Business processes and use cases
The working of a Web application
Web interface needs and design
Creating forms, business logic and data manipulation using ASP.NET technology
5. Application Examples Practice
Analysis, design and implementation of databases
Business processes and logic and user interface needed in information systems
The first or second titles cover the first 3 chapters, while the last title covers essentially chapter 4.
– Theoretical concept exposition, with presentation of examples and demonstrations.
– Practical study of various types of business processes specially related to the medical field. This includes tha analysis, modeling, design and implementation of several real examples.
|Elaboração de projeto||14,00|
|Frequência das aulas||56,00|
Complete and present the Lab assignments.
A minimum grade of 6 (out of 20) in the written test.
0.5 * Assgn + 0.5 * Test
Assgn - Lab assignments grade
Test - Open book test examination grade
The same as for ordinary students. The assignments are mandatory and must be done and presented before the deadlines. Final is also mandatory.
The written test grade can be improved following the general rules.
The Lab assignments, due to their extension, can be improved in the next curricular unit ocorrence.