|Abbreviation: INŽBAPOD||Load: 30(L)
|Lecturers in charge: ||prof. dr. sc. Neven Pavković
|Lecturers: ||prof. dr. sc. Neven Pavković
|Course description: Course objectives:
Qualifying students for individual projecting, developing and implementation of relational databases in engineering domain. The course should give knowledge about projecting databases from beginners to intermediate level. Such a knowledge level should prepare the future engineers to be the active participants in processes of developing and management of the most complex product data information systems in medium and large production companies.
Enrolment requirements and required entry competences for the course:
Lecture and exercise attendance. For final grade student has to pass preliminary written exam, has to complete a project and present the seminar on particular issue from literature.
Grading and evaluation of student work over the course of instruction and at a final exam:
One preliminary written exam during the lectures, assessment of presentation of seminar work, assessment of project and student activity during the project work.
Methods of monitoring quality that ensure acquisition of exit competences:
Upon successful completion of the course, students will be able to (learning outcomes):
to independently design and develop a database architecture (structure) of medium complexity
to prepare, plan nad organize tasks within the projects of developing components of complex information systems
to evaluate the investments in development and/or purchasing of information systems (PLM, ERP and similar)
to criticaly justify and verify the processes of customization and implementation of PLM, ERP and similar systems
to manage the processes of maintenance and upgrading of existing information systems in production companies
1. Introduction to database systems. The development history. Areas of application, ANSI/SPARC architecture, projecting and development of information systems.
2. Database structure. Entityrelationship model. Table as the representation of relation. Types of relations, data types in tables, keys, indexes.
3. Basic database elements: tables, queries, forms, reports, programming procedures.
4. Structured query language (SQL) syntax and basic statements.
5. Relational algebra, normalization, normal forms.
6. The principles of event driven programming, the interface elements, types of events.
7. SQL: complex statements, examples.
8. Case study: an example of defining (projecting) the database structure.
9. Case study: an example of defining (projecting) the database structure.
10. Specific characteristics of engineering data. The differences between business and engineering domains.
11. Models and techniques for system analysis.
12. Preliminary written exam
13. Introduction to CASE tools, a survey of available tools and methodologies.
14. "Postrelation" models: Object databases, objectrelational databases, distributed databases.
15. Security: protection from unauthorized access, database recovery. Clientserver architectures.
1. Basic principles of working with commercial database environment, interface, basic manipulation.
2. Defining and creating of tables and indexes, establishing and manipulation of relations. Creating a simple database structure.
3. Form"s elements: properties, events and procedures. Binding form"s elements and data from tables.
4. Queries: types of queries, graphical creation of queries, usage of queries in program procedures.
5. Reports elements and working principles, creating a simple example.
6. Database programming the basic principles of programming environment usage, coupling with SQL statements.
7. Preliminary practical exam. Complex queries, recordsets.
8. The definition of project tasks. Individual project"s assignments. Clarifying of assigned tasks.
9. Advanced programming techniques: manipulations with records, recordsets, tables and relations.
10. Advanced programming techniques: complex transactions.
11. Working on individual project tasks consultations.
12. Working on individual project tasks consultations.
13. Working on individual project tasks consultations.
14. Working on individual project tasks consultations.
15. Presentations of project results by each student. Reviewing of projects, discussions, project assessment.
|1. ||An introduction to database systems, C.J. Date
|2. ||Databases Demystified, Andrew J. Oppel, McGraw Hill 2004.
|3. ||Beginning database solutions, Rod Stephens, Wiley, 2009.
|4. ||Microsoft Access 2007 manual