Foundations of databases is a core subject in Computer Engineering and is compulsory in Multimedia Engineering.
Foundations of databases is a core subject in Computer Engineering and is compulsory in Multimedia Engineering, which develops the concepts presented in Programming I and Mathematics I. It presents basic database techniques, which are essential for the efficient management of software, and are an advantage in many other areas owing to their power and versatility.
This is the first subject on the path to Database Design (CE) and Multimedia Database Design (ME), and in general, for all subjects related to the design and management of large amounts of information and its integration into organizational structures.
Unit 1: Organization
General objectives of the subject. Contents. Evaluation procedure, description of the activities that will take place.
Unit 2: Files and database techniques
Historical justification of the DB techniques. Main types and organizations of files, benefits and drawbacks. Frame of application and its relationship with the database companies. Legal issues regarding large volumes of data.
Unit 3: The Entity-Relationship data model
Basic concepts and functionality of the E-R model in DB techniques.
Unit 4: The relational data model
Scope of application. Mathematical fundamentals and
their implementation: relationship, domain and attribute concepts.
Unit 5: Database management systems
Basic concepts of DBMS: architecture, functions, components, transactions, optimization and performance, security. Distributed databases. Other data models
There are theory sessions and practical sessions.
The practical sessions last 1h 40 minutes per week and take place in a computer class in which the students teach themselves the specific aspects of the SQL language and their application to the concepts previously learned in theory sessions. The first 10 minutes, when planned, will be used to carry out an exam related to the contents of previous sessions, which will take place on the computer. These exams are part of the evaluation procedure, as explained below.
The theory sessions are divided into two parts: the first 50 minutes are used for lectures and examples; after a break of 10 minutes, the last 50 minutes will be used to develop the most practical part of the relational model theory or, depending on the aim of the session, it will be used as a supervised work session or a questions/review session.
The final mark of the subject is obtained in one or two calls, the first in June and the second in July. The first examination call is formulated as an evaluation that is distributed throughout the semester and the second is a re-sit of the first. This re-sit could be used to improve the marks obtained for any parts of the previous examination call.
The maximum mark for the subject is 150 points. It is considered to have been passed if 50% (75 points) or more of the points are obtained. It is necessary to obtain a minimum of 40% in each of the three types of evaluations (SQL, intermediate and final). Once these minimum percentages have been obtained, the final mark is the sum of all the sub-marks.
In the SQL partial exams, all the subject material is permitted, in addition to online tutorials and similar resources. However, no material can be consulted in the theory partials and final. Accessing websites with any kind of electronic device is prohibited. This also applies to the second exam call, since the exam is taken in a normal class without computers.
The final marks of the subjects are calculated from these three different types of exams:
As a re-sit of the previous call, we have
· 1 theoretical-practical exam (100 %) divided into 3 parts, each part of which is optional.
Owing to the fact that this is a re-sit of the previous call, the student can attend any or all of the following parts: TEST (intermediates), EXERCISES (final) or SQL, with the same percentages as in the previous call. The difference is that it is one single exam on the official date assigned by the UA. The students must decide which parts they wish to take depending on their needs.
The marks obtained in each part taken replace the previous marks obtained for that part. This means that, when taking one part, the part taken previously is no longer considered.
If time and resources allow, some extra and totally optional activities could be proposed in order to obtain extra marks. Whatever the case, they will be related to the first call only, will never be used as a mechanism to compensate a failing grade and the marks will never be stored.
The subject uses the following resources:
UA Academic calendar 2015-16, approved by the Consejo de Gobierno February27th 2014 (BOUA March 5th ).
For University of Alicante Degree students, the conditions required to pass the degree, the minimum number of credits, compulsory number of credits needed to matriculate, exam calls, …can be found at: