Code: | EIC0023 | Acronym: | BDAD |
Keywords | |
---|---|
Classification | Keyword |
OFICIAL | Information Systems |
Active? | Yes |
E-learning page: | https://moodle.fe.up.pt/ |
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 | 214 | Syllabus since 2009/2010 | 2 | - | 6 | 56 | 162 |
BACKGROUND
Information Systems (IS) is a key topic in informatics engineering. Databases are the data repository that is 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 PL/SQL) and management (optimization, access control and concurrency policies).
PERCENT DISTRIBUTION
Scientific component:50% Technological component:50%
LEARNING OUTCOMES
Upon completion of this unit students should be able to:
- map the UML class model into the relational model
- use relational algebra to query databases
- design a relational database in the normalized form
- query relational databases in SQL and using a procedural language
- access a database through user interfaces
- use transactions and concurrency that ensure data integrity of a database
- explain the main features of a database management system
PRE REQUISITES
Basic knowledge on procedimental programming languages and on algebra.
1. UML class diagram 2. The Entity-Relationship model 3. Relational model and normalization 4. SQL Data Definition Language and Integrity constraints 5. Relational Algebra 6. SQL Data Manipulation Language 7. View and indexes 8. Query optimization 9. SQL and the client-server architecture: the PL/SQL language 10. Access control 11. Transactions, concurrency and recovery 12. Data Warehousing
Theoretical 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 (Oracle, MySQL). During the classes practical exercises will be performed using an example database, and small developments will be carried out.
Description | Type | Time (hours) | Weight (%) | End date |
---|---|---|---|---|
Attendance (estimated) | Participação presencial | 68,00 | ||
Final exam | Exame | 3,00 | 70,00 | |
First component of the distributed evaluation | Trabalho escrito | 7,50 | 2013-04-05 | |
Second component of the distributed evaluation | Trabalho laboratorial | 7,50 | 2013-04-29 | |
Third component of the distributed evaluation | Trabalho laboratorial | 15,00 | 2013-06-03 | |
Total: | - | 100,00 |
Description | Type | Time (hours) | End date |
---|---|---|---|
Study along lectures period | Estudo autónomo | 40 | |
Execution of the working group (distributed evaluation) | Trabalho laboratorial | 32 | |
Study for final exam | Estudo autónomo | 20 | |
Total: | 92,00 |
To be eligible for the final exam, students cannot be absent in more than the allowed number of 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 will consist of 3 tests. Students who qualified for the final exam in the previous edition of the course unit, will keep the previous mark, except if they participate in any component of the distributed evaluation.
Final mark = 0,7*Exam + 0,3*Distributed evaluation, if Exam >= 8,0
Final mark = min{9; 0,7*Exam + 0,3*Distributed evaluation}, if Exam < 8,0
The distributed evaluation is obtained through the evaluation of 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 worth 50% of the distributed assessment.
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 classification obtained will contribute 100% for the final classification. The distributes evaluation is, consequently, ignored.