Databases

Ficha de unidade curricular - Ano letivo 2018/2019

Teaching language

English

Intended learning outcomes (Knowledges, skills and competencies to be developed by the students)

Information is one of the most important commodities in today’s business management. Being able to handle it is vital.
Aims:
•Recognize how databases underlying and support business needs; identify the distinct types and main characteristics, with special relevance to relational databases; and apply Relational Database Management (RDBM) objects to business realities.

Syllabus

•Databases concepts and characteristics.
•Databases as business application supports.
•Relational Databases.
•Relational Databases Management Systems.
•Practical Work/Laboratory
•How to Create Databases.
•Using Tables, Queries, Forms, Reports and Macros applied to a practical example.
•Practical exercises resolution.

Software

Microsoft Access

Demonstration of the syllabus coherence with the UC intended learning outcomes

•Expositive Method – Presentation of theoretical concepts.
•Demonstrative Method – Demonstration and application of learned concepts.
•Participative Method – Participation in class, making practical use of learned concepts.

Teaching methodologies

Avaliação distribuída com exame final

Assessment methodologies and evidences

•Continuous assessment: Completion of a written theoretical test (25%), Relational Model Activity (10%), individual activities (10%) and presentation and discussion of a report on a group assignment about applying a Database to solve a business problem (55%).
•Final assessment: Completion of an examination with both a written theoretical component (35%), and a practical application component (65%).

Assement and Attendance registers

Main Bibliography