Databases
Keywords |
Classification |
Keyword |
OFICIAL |
Information Systems |
Instance: 2010/2011 - 1S
Cycles of Study/Courses
Acronym |
No. of Students |
Study Plan |
Curricular Years |
Credits UCN |
Credits ECTS |
Contact hours |
Total Time |
MIEIC |
114 |
Syllabus since 2009/2010 |
3 |
- |
6 |
56 |
162 |
Teaching language
Suitable for English-speaking students
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:
- design the UML class model
- map the UML class model into the relational model
- design a relational database in the Boyce-Codd normalized form
- implement a database using the SQL data definition language
- use relational algebra to query databases
- query relational databases using the SQL data manipulation language and a procedural language
- optimize queries using indexes
- guarantee an adequate access control
- use transactions and concurrency that ensure data integrity of a database
- explain the main features of a database management system
- explain how can we access a database in a client-server architecture
- explain the main characteristics of Data Warehouses
Program
1. UML class model
2. Entity/Relationship (E/R) model
3. relational model (RM), normalization and mapping UML and E/R to RM
4. SQL data definition language
5. Relational algebra as a query language
6. Data manipulation language SQL
7. Views and indexes
8. Access control
9. SQL in a server environment: the PL/SQL procedural language
10. Transactions, concurrency control and crash recovery
11. Data Warehouses
Mandatory literature
Jeffrey D. Ullman, Jennifer Widom;
A First course in database systems. ISBN: 978-0-13-600-637-4
Complementary Bibliography
Raghu Ramakrishnan, Johannes Gehrke;
Database management systems. ISBN: 0-07-116898-2
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 10G
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 |
56,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 |
55 |
|
Study for the final exam |
Estudo autónomo |
32 |
|
|
Total: |
87,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,0 marks (in 20) in the distributed evaluation to be admitted to the final exam. The distributed evaluation will consist of 3 exercises to be solved in the practical classes.
Students who qualified for the final exam in the previous edition of the course unit, may opt for the previous mark, but they should inform the professor at the beginning of term.
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,0 marks (in 20) in the final exam.
The distributed evaluation component consists of the average marks of the exercises.
Examinations or Special Assignments
The dates for the distributed evaluation (3 exercises) are:
1. October 11th-14th;
2. November 15th-18th;
3. December 13th-16th;
during the practical lectures.
Special assessment (TE, DA, ...)
Students in special circumstances, who opt out of the distributed evaluation, will be assessed through a special exam.
Students in special circumstances that intend to discard the distributed evaluation should inform the the lecturers in the beginning of the semester. If they do not do it, they will be evaluated according to the "admission to exams" rules but without absence control.
Students belonging to student committees are subject to the general evaluation rules.
Classification improvement
It is possible to improve the final classification mark through a second exam of similar difficulty.
Observations
Optional teaching language: English.