Degree | Type | Year | Semester |
---|---|---|---|
2503740 Computational Mathematics and Data Analytics | OB | 2 | 1 |
It is recommended that the student has knowledge and skills of:
These concepts correspond to content of the subjects:
In this course we will introduce basic concepts of relational databases (DB), which are necessary both for users and designers.
Knowledge:
At the end of the course the student will be capable of:
Abilities:
At the end of the course the student will develop the following abilities:
Introduction and basic concepts
2. Architecture
3. Design. The entity-relationship model
4. The relational model of databases
5. The design of a database
6. Internal level
The learning process will be based in three kinds of activities: (a) theory, problems and practical sessions, and the creation of a database with its corresponding technical report. All the documentation and the necessary materials for following the course will be available from the course online platform (http://caronte.uab.es)
FORMATIVE ACTIVITIES LED BY THE TEACHER
Theory and Problems:
Theory will be imparted on the screen using electronic support and powerpoint. We will introduce all the necessary theoretical concepts to be able to solve the problems that will appear along the course. During the problem time we will solve some exercises in class and encourage students to do the rest autonomously, using the database and exemplary solutions. Problem sessions will be divided in two blocks: (a) relational database design and (b) database query.
(a) In the first problem group, we will practice the E-R design following some specific practical requirements.
(b) In the second problem group we will explain the basic concepts of Relational Algebra (RA) and Structured Query Language (SQL) over an exemplary database. We will query this database in both RA and SQL with increasing levels of complexity. The idea is to use the concepts of RA to understand the logic behind SQL querying with emphasizing that RA could be of much use in complex queries. We will provide the results of the queries for the students to verify their results.
Lab practice:
In lab practical sessions, we will introduce the student to the practical side of Structured Query Language (SQL) language, which is the standard language to query relational databases.
Each session will consist of a series of exercises on a database with the objective of comprehending the concepts explained in previous theory sessions. The general idea is also to familiarize the student withthe practical side of designing, creating and manipulating relational databases as users and programmers.
Students should prepare the work explained in the practical coursework. This preparation must occur before the corresponding practical session. The work ends by assisting to the practical sessions tutorised by the teach at the time agreed.
Practical coursework material, timetables for presentations and evaluations will be publicised in Caronte (http://caronte.uab.es). We will make all possible efforts to allow the students to complete the practical work at home, although in some cases this might not be possible, and these should be completed using university computers.
AUTONOMOUS FORMATIVE ACTIVITIES
Creation of a database with its corresponding technical report:
Alongside theory lessons, problems and practical lessons, all students should participate in the creation of a database. This process will be complete by submitting a technical report, the scripts necessary for the task, and a test set for database validation. This will be accomplished in groups of 4 or 5 students whose work will be mostly autonomous under the supervision of the teacher in tutorial time.
Self-assessed practical SQL work:
Alongside theory lessons, problems and practical sessions, all students should participate in self-assessed partical work consisting in the resolution of SQL problems online. This work will be done individually by students at the time they consider most convinient within the dynamic of the course. The statements of these SQL problems, alongside theinstructions on how to complete them and evaluate them will be available through the document platfom Caronte well in advance.
SUPERVISED FORMATIVE ACTIVITIES
Tutorials:
These can be group-based or one-to-one based depending on the subject to discuss. The objective of these tutorials is to solve doubts and consolidate the knowledge acquired during the week. The tutorial timetablewill be availabla at the begining of the course, but the student should tell the teacher (preferently by e-mail) his/her intentions to assist to a tutorial well in advance.
Please note that:
a. Teaching will be offered on campus or in an on-campus and remote hybrid format depending on the number of students per group and the size of the rooms at 50% capacity.
b. The proposed teaching methodology may undergo some modifications according to the restrictions imposed by the health authorities on on-campus courses.
Title | Hours | ECTS | Learning Outcomes |
---|---|---|---|
Type: Directed | |||
Practical Sessions | 10 | 0.4 | 1, 2, 3, 4 |
Theory and Problems Sessions | 36 | 1.44 | 1, 2, 3, 4 |
Type: Supervised | |||
Tutorials | 15 | 0.6 | 8, 7 |
Type: Autonomous | |||
Database creation and writing of its corresponding technical report | 25 | 1 | 1, 2, 3, 6, 9 |
Exercise preparation and theoretical quizzes resolution | 15 | 0.6 | 8, 2, 3, 9 |
Practical sessions' preparation | 5 | 0.2 | 1, 2, 3, 5, 9, 4 |
Study | 36 | 1.44 | 7, 5, 9, 4 |
The evaluation of the course consists of 5 parts: theory exam, E-R design problems’ evaluation, drafting of a technical report, evaluation of practical work and SQL query resolution. The weight of each of these exams can be seen in the table of evaluation activities. The final grade (Nota_Final) will be the weighted average of the notes in each part provided that the minimum mark for each evaluation is exceeded. The minimum grade for the theory exam is 4. For the other evaluations there is no minimum mark. A grade must be drawn higher, or equal, to 5 to approve the course. A student is considered "not evaluable" only if he has not done any assessment activity.
The final grade will be calculated as follows:
Nota_Final = 0,2* Nota_Pract + 0,2*Nota_InfTèc + 0,1*Nota_AutoAval + 0,2*Nota_Probl + 0,3*Nota_Teoria
Nota_Final = 0,2* Nota_Pract + 0,2*Nota_InfTèc + 0,1*Nota_AutoAval + 0,2*Nota_Probl
EVALUATION CRITERIA
Nota_IT_ = max [(nota1 + nota2) / 2; 0,7 * nota2]
The resolution of autonomous SQL queries (self-assessed partical work) will be done outside the class schedules through an online autonomous learning module. This learning module will be open after each practical session and will be available until the day before the next session. The mark will be proportional to the number of questions answered throughout the course and its difficulty.
In the case of not fulfilling the conditions to approve the course, the final grade will be the minimum between the mark obtained from the weighted average of the sit-in exams and a 4.5. (The course is considered approved if the final grade exceeds 5).
RE-EVALUATION CRITERIA
Students who are in one of these three situations can apply for re-evaluation:
(A) students with a grade in the theory exam equal to or greater than 3.5 and who obtain a final grade from the course between 4 and 5. (Nota_Teoria > = 3.5 but with 4 < = Nota_Final < 5)
(B) students with a final grade to pass the course (a 5) but who have a low grade (less than 4) in the final exam. (Nota_Teoria <4 but with Nota_Final > = 5)
(C) students with a final grade of the course equal or greater than 4 and with an average of sit-in exams (problems, practices and theory) equal to or greater than 3.5. (Nota_Final > = 4 but with ((0.3 * Nota_Teoria + 0.2 * Nota_Probl + 0.2 * Nota_Pract)/0.7) > = 3.5)
In this test of re-evaluation, which will be written and held in the last week of the semester, the student will be evaluated again in the same content as inthe theory exam. You must obtain a grade higher, or equal, to 5 to approve the re-evaluation. If approved, the final grade of the course will be "approved" (a 5). In case of suspending, the final grade of the course will be the maximum between the grade obtained in the exam of re-evaluation and the average of the grades obtained in sit-in examinations.
Students in the following situation will pass the course with a final grade equal to the minimum mark (a 5):
(D) students who obtain a total mark of the course between 3.5 and 5, but have passed the theory exam (3.5 < = Nota_Final < 5 but with Nota_Teoria > = 5)
OTHER IMPORTANT INFORMATION
• REGISTRATION IN CARONTE: Students should register in Caronte (http://caronte.uab.cat) at the beginning of the course, since coursework materials, practical assignments and final marks are published there. To register in Caronte it is necessary to enter personal data and a photo card in JPG format. This information will remain strictly private and will be destroyed once the course has finished.
• CONVALIDATIONS: There will be no special treatment for students who repeat the course.
• HONOR REGISTRATIONS: Students who have more than 9.5 in the final mark will have an honor matriculation (MH) up to the limit of 5% of those enrolled, according to UAB regulations. In the case of having more than 5% of the students over 9.5, MH will be awarded tothose who have the highestmarks.
• PLAGIARISM: Without prejudice to other disciplinary measures that may be considered appropriate, the irregularities committed by any student that can lead to a variation in the markings of an evaluation act will lead to a grade of zero. Therefore, copying, plagiarizing, cheating, copying, etc. in any of the assessment activities it will imply a suspension and result in a zero mark. Assessment activities qualified in this way and by this procedurewill not be recoverable. If it is necessary topass any of these assessment activities to pass the subject, this subject will be suspended directly, without opportunity to recover it in the same course. In the case of the Technical Report, all the groups involved will be punished with zero (0), regardless of the authorship of the work.
Calendar of evaluation activities
The dates of the evaluation activities (midterm exams, exercises in the classroom, assignments, ...) will be announced well in advance during the semester.
The date of the final exam is scheduled in the assessment calendar of the Faculty.
"The dates of evaluation activities cannot be modified, unless there is an exceptional and duly justified reason why an evaluation activity cannot be carried out. In this case, the degree coordinator will contact both the teaching staff and the affected student, and a new date will be scheduled within the same academic period to make up for the missed evaluation activity." Section 1 of Article 115. Calendar of evaluation activities (Academic Regulations UAB). Students of the Faculty of Economics and Business, who in accordance with the previous paragraph need to change an evaluation activity date must process the request by filling out an Application for exams' reschedule https://eformularis.uab.cat/group/deganat_feie/application-for-exams-reschedule
Grade revision process
After all grading activities have ended, students will be informed of the date and way in which the course grades will be published. Students will be also be informed of the procedure, place, date and time of grade revision following University regulations.
Retake Process
"To be eligible to participate in the retake process, it isrequired for students to have been previouslybeen evaluated for at least two thirds of the total evaluation activities of the subject." Section 3 of Article 112 ter. The recovery (UAB Academic Regulations). Additionally, it is required that the student to have achieved an average grade of the subject between 3.5 and 4.9.
The date of the retake exam will be posted in the calendar of evaluation activities of the Faculty. Students who take this exam and pass, will get a grade of 5 for the subject. If the student does not pass the retake, the grade will remain unchanged, and hence, student will fail the course.
Irregularities in evaluation activities
In spite of other disciplinary measures deemed appropriate, and in accordance with current academic regulations, "in the case that the student makes any irregularity that could lead to a significant variation in the grade of an evaluation activity, it will be graded with a 0, regardless of the disciplinary process that can be instructed. In case of various irregularities occur in the evaluation of the same subject, the final grade of this subject will be 0". Section 10 of Article 116. Results of the evaluation. (UAB Academic Regulations).
Final note: The proposed evaluation activities may undergo some changes according to the restrictions imposed by the health authorities on on-campus courses.
Title | Weighting | Hours | ECTS | Learning Outcomes |
---|---|---|---|---|
Autonomous SQL query resolution | 10 | 2 | 0.08 | 8, 3, 7, 5, 4 |
E-R design problems evaluation | 20 | 1.5 | 0.06 | 8, 1, 2, 7 |
Practical exam | 20 | 2 | 0.08 | 3, 7, 4 |
Technical report | 20 | 0.5 | 0.02 | 8, 1, 2, 7, 6, 5, 9 |
Theory exam | 30 | 2 | 0.08 | 8, 7 |
Basic Bibliography
Complementary bibliography
Web links