The subject Database Design is located in the Software Engineering specialty of the degree in Computer Engineering. This subject is based on knowledge acquired in the subject called Databases that is taught in the second year, and also addresses issues of interest for the optional subject Databases Administration.

It also establishes links with some aspects described in the Software Engineering subject, specifically at the data management level of the three-layer architectures.

In this subject, after successfully completing the objectives indicated below, the following competences will be acquired:



* The ability to evaluate the customer's needs and specify the software resourses required to satisfy these needs, reconciling conflicting objectives through the search for acceptable compromises within the limitations of cost, time and the existence of already-developed systems and from the organizations themselves.



*The ability to identify and analyse problems and design, develop, implement, test and document software solutions based on knowledge of current theories, models and techniques.



Other general competences will also be worked on. These are described in the course profile in the document titled 'Lista_de_competencias.pdf', which is available at http://www.ehu.es/documents/340468/516505/Lista+de+competencias.pdf, in particular the general competences of the course C3, C4, C6, C8 and C9, as well as those of the Software Engineering speciality IS1, IS2, IS3 and IS4. And finally, transversal competences such as teamwork, oral and written communication, innovation, creativity and entrepreneurship, and autonomous learning.



Objectives



* Learn about the design phases of a database.



* Analyse data requirements to design conceptual schemes using E/R, E/R+ and UML.



* Design a logical schema (using a relational data model) of a database based on the conceptual schema.



* Normalise the relational schema.



* Define views over the relational schema.



* Define integrity constraints over the relational schema.



* Carry out the physical design of a database.



* Learn about other design techniques:

** Data Warehouses.

** Distributed databases.

1.Introduction: Principles of Databases Design, Life cycle of a DBS(Data Base System), design steps.

2.Conceptual Design: ER and UML models

ER model

ER+ model

Transformation from ER to Relational

Representation of conceptual design on UML

3.Normalization Process

4.SQL views

5.Integrity Constraints

6.Physical design

7.Other design techniques

Distributed Databases

Data Warehouses.

Most of the syllabus will be covered during teaching hours called classroom hours. Students will also have to strengthen their knowledge of concepts by working autonomously outside class hours (i.e. non-teaching hours), consulting specialised bibliography and doing project work and exercises.



In teaching and laboratory hours, time for discussion and the presentation of projects and exercises will be provided systematically, with the aim of encouraging students to participate actively in class and develop transversal skills.

• Continuous Assessment System
• Final Assessment System
• Tools and qualification percentages:
  • Written test to be taken (%): 50
  • Multiple-Choice Test (%): 20
  • Realization of Practical Work (exercises, cases or problems) (%): 10
  • Team projects (problem solving, project design)) (%): 20

The academic subject has two modalities of evaluation: final and continuous. Continuous evaluation, which the student can sign up for voluntarily, is only offered to those students who can carry out a continuous follow-up of the subject within the established timeframe and attend teaching activities.



Pre-enrolment in continuous evaluation will be done within the established dates. The pre-enrolment will become definitive after the confirmation of the application by the student within the established dates (between 60% and 80% of the course) and after a previous check on his/her performance by the teaching staff. If, within these dates, the student does not confirm his/her enrolment in continuous evaluation it will be understood that he/she opts for leaving it.



Overall evaluation:

- Written exam in the ordinary and extraordinary evaluations that are established.

Final exam 100%

Laboratory (must be performed at least 80% of those required) and practical work (at least a 5 mark must be obtained), are compulsory and must be performed before the exam.



Continuous evaluation will be done in the following tests:

- Three written tests (exams): 28 % + 28 % + 14 %

(To continue in continuous evaluation, the student must obtain a minimum 3.5 mark (out of 10) in all the exams

- Group work, plus presentation: 20 % (it is compulsory to obtain at least a 5 mark in the practical work)

- Laboratory work: 10%

Moreover, for the continuous evaluation an attendance of the (80% is required)

Assessment in extraordinary evaluation mode:

Final exam 100%

Laboratory (must be performed at least 80% of those required) and practical work (at least a 5 mark must be obtained) are compulsory. They must be done before the exam.

Basic bibliography

Fundamentals of Database Systems, 7th Edition R. Elmasri, S. B. Navathe, 2017 Pearson.



Database Systems. Introduction to Databases and Data Warehouses N. Jukic, S. Vrbsky, S. Nestorov 2017 Prospect Press.



Database Systems. A practical approach to Design, Implementation and Management. 5th edition. 2009.



Database Systems. The Complete Book. H. Garcia-Molina, J.D. Ullman, J. Widom. Pearson. 2nd edition. Prentice Hall 2009.

In-depth bibliography

Principles of Database Management. The practical guide to storing, managing and analyzing Big and Small data. W. Lemahieu, S.V. Broucke, B. Baesens. Cambridge University Press 2018.

Database Systems. The Complete Book. H. Garcia-Molina, J.D. Ullman, J. Widom. Pearson. 2nd edition. Prentice Hall 2009.