Databases
Keywords |
Classification |
Keyword |
OFICIAL |
Information Systems |
Instance: 2010/2011 - 2S
Cycles of Study/Courses
Acronym |
No. of Students |
Study Plan |
Curricular Years |
Credits UCN |
Credits ECTS |
Contact hours |
Total Time |
MIEIC |
146 |
Syllabus since 2009/2010 |
2 |
- |
6 |
56 |
162 |
Teaching language
Portuguese
Objectives
The main objective of this course unit is to prepare students to design and develop database systems that meet the users' needs the organizational management goals.
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
Program
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
Mandatory literature
Ullman, Jeffrey D;
A First Course in Database Systems. ISBN: 0-13-861337-0
Complementary Bibliography
Raghu Ramakrishnan, Johannes Gehrke;
Database management systems. ISBN: 0-07-116898-2
Ralph Kimball, Margy Ross;
The data warehouse toolkit. ISBN: 0-471-20024-7
Teaching methods and learning activities
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.
Software
Oracle SQL Developer
Oracle 11g
keywords
Physical sciences > Computer science > Database management
Evaluation Type
Distributed evaluation with final exam
Assessment Components
Description |
Type |
Time (hours) |
Weight (%) |
End date |
Attendance (estimated) |
Participação presencial |
54,00 |
|
|
Learning how to use the given database application |
Trabalho laboratorial |
16,00 |
|
|
Final exam |
Exame |
3,00 |
|
|
|
Total: |
- |
0,00 |
|
Amount of time allocated to each course unit
Description |
Type |
Time (hours) |
End date |
Study along lectures period |
Estudo autónomo |
57 |
|
Study for the final exam |
Estudo autónomo |
32 |
|
|
Total: |
89,00 |
|
Eligibility for exams
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 7 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.
Calculation formula of final grade
Final mark = 0,7*Exam + 0,3*Distributed evaluation
To pass it is mandatory to have a minimum of 8 marks (in 20) in the final exam.
The distributed evaluation component consists of the average marks of the tests.
Special assessment (TE, DA, ...)
Students in special circumstances, who opt out of the distributed evaluation, will be assessed through a special exam. In these cases, the final classification is the classification obtained in the exam. The referred students should inform the professor about their intention. If they do not, they will be evaluated through the general rules for admission to exams. In this case the final grade is obtained as usual.
Students belonging to student committees are subject to the general evaluation rules.
Classification improvement
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.