Database design

ID: 1600
Course type: vocational and applied
Course coordinator: Lazović M. Goran
Lecturers: Lazović M. Goran, Rosić Vitas B. Maja
Contact: Lazović M. Goran
Level of studies: B.Sc. (undergraduate) Academic Studies – Mechanical Engineering
ECTS: 6
Final exam type: project design
Department: Department of Information Technologies in Mechanical Engineering

Lectures

Goal

The main goal of this course is to understand the basic concepts necessary for the design, implementation and use of a functional database.

Outcome

Students will be able to apply basic techniques of database design and implementation without anomalies. They will also acquire the skills for database manipulation that are necessary for both database administration and database application development.

Theoretical teaching

Concepts and architecture of database management systems. Data model. Conceptual data model, entity relationship model. Logical data model, relational model. Relational algebra, SQL. Data anomalies, functional dependence. Armstrong's rules. Normal forms and decomposition. Physical model, secondary memory. I/O computation model. File organization. Index files, indexes. Parallel processing, transactions.

Practical teaching

Real system database design and implementation development in a modern environment by using certain database management system.

Attendance requirement

No prerequisites for attending classes

Resources

Computer lab

Assigned hours

Total assigned hours: 75

Active teaching (theoretical)

New material: 20
Elaboration and examples (recapitulation): 10

Active teaching (practical)

Auditory exercises: 10
Laboratory exercises: 20
Calculation tasks: 0
Seminar paper: 0
Project: 0
Consultations: 0
Discussion/workshop: 0
Research study work: 0

Knowledge test

Review and grading of calculation tasks: 0
Review and grading of lab reports: 0
Review and grading of seminar papers: 0
Review and grading of the project: 15
Test: 0
Test: 0
Final exam: 0

Knowledge test (100 points total)

Activity during lectures: 0
Test/test: 0
Laboratory practice: 0
Calculation tasks: 0
Seminar paper: 0
Project: 40
Final exam: 60
Requirement for taking the exam (required number of points): 30

Literature

Gordana Pavlović-Lažetić; Uvod u relacione baze podataka; Matematički fakultet;1999; Ramakrishnan, Gehrke; Database Management Systems; McGraw-Hill; 2002