Checking date: 03/09/2018


Course: 2018/2019

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


Coordinating teacher: RUIZ MEZCUA, MARIA BELEN

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

Type: Compulsory
ECTS Credits: 6.0 ECTS

Course:
Semester:




Students are expected to have completed
knowledge organization and representation
Competences and skills that will be acquired and learning results. Further information on this link
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 - Entity/ Relationship data model - 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
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 needed to carry out a methodology. The Entity-Relationship model. The Relational model. Transformation rules from model to model and its implementation in a commercial DBMS. Case studies to develop a database. Programme: Topic 1. The Databases roll in Information Systems 1.1. Information Systems Definition 1.2. Information System Components 1.3. Databases in the Information System Topic 2. Foundations of Databases 2.1. Databases Definition 2.2. Databases advantages and uses 2.3. Levels and roles Topic 3. Databases Management System (DBMS) 3.1. DBMS: the bridge between user interface and database. 3.2. Features and functions. 3.3. Commercial DBMS Topic 4. Database development methodology 4.1. Methodology definition 4.2. Methodology Application 4.3. Data Models 4.4. Main phases 4.5. Advantages Topic 5. Entity/Relationship model (ER) 5.1. Basic elements 5.2. Conceptual phase in the development methodology Topic 6. Relational model 6.1. Basis elements 6.2. Logical phase in the development methodology Topic 7. Mapping between ER and relational model 7.1. Rules 7.2. Mapping between conceptual and logical model
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. - Self-work practical: 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 50
  • % of continuous assessment (assigments, laboratory, practicals...) 50
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 and the academic weekly planning may change due academic events or other reasons.