Assessment

Continous Assessment Activities

Title	Weighting	Hours	ECTS	Learning Outcomes
SQL Exam	25%	2	0.08	3
Technical Rapport	25%	2	0.08	4, 6, 7
Theory Exams	50%	4	0.16	1, 2, 5
Voluntary exercise delivery	+1,0	2	0.08	2, 3, 6

The evaluation of the subject will be carried out continuously, based on three indicators: Theory, SQL and the Technical Report.

THEORY

There will be two individual written exams, with a weight of 50% each on the Theory Note. The first test (Par1) will be done approximately halfway through the semester and will evaluate the theoretical concepts explained up to date and the ability to solve BDR queries in relational algebra. The second test (Par2) will be carried out at the end of the semester and will evaluate the concepts explained until the time of theory (design of BD, normalization, physical level) and the ability to solve assumptions of design E/R and step to relational model.

Recovery test: In case the theory note does not reach the approved, students may submit to a review of recovery on the contents of the partial examination suspended.

Seminar classes offer two voluntary deliveries valued each with 0.5 points to add to the partial exam mark (Par1 or Par2). The first delivery consists of SQL query exercises where the student's abilities are evaluated in the resolution of SQL BDR queries (NPrb1). The second consists of a design exercise of BD, where based on some requirements, the most appropriate E/R diagram must be designed (NPrb2).

SQL EXAM

Individual examination by computer where the student's abilities are evaluated in the resolution of SQL queries. A series of random SQL queries are proposed on the BD used in the seminars that the student must solve in a given time (SQL Note).

Recovery Test: If the SQL exam is not reached on 5, the student has a new opportunity with the same format and rules

TECHNICAL RAPPORT

The Technical Report is an assessable group activity consisting of 4 parts, corresponding to the 4 design phases of a BDR: Requirements, E / R Diagram, Logical Design in tables and Implementation of a set of SQL queries. A written document that contains the work carried out in the 4 phases, duly justified, will be presented. The document must have the appropriate format so that the diagrams of the E / R Diagram and the corresponding Relational Diagram can be read correctly. The Technical Report Note will be obtained from two deliveries: The first one, with the writing of the data requirements of the presented case and the E / R Diagram, resulting from the design of the BD. The second installment will contain the same points of the first one including the teacher's corrections by adding the Relational Diagram (resulting from the logical design) and the code of the SQL queries and their results in tables. The note of the Technical Report will be the weighted average of the note obtained from the two deliveries: Design E / R (60% of the note) and the Logical Design with SQL queries (40%).

If a diagram of the Technical Report could not be read clearly for reasons of resolution or quality, this part of the report will be suspended, as well as the parts that depend on it as it can not be evaluated.

QUALICATION INDICATORS

The final grade of the subject is calculated in the following way (between square brackets the minimum marks to make half):

• Partial Mark #1 = (Par1 + NPrb1)    [Par1 >=4,5]
• Partial Mark #2 = (Par2 +NPrb2)  [Par2 >= 4,5]
• Theory Mark = 0'5 * (Partial Mark #1) + 0'5 * (Nota Partial Mark #2)  [Partial Mark #i >=5, i=1,2]
• SQL Mark [SQL Mark >=5]
• Technical Rapport Mark = 0'6 * E/R Design Mark + 0'4 * Logical Design Mark                 [E/R Design Mark, Logical Design Mark >= 5]
• FINAL GRADE = 0'5* Theory Mark + 0'25 * SQL Mark + 0'25 * Technical Rapport Mark
  

EVALUATION CRITERIA

• To count the marks of the voluntary deliveries of the seminars (NPrb1 and NPrb2) you must obtain a minimum of 4.5 in the corresponding partial exam note (Par1 or Par2).
• In order to calculate the FINAL SUBJECT, we will have to pass all the evaluable activities (examinations of Theory, SQL Exam and the Technical Report) with a 5.
• In all recovery activities (partial exams or internships), the maximum mark will be 8.
• NOT ASSESSABLE: A student is considered Non-Appraiser (NA) only if he has not done any evaluation activity. We recall that the non-valuable note also runs a call.
• NOT PASS: In the case of not reaching the minimum required in any of the assessment activities, if the calculation of the final grade is equal to or greater than 5, a 4 note will be placed on the file.
• MATRICULA DE HONOR (MH) - HIGH DISTINCTION: Students with a mark equal to or greater than 9 points can obtain a MH, at the discretion of the teacher. As the number of MH can not exceed 5% of students enrolled, students who have the highest final grades will be awarded, at the discretion of the teacher.
• REPEATERS: No approved part is approved (Theory, SQL Exam, Technical Report) from one academic year to another.
• IMPORTANT FOR ALL STUDENTS: It is important to enroll in Caronte(http://caronte.uab.cat, subject Bases de Dades Relacionals, curs Docència BDR curs 2019-20) at the beginning of the course, because the materialsare published of the subject, the deliveries of the Technical report are made and the final notes of the subject are published. If this is the first time you enter Caronte, you must provide your NIU, password, first and last name, email and a photo ID in JPG format. Caronte is a manager different from the UAB Virtual Campus, which means that passwords mustn't be the same.

EVALUATION CALENDAR:

• Partial Exams: Dates at the end of the teaching guide published in the LMS and provided to students on the first day of class.
• Recovery Exams: According to the academic calendar of the School of Engineering.
• Voluntary deliveries in the seminar sessions: Noticed in advance, since being a voluntary activity, it is intended to encourage attendance at seminars throughout the semester.
• Delivery Technical Reports: Dates at the end of the teaching guide provided to the students on the first day of class, appearing in the course of Caronte the corresponding week.CALENDER OF EVALUATION:

The dates of continuous evaluation will be published in Caronte and may be subject to changes of programming for reasons of adaptation to possible incidents. Charon will always be informed about these changes as it is understood to be the usual platform for the exchange of information between teachers and students outside the classroom.

Notwithstanding other disciplinary measures deemed appropriate, and in accordance with the current academic regulations, irregularities committed by a student that may lead to a variation of the qualification will be classified by zero (0). Assessment activities qualified in this way and by this procedure will not be recoverable. If it is necessary to pass any of these assessment activities to pass the subject, the aquatic will be suspended directly, without opportunity to recover itin the same course. These irregularities include, among others:

• The total orpartial copy of a practice, report, or any other evaluation activity.
• Let cop.
• Present a group work not done entirely by the members of the group.
• Present as own materials produced by a third party, although they are translations or adaptations, and generally works with non-original and exclusive elements of the student.
• Have communication devices (such as mobile phones, smart watches, etc.) accessible during theoretical-practice tests (individual exams).

With the exceptions that the "non-evaluable" qualification will be awarded to students who do not participate in any of the assessment activities, and that the numerical note of the file will be the lowest value between 3.0 and the average Weighted notes in case the student has committed irregularities in an evaluation act (and therefore not approved for compensation).

SUMMING UP:: copying, copying, or plagiarizing in any of the assessment activities is equivalent to a SUSPENS with a score of less than 3.5.