Informatics Module II
2
2019-2020
01621687
Information Systems
Portuguese
Face-to-face
SEMESTRIAL
2.0
Compulsory
1st Cycle Studies
Recommended Prerequisites
NA
Teaching Methods
Initially, the main concepts and methodologies associated with relational database planning will be presented by the teacher using PowerPoint slides, after which a practical case is proposed to be solved.
From then on, classes will be mainly laboratorial and oriented to the practical usage of Microsoft Access with the teacher’s assistance.
Also, some classes will be dedicated to autonomous problem solving aiming to consolidate the main concepts
Learning Outcomes
Overall objectives
Students should be able to identify relevant data types concerning a specific organization, as well as plan and develop a relational database to store and process the data.
Specific objectives
Students should be able to:
1) Identify the different types of data
2) Develop a data relational model
3) Use the resulting model the develop a relational database
4) Develop the necessary queries to obtain relevant information
Generic competencies
Instrumental competencies (cognitive and technological)
Specific competencies
Analysis capability (being able to identify an organization information needs), synthesis capability (building a conceptual model to represent the data types and relationships needed to produce the information), elementary computing and informatics capabilities (Microsoft Access), and information management capabilities (being able to define the data storage structure and to build the necessary tools to produce the required information from it)
Work Placement(s)
NoSyllabus
1. Basic concepts
1.1. Data, Information, Knowledge
1.2. Database Management Systems
2. Database planning
2.1. Relational Model
2.2. Functional dependencies and normalization
3. Implementing the relational model in Microsoft Access
3.1. Database storage structures (tables)
3.2. Functional and structural restrictions (relationships and referential integrity)
3.3. Data processing: queries
Head Lecturer(s)
Luís Miguel Alçada Tomás de Almeida
Assessment Methods
Assessment
2 laboratorial tests (computer tests) to be done during lecture time : 100.0%
Bibliography
JUAREZ, Jon ; John Carter — Microsoft Office Access 2007 : a professional approach. Boston : McGraw-Hill Higher Education, 2008. [BP 519.6 JUA]
LAMBERT, Steve ; M. Dow Lambert ; Joan Preppernau — Microsoft Office Access 2007 step by step. Redmond : Microsoft Press, 2007. [BP 519.6 LAM]