Database Technologies
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 |
23 |
Syllabus since 2009/2010 |
4 |
- |
6 |
56 |
162 |
Teaching language
Suitable for English-speaking students
Objectives
The students should be able to design and manage large databases, namely to tune the physical schema, to optimize SQL queries, to recover systems and to define concurrency policies, as well as to profit from extensions to object manipulation and XML technology.
Program
DB administration. Query execution and optimization. Physical schema and database tuning. Storing and indexing data. Replication. Modelling in object relational databases. Building database supported Web applications. Interoperability. XML and databases.
Mandatory literature
Ullman, Jeffrey D.;
A First Course in Database Systems. ISBN: 0-13-861337-0
Garcia-Molina, Hector;
Database system implementation. ISBN: 0-13-040264-8
Complementary Bibliography
Date, C. J.;
An introduction to database systems. ISBN: 0-201-68419-5
Date, C. J.;
A Guide to the SQL Standard. ISBN: 0-201-55822-X
Ramakrishnan, Raghu;
Database Management Systems. ISBN: 0-07-115508-2
Akmal B. Chaudhri, Awais Rashid, Roberto Zicari; XML Data Management: Native XML and XML-Enabled Database Systems. ISBN: ISBN: 0201844524
Teaching methods and learning activities
Classes are used to formal presentation of the subjects, along with examples and the corresponding laboratory analysis. To guide the experimental side of the learning process, a set of laboratory exercises are proposed, and its resolution is followed until the final report is produced.
Software
Oracle SQL Developer
Oracle Server 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 |
42,00 |
|
|
Query optimization assignment |
Trabalho laboratorial |
15,00 |
|
2011-03-14 |
Object-relational modeling assignment |
Trabalho laboratorial |
15,00 |
|
2011-04-04 |
PL/SQL and XML assignment |
Trabalho laboratorial |
15,00 |
|
2011-05-23 |
Final examination |
Exame |
3,00 |
|
|
|
Total: |
- |
0,00 |
|
Amount of time allocated to each course unit
Description |
Type |
Time (hours) |
End date |
Self study |
Estudo autónomo |
72 |
|
|
Total: |
72,00 |
|
Eligibility for exams
Students have to reach a minimum grade of 6 out of 20 in the continuous assessment component.
Calculation formula of final grade
Mark- (0,5 CA + 0,5 FE)
Students have to reach a minimum grade of 7,5 out of 20 in the final exam.
Examinations or Special Assignments
Students have to do three assignments during the semester. They will be about: query optimization, object relational databases and XML interoperability. The assignments should be delivered on the 4th, 8th and 12th week of the semester.
Classification improvement
Students can improve the classification of the final exam by attending to the second chance exam. The classification of the lab assignments can be improved in the following year.
Observations
Students should be acquainted with object programming, relational databases, normalization theory and SQL.