|
Data Bases
Scholar Year: 2023/2024 - 1S
Code: |
LGRH20548 |
|
Acronym: |
BD |
Scientific Fields: |
Sistemas e Tecnologias de Informação |
Courses
Acronym |
Nº of students |
Study Plan |
Curricular year |
ECTS |
Contact hours |
Total Time |
LGRH |
82 |
Study Plain |
2º |
4,5 |
45 |
121,5 |
Teaching language
Portuguese
Intended learning outcomes (Knowledges, skills and competencies to be developed by the students)
The students will be able to develop user friendly database(DB) applications to improve the organizational
performance. The learning outcomes are focused on knowledge acquisition:
• Understand the importance of DB in the organization;
• Know and use the features available in the DB;
• Develop DB Management applications to improve individual and organizational performance.
Macro Skills: ability to review/research; individual efficiency, interpersonal and group; troubleshooting;
creativity.
Core Skills: ability to understand the information requirements necessary for DB Management in an
organizational context; ability to define the pertinent information to solve the problem; ability to develop
applications for managing DB for improving organizational performance.
Vocational Skills: ability to develop friendly applications to promote the DB usages in decision making and competitive advantages acquisition.
Syllabus
1. Background
2. Databases
3. Data structure
4. Data handling
5. Data presentation
6. Applications
Software
Microsoft Access 2010
Demonstration of the syllabus coherence with the UC intended learning outcomes
The teaching methods used:
• Expository methods
• Exploratory strategies in order to:
o Laboratory Method (learning by individual discovery of specific software);
o Learning by individual research underlying the implementation of a task in a specific field;
• Use of the simulation in order to place the student at the teaching/learning center .
• Thereby bring closer the theoretical and practical requirements of the real labor market.
Theoretical components are taught using a combination the exposit in (concepts) and and participatory
methods. In practical components the participative approach and problem is used, solving in a cooperative
learning strategy.
The continuous assessment comprises:
• Individual theoretical test
• two Individual practical test
Teaching methodologies
Avaliação distribuída com exame final
Demonstration of the teaching methodologies coherence with the curricular unit's intended learning outcomes
The continuous assessment comprises:
• Classroom participation (TT)
• Practice Test (PT).
Final Classification = 20% TT + 80% TP
Assessment methodologies and evidences
The final assessment comprises:
Exam Theoretical and Practical composed of: Theoretical Part (PT) and Practice Part (PP).
Final Classification = 20% PT +80% PP
Attendance system
The Classification comprises:
Exam Theoretical and Practical composed of: Theoretical Part (PT) and Practice Part (PP).
Final Note =20% PT + 80% of PP
Main Bibliography
Gouveia, F., ;Fundamentos de Base de Dados, FCA – Editora de Informática, 2014 |
Neves, J.;Fundamental do Access 2010, FCA – Editora de Informática, 2010 |
Scmalz, M.;Integrating Excel and Access, O’Reilly, 2005 |
Complementary Bibliography
Date, C.J. ;An Introduction to Database Systems, Addison Wesley Publishing Company, 2000 (7th Edition) |
Elmasri, R. and Navathe, S.B. ;Fundamentals of Database Systems, Addison Wesley Longman, Inc., 2000 (3rd Edition) |
Date, C.J. ;The Database Relational Model: A Retrospective Review and Analysis, Addison Wesley Longman, Inc., 2001 |
Conrad, J.;Microsoft Access 2010 Inside Out, Microsoft Press, 2010 |
|
|