Database Fundamentals 2017/2018
- 6 ECTS
- Taught in Portuguese
- Both continuous and final Assessment
- relevant skillset
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.
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.
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
Advantages of a DBMS
2.Construction of an Access Database
3. Database Access Technology
How client applications communicate with databases
ADO.NET architecture overview
How to use ADO.NET in a VB.NET project
Typical components of a database system
5. SQL / Transact SQL Language
Definition of Data, Constraints and Schema
More complex queries
INSERT, DELETE, and UPDATE statements
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.
Garcia-Molina, H. & Ullman, J.D. & Widom, J. (2009).
Database Systems: The Complete Book (2Ed).
Help documentation from:
- Visual Studio
- Management Studio
- SQL Server
1 Introduction to databases
2 General concepts of databases
3 General concepts of databases
4 General concepts of databases
10 Introduction to 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 skill||improved?||assessed?|
|Achieving practical application of theoretical knowledge||Yes||Yes|
|Adapting to new situations||Yes||Yes|
|Analytical and synthetic skills||Yes||Yes|
|Balanced decision making|
|Commitment to effectiveness||Yes||Yes|
|Event organization, planning and management||Yes||Yes|
|Foreign language proficiency|
|Initiative and entrepreneurship capability||Yes||Yes|
|IT and technology proficiency||Yes|
|Written and verbal communications skills|