How to find us
|
Contacts

Database Fundamentals 2017/2018

  • 6 ECTS
  • Taught in Portuguese
  • Both continuous and final Assessment

Objectives

It is intended with this discipline:
1. Learn the general concepts of databases and models.
2. Develop the ability to construct models of relational databases.
3. Improve the use of the Access interface for modeling.
4. Learn the basics of SQL.
5. Learn the basics of manipulating the SQL Server interface.
The objectives presented will allow effective use of Information Systems and Technologies in terms of improving decision-making processes.

Recommended Prerequisites

Good knowledge of algorithm and programming in both traditional and objects.
Good mastery of the concepts of classes and methods.
Good application development domain (.NET) for creating interfaces and accessing databases with Visual Basic.

Teaching Metodology

Methodology: In the theoretical-practical sessions will be presented the topics of the UC and the students will be invited to participate in its practical application in the final period of the session. Additional problems will be proposed which will be discussed in practical sessions. The final solutions will be those achieved by each student.

Strategy: This UC has two major goals: 1) To develop the capacity to construct Database models and 2) its practical implementation complemented with the development of a set of SQL statements.

The strategy will be: Work! Only the practice in approaching and developing solutions to new problems can support the mental mechanisms that will lead to the achievement of capable results. The tactics to be followed will be to present the theoretical subjects, solve problems collectively, move to solve simple problems and gradually increase their complexity

Body of Work

0.Introduction to Databases

Goals
Historical Perspective
Storage
Data Concepts
Organization
Advantages of a DBMS

1.Database modelling

Introduction
Systems analysis
Modeling
Data model

Relational database

Relational algebra
Financial Services

2.Construction of an Access Database

3. Database Access Technology

ADO
ADO.NET
How client applications communicate with databases
ADO.NET architecture overview
How to use ADO.NET in a VB.NET project

4.SQL

Typical components of a database system
SQL Features
SQL APPROACH

5. SQL / Transact SQL Language

Definition of Data, Constraints and Schema
Basic Queries
More complex queries

INSERT, DELETE, and UPDATE statements

Recommended Bibliography

All necessary information will be provided in the practical classes.

Connolly, T.M. & Begg, C.E. (2014). Database Systems: A practical approach to Design, Implementation and Management (6Ed). Pearson

Faroult, S. & Robson, P. (2006). The Art of SQL.
O'Reilly

Garcia-Molina, H. & Ullman, J.D. & Widom, J. (2009).
Database Systems: The Complete Book (2Ed).
Pearson

Complementary Bibliography

Help documentation from:
- Visual Studio
- Access
- Management Studio
- SQL Server

Weekly Planning

1 Introduction to databases
2 General concepts of databases
3 General concepts of databases
4 General concepts of databases
5 Modeling
6 Modeling
7 Modeling
8 Modeling
9 Modeling
10 Introduction to SQL
11 SQL
12 SQL
13 SQL
14 SQL
15 SQL

Demonstration of the syllabus coherence with the curricular unit's objectives

The contents cover all the concepts necessary to the objectives and constitute their development systematized by areas.

Demonstration of the teaching methodologies coherence with the curricular unit's objectives

Only the practice in approaching and developing solutions to new problems can support the mental mechanisms that will lead to results.

relevant generic skillimproved?assessed?
Achieving practical application of theoretical knowledgeYesYes
Adapting to new situationsYesYes
Analytical and synthetic skillsYesYes
Balanced decision making  
Commitment to effectivenessYesYes
CreativityYesYes
Event organization, planning and managementYesYes
Foreign language proficiency  
Initiative and entrepreneurship capabilityYesYes
IT and technology proficiency Yes
Problem-solvingYesYes
Research skillsYesYes
Written and verbal communications skills  
This website uses cookies to provide better functionality and for performance measurements (European Union Directive 2009/136/EC)
Please take a few minutes do answer a few quick questions about our website.