Checking date: 04/06/2021


Course: 2021/2022

Databases
(17452)
Study: Bachelor in Management of Information and Digital Contents (340)


Coordinating teacher: MARTINEZ FERNANDEZ, PALOMA

Department assigned to the subject: Department of Computer Science and Engineering

Type: Compulsory
ECTS Credits: 6.0 ECTS

Course:
Semester:




Requirements (Subjects that are assumed to be known)
knowledge organization and representation
Objectives
This course aim is to understand the databases roll in an Information System, to know the features which define a Databases System, and to acquire skills to implement a Databases Systems through different data models. 1. Cross/Generic Capabilities - Analysis and synthesis abilities - Organize and plan abilities - Troubleshooting - Teamwork - Ability to apply knowledge in practice 2. Specific Capabilities Cognitive (Knowledge) - Fundamentals of Databases - Databases development methodology - Relational data model Procedural/Instrumental (Know how) - Database Design to different abstraction levels - Implementing Database Systems using a DBMS Attitudinal (To be) - Ability to create designs (creativity) - Discuss and clarify the diverse solutions for a problem Generals: CG1, CG2, CG3, CG4, CG7, CB2, CB3, CB4, CB5 CROSS: CT2, CT3,CT4SPECIFICS: CE1, CE2, CE3, CE4,CE7,CE11, CE12
Skills and learning outcomes
Description of contents: programme
The descriptors associated with the subject are: Basic concepts of databases. The role of database managment system. Application of a methodology for the development of databases. Data models in methodologies. The Relational model. SQL, Case studies to develop a database. CONTENTS Issue 1. Introduction to databases 1.1 The Databases role in Information Systems 1.2. Foundations of Databases 1.3 Databases Management System (DBMS) 1.4 Database modesl and development methodologies Issue 2. Relational model 2.1. Basis elements 2.2. Constraints Issue 3. Relational databases Design Issue 4: SQL lenguage -Definition, Updating and Querying Databases
Learning activities and methodology
- Theory: 1.5 ECTS. The aim is to achieve the specific cognitive skills of the subject - Problem-based learning: 0.75 ECTS. Specific works under the supervision of the teacher about real problems. - Practical: 1 ECTS. To develop specific skills instrumentals and traversals, such as teamwork, analysis and synthesis. We also aim to develop specific skills attitude. - Tutoring: 0.5 ECTS. With the presence of teacher to review and discuss the materials and topics presented in class. - Review: 0.25 ECTS. Set of written tests, oral, practical projects, works, etc.. used in the assessment of student progress. They aim to influence and complement in the development of specific cognitive and procedural skills. - Practical Self-work : 0.5 ECTS. Lab works studied under a didactical guide provided by teacher. - Self-Theoretical study: 1.5 ECTS. Study of content related to "classroom" (test study, library work, reading, doing problems and exercises, etc.)
Assessment System
  • % end-of-term-examination 40
  • % of continuous assessment (assigments, laboratory, practicals...) 60
Calendar of Continuous assessment
Basic Bibliography
  • - Elmasri, R.. Database systems : models, languages, design, and application programming. Pearson . 2011
  • - Silberschatz, A.. Database system concepts. McGraw-Hill. 2011
Recursos electrónicosElectronic Resources *
(*) Access to some electronic resources may be restricted to members of the university community and require validation through Campus Global. If you try to connect from outside of the University you will need to set up a VPN


The course syllabus may change due academic events or other reasons.