Degree | Type | Year | Semester |
---|---|---|---|
2502441 Computer Engineering | OB | 2 | 1 |
It is recommended that students have knowledge and skills:
• Programming in third-generation languages (C, Pascal, Basic, etc.).
• Basic data structures.
These concepts correspond to the contents of the subjects:
• Fundamentals of informatics
• Programming Methodology
This course introduces the basic concepts of databases (BD) necessary so much to level of design of BD and of user.
KNOWLEDGE: At the end of the course, students must be able to:
SKILLS: It is intended that students acquire the following skills:
BLOCK 1. DATA BASES PARADIGMS
1. Introduction. Basics
2. Architecture
BLOCK 2. RELATIONAL DATABASES
3. Relational data Model
BLOCK 3. MODEL ENTITY-RELATIONSHIP
4. The Entity-relationship model
BLOCK 4. RELATIONAL DATABASE DESIGN
5. Design of a database
6. Normalization
BLOCK 5. FILE ACCESS
7. Internal level
The final objective of the course is that students are able to design and manipulate relational databases in the context of current computer applications. For this reason, the classroom sessions will be highly practical and will focus on the students to consolidate the knowledge that is objective of learning this subject.
The general methodology of the course can be divided into three activities:
PREVIOUS PREPARATION. The aim is that the Alumnado can learn the concepts that will work in the next session through diverse activities proposed by the Profesorado like it can be the viewing of videos, the reading of texts, etc. All the necessary material (enunciated, BD scripts, problem results) will be available in the documentary Manager Caronte (http://caronte.uab.cat).
CLASSROOM. The objective is to consolidate the concepts seen and put them into value within the context of the subject. The teacher will ensure that students delve into these concepts through exercises (more or less) guided during the session. For this reason the classroom sessions will take place in 2 weekly 2-hour meetings each in classrooms with of oridnadors and connection to the servant. The distribution will be based on problem groups. The attendance to the classroom is not COMPULSORY, but RECOMMENDABLE.
The management of the classes that due to the pandemic are made on-line will be through teams https://teams.microsoft.com/, any change throughout the course will be notified Caronte.
AUTONOMOUS LEARNING. Two activities are proposed: case use in the design of a real database including requirements analysis, design and self-learning of typical SQL queries.
The practices and problems statements are available on the Web page in PF and Caronte (http://caronte.uab.cat).
Deliveries of autonomous learning work will be done via Caronte.
Transversal competences:
The competencies T 02.03-manage the time and resources available. Work in an organised way, T 02.05-make own decisions and T 02.08-critically evaluate the work carried out to are, both, worked in the activity of the design of a BD in which the student will work in a group of 5 people to make a technical report on the development of a database from scratch
Annotation: Within the schedule set by the centre or degree programme, 15 minutes of one class will be reserved for students to evaluate their lecturers and their courses or modules through questionnaires.
Title | Hours | ECTS | Learning Outcomes |
---|---|---|---|
Type: Directed | |||
Classroom explanations (on-line due to COVID) | 50 | 2 | 11, 12, 6, 2, 3, 4, 10, 5, 7 |
Type: Supervised | |||
Use Case Technical Report | 34 | 1.36 | 1, 12, 6, 10, 9, 8 |
Type: Autonomous | |||
Previous Work | 35 | 1.4 | 12, 6, 10, 7 |
SQL On-line Queries | 17 | 0.68 | 10, 7, 9 |
The course will be evaluated in 3 aspects: Theory and problems, practices and self-learning activities. The mark of theory/problems will be obtained by means of an individual examination and the one of practices by means of the individual delivery of some exercises in the last session of practices. The mark of the autonomous work will obtain delivering a series of exercises along the course and will consist of 2 activities: Technical report (20%) and SQL queries (10%).
The final mark will be the weighted average of the grade obtained in each activity:
FINAL MARK= 0 ' 4 * Theory exam Mark + 0 ' 3 * Practical exercises + 0 ' 2 * Technical report Mark + 0 ' 1 * autonomous work Mark
In order to make the weighted average, it is necessary to pass the theory exam and practice exercises with a 5. The remaining activities (technical report and autonomous work) do not require minimum mark to do average. In case of not reaching the minimum required in any of the evaluation activities the final grade in the student record will be the minimum between the final mark (obtained from the weighted average) and 4 ' 5. The subject is considered passed if the final grade is equal to or exceeded 5.
EVALUATION CRITERIA
Theory exam. There will be two individual written examinations, weighing 40% each on the final grade. The first test will be held approximately in the middle of the semester and the second Test will be held at the end of the semester during the exams period.
The final grade of the theory will be the average of the 2 partial notes, if the note of each partial exceeds 4. Otherwise, the theory part will be considered suspended and the student will have to take a recuperation of the part suspended. In the case of not reaching the minimum for one of the exams, the theory grade will be the minimum between the averageand a 4'5.
Practice exercises. The practices assessment is done by delivering a test of SQL queries carried out in the laboratory integrated during the examination period, and where the student will have access to his notes. The format will be the same as the autonomous learning module.
SQL queries module. Autonomous learning activities are available throughout the course. Consist of several modules of SQL queries available in Caronte that are open certain periods of time specified in the own module. Each query correctly resolved Púntua 1 (sencilles) or 2 (subqueries) points. The point will be obtained at the time the student has answered consultations worth 75% of the maximum score to be achieved if all the modules had been answered correctly.
Technical report of a use case. The technical report consists of 4 parts corresponding to the 4 phases of the design of a BD: requirements, Diagram ER, table logic Model and implementation/testing game. The document must be properly formatted because the design ER and table logical Model diagrams can be read correctly. If a diagram can not be read with clarity for reasons of resolution or quality, this part of the report will be suspended, as well as those that depend on it not being evaluated. The report has 2 deliveries. To suspend the first, you can get back to 5 in the second installment.
Continuous Assessment: The continuous assessment process includes all these activities: technical report (recoverable supervised group activity), SQL queries module (supervised indivdual activity) and theory and Problems exam (synthesis test Recoverable
Theory revision exam: In case the note of some individual theory exam is less than 4, or the overall average does not reach 5, students will have to undertake a revision exam to pass the part of theory and problems they have failed.
Practice exercicies revision: In case that in thepractice exercises is not reached the 5, the student will have a new opportunity with the same format and norms.
IMPORTANT FOR ALL STUDENTS: It is important to register in Caronte (http://caronte.uab.cat) at the beginning of the course, as the materials of the subject are published, the practical deliveries are made and the final grades of the course are published. To register in Careonte in the subject of databases 1, you must give your personal data and a passport photo in JPG format.
NON-ASSESSABLE: A student is considered non-assessable (NA) only if he has not done any assessment activity. Recall that a non-assessable (NA) also consumes registration.
There is no special treatment for students who repeat the subject.
Pass with Honor: Students who have more than a 9.5 in the final grade will have a distinction of honour (MH) until reaching the limit of 5% of the enrolled holders. In case of having more than 5% of the students over the 9.5 will have MH those that have the highest notes.
EVALUATION CALENDAR:
• Theory and problem Examinations: Theory hours announced in advance.
• Recovery exam: Depending on the academic calendar of the school of Engineering.
• Practice exercises: During the period of the partial seconds, in laboratory practicals and announced in advance.
• Rehabilitation of practices: During the period of theory recovery exams, in laboratory practices and announced in advance.
• Autonomous work: the theory and/or problems will be communicated in advance either via Caronte or in lectures.
The dates of continuous assessment and delivery of work will be published in Caronte and may be subject to programming changes for reasons of adaptation to possible incidents. Caronte will always be informed about these changes as it is understood that this is the usual platform for exchanging information between teachers and students.
For each evaluation activity, a place, date and time of revision will be indicated in which the student will be able to revise the activity with the teacher. In this context, it will be possible to make claims about the activity mark, which will be evaluated by the teachers responsible for the course. If the student is not present for this revision, this activity will not be reviewed later.
ACADEMIC IRREGULARITIES. Notwithstanding other disciplinary measures deemed appropriate, and in accordance with the academic
regulations in force, assessment activities will receive a zero whenever a student commits academic
irregularities that may alter such assessment. Assessment activities graded in this way and by this procedure
will not be re-assessable. If passing the assessment activity or activities in question is required to pass the
subject, the awarding of a zero for disciplinary measures will also entail a direct fail for the subject, with no
opportunity to re-assess this in the same academic year. Irregularities contemplated in this procedure include,
among others:
• allowing others to copy;
• presenting group work that has not been done entirely by the members of the group;
• presenting any materials prepared by a third party as one’s own work, even if these materials are
translations or adaptations, including work that is not original or exclusively that of the student;
• having communication devices (such as mobile phones, smart watches, etc.) accessible during
theoretical-practical assessment tests (individual exams).
In case of not passing the subject because one of the evaluation activities does not reach the minimum note, the numerical grade of the file will be the lowest value between 4.5 and the weighted average of the notes. A "non-assessable" grade cannot be assigned
to students who have participated in any of the individual partial tests or the final exam.
In short: copying, leaving copying orplagiating in any of the evaluation activities equals a FAIL with a note less than 3.0.
Title | Weighting | Hours | ECTS | Learning Outcomes |
---|---|---|---|---|
Individual pratical exercices | 30% | 2 | 0.08 | 6, 10, 7 |
Individual final exams of theory and exercicies | 40% | 4 | 0.16 | 11, 12, 6, 2, 3, 4, 10, 5, 7 |
Individual partial exams of theory and exercicies | 40% | 4 | 0.16 | 11, 12, 6, 2, 3, 4, 10, 5, 7 |
SQL On-line Queries | 10% | 1.3 | 0.05 | 10, 7, 9 |
Use Case Technical Report | 20% | 2.7 | 0.11 | 1, 12, 6, 10, 9, 8 |
COURSE MATERIAL: Caronte http://caronte.uab.cat
BASIC REFERENCES:
EXTRA REFERENCES:
WEB SITES:
MULTIUSER DATA BASES:
SQL- developer, Data Modeller, Oracle (for local BD)