Code: | EIC0023 | Acronym: | BDAD |
Keywords | |
---|---|
Classification | Keyword |
OFICIAL | Information Systems |
Active? | Yes |
Responsible unit: | Department of Informatics Engineering |
Course/CS Responsible: | Master in Informatics and Computing Engineering |
Acronym | No. of Students | Study Plan | Curricular Years | Credits UCN | Credits ECTS | Contact hours | Total Time |
---|---|---|---|---|---|---|---|
MIEIC | 174 | Syllabus since 2009/2010 | 2 | - | 6 | 56 | 162 |
BACKGROUND
Information Systems (IS) is a key topic in informatics engineering. Databases are data repositories required in any IS. The database course is a key course in the area of IS. The main objective of this course unit is to prepare students to design and develop database systems that meet the users' needs according to the organizational management goals.
SPECIFIC AIMS
This is an introductory course on databases. It is focused on the relational paradigm. It covers the design (UML model), construction (SQL data definition language), querying (SQL data manipulation language) and management (optimization, access control and concurrency policies). It also introduces the concept of multidimensional databases, NoSQL databases and semistructured data models.
PERCENT DISTRIBUTION
Scientific component: 50%
Technological component:50%
LEARNING OUTCOMES
Upon completion of this unit students should be able to:
- Define a high-level database model for a particular context;
- Map a high-level database model to a relation schema;
- Identify the functional dependencies of a relation;
- Diferentiate normal forms in relation schemas;
- Decompose relation schemas to the Boyce-Codd normal form and the third normal form;
- Create a relacional databse in SQL;
- Use relational algebra to query databases;
- Query relational databases in SQL;
- Use transactions and concurrency to ensure the data integrity of a database;
- Explain the main features of a database management system;
- Identify the differences between a relational database, a multidimensional database and a NoSQL database and be able to identify the most adequate for a particular situation.
PRE REQUISITES
Basic knowledge on algebra.
UML class diagram. The Entity-Relationship model. Relational schema, normalization and mapping from a high-level database model. SQL Data Definition Language and integrity constraints. Relational algebra as a query language. SQL Data Manipulation Language. Views. Indexes.Transactions, concurrency and recovery. Authorization. Recursion in SQL. Introduction to data warehousing and OLAP. Introduction to semistructured data models. Introduction to NoSQL systems.
Lectures are used to present the subject topics along with application examples. Practical classes take place in a computer lab, using a database management system available in the market (MySQL). In the labs, practical exercises will be performed using an example database, and small developments will be carried out.
Designation | Weight (%) |
---|---|
Exame | 70,00 |
Trabalho escrito | 7,50 |
Trabalho laboratorial | 22,50 |
Total: | 100,00 |
Designation | Time (hours) |
---|---|
Estudo autónomo | 60,00 |
Frequência das aulas | 52,00 |
Trabalho laboratorial | 50,00 |
Total: | 162,00 |
To be eligible for the final exam, students cannot exceed the maximum number of absences in the laboratorial classes. Presence in class will be registered. It is necessary to obtain a minimum of 10 marks (in 20) in the distributed evaluation to be admitted to the final exam. The distributed evaluation is assessed through a group work
DE - Distributed Evaluation (minimum grade: 10 out of 20)
FE - Final Exam (miminum grade; 8 out of 20)
Final mark = round( 0,7*EF + 0,3*DE)
The distributed evaluation is assessed through a group work. This work will be evaluated in three different times: each of the first two deliveries worth 25% of the evaluation. The last delivery is worth 50% of the overall distributed evaluation.
Students in special circumstances who undergo some component of the distributed evaluation component in the edition in progress will be evaluated through the general evaluation rules as set out in 'Obtaining Frequency' being the final classification obtained under the rubric 'Formula de cálculo da classificação final'.
If not subjected to any component of the distributed evaluation they will be assessed by examination. In these cases, the final rating will be 100% of the mark obtained in the examination.
Students belonging to student committees are subject to the general evaluation rules.
It is possible to improve the final exam mark through a second exam of similar difficulty. The final ranking is obtained by weighted average between the exam and the distributed evaluation, being the weights of 70% and 30% respectively.
The classification of the lab assignment can be improved in the following year.