Introduction to Databases and Programming

Base Knowledge

Basic Knowledge of Programming

Teaching Methodologies

– Classes Face-to-face

• Theoretical classes: theoretical exposition of the subject
• Laboratory classes; Resolution of practical exercises based on a statement
• Students have information and notes available on the school’s moodle platform.
• Report templates will be available to students.
• The teacher has 6 hours available to answer questions. At the request of the student, Zoom sessions will be scheduled
• Students can also contact the teacher by email.

Learning Results

Goals

This curricular unit aims to provide students with the necessary skills for building basic databases with the support of learning the DBMS Access. Thus, concepts related to the conception, design and implementation of databases in general and in particular in the context of their implementation in DBMS Access will be taught using VBA and SQL programming. Thus, students will be enabled with the basic knowledge for the manipulation of information in the database.
At the end of the course the student should be able to design and implement a Database based on the DBMS Access and using Macros and VBA.

Skills

Knowledge and Understanding
A.1. Identify the concepts underlying relational databases.
A.2. Know how to query a relational database using SQL.
A.3. Build a standardized model of relational databases.
A.4. Build database in DBMS Access with Macros, VBA and SQL.

Application of Knowledge
B.1. Develop models of relational databases.
B.2. Define the conceptual and physical model of a standardized relational database.
B.3. Develop basic databases in Access.
Grounded Decisions
C.1. Justify the proposed solutions at the level of a basic database project.
Judgment Achievement
D.1. Evaluate database models, demonstrating a critical attitude.
Communication
E.1. Prepare appropriate documentation within the scope of the specification and analysis of relational databases.
E.2. Present and explain the projects developed in a clear way.

Self-Learning Skills
F.1. Develop projects with a high degree of autonomy, without being limited to the concepts learned in class.

 

Program

1. Introduction to Databases
1.1. Concepts
1.2. Information representation
1.3. Relational Model
1.4. Entity-Relationship Model
2. Domains and Relationships
2.1. Domains
2.2. Relations
2.3. Types of Relationships
2.4. Relations and predicates
3. Integrity of relational data
3.1. Candidate keys
3.2. Primary keys and alternative keys
3.3. Foreign keys
4. The SQL Language
4.1. SQL basics
4.2. Relational Algebra
4.3. SQL functions
4.4. Sorting and Grouping
4.5. Subqueries
4.6. Table Management
4.7. Entity, Referential and Field Integrity Restrictions
4.8. Views and Data Manipulation
5. Programming with Visual Basic for Applications
5.1. Introduction
5.2. Variables, Types and Expressions
5.3. Vectors and Matrices
5.4. Control and Flow Instructions
5.5. Objects, Methods, Properties
5.6. Use of VBA in Access

Curricular Unit Teachers

Internship(s)

NAO

Bibliography

Information and support material for the course, Moodle of the Course, http://moodle.isec.pt/
Alves, W. P. (2016). Estudo Dirigido de Microsoft® Access 2016. Érica / Editora Saraiva.
Damas, L. M. (s.d.). SQL – Structured Query Language – 6ª Edição Actualizada e Aumentada. ISBN: 972-722-443-1
Date, C. J. (2004). An Introduction to Database Systems. Pearson/Addison-Wesley. ISBN: 0-321-18956-6
Mansfield, R. (2016). Mastering VBA for Microsoft Office 2016. ISBN: 978-1-119-22538-6
Ramez Elmasri, S. B. (s.d.). Fundamentals of database systems. Pearson/Addison Wesley. ISBN: 0-321-20448-4
Ricardo A. Ramos, J. d. (2007). Curso Essencial de VBA. Digerati Books. ISBN 978-85-60480-67-8
Simpson, A. (s.d.). Access VBA Programming For Dummies. ISBN: 0-7645-7411-6