Code |
13956
|
Year |
3
|
Semester |
S2
|
ECTS Credits |
6
|
Workload |
PL(30H)/T(30H)
|
Scientific area |
Informatics
|
Entry requirements |
NA
|
Learning outcomes |
Provide the knowledge and skills which are essential for modeling and creating the type of Databases most frequently used and for the development of web and stand-alone applications which interact with such Databases by means of a widely recognized language.
|
Syllabus |
1. Introduction to Database Systems
1.1. Context and motivation 1.2. Abstraction levels 1.3. Fundamental features of Database Management Systems 1.4. Transactions
2. Relational Model
2.1. Relational Data Structure 2.2. Relational Algebra: Set Theory, Operators, Diagrams. 2.3. Functional Dependencies, Candidate Keys, Super-keys, and Primary Key
3. Conceptual Model
3.1. The Entity / Relationship Model 3.2. Database Normalization Theory
4. The SQL Language 4.1. Instructions for data manipulation (DML) 4.2. Instructions for data structure definition (DDL) 4.3. Creating and manipulating Views 4.4. Creating and manipulating Indexes 4.5. Query Optimization
|
Main Bibliography |
C. J. Date. An Introduction to Database Systems. Addison-Wesley (ISBN: 0321189566)
J. Hoffer, M. Prescott, F. McFadden. Modern Database Management. Prentice Hall (ISBN: 0130339695).
J. A. Carriço. Desenho de Bases de Dados. CTI (ISBN: 9729653321).
José Luís Pereira , Tecnologia de Bases de Dados, FCA; ISBN: 9727220738.
Luís Damas, SQL – Structured Query Language, FCA; ISBN 9727221881.
|
Language |
Portuguese. Tutorial support is available in English.
|