|
Lecturer(s)
|
|
|
|
Course content
|
Requirements, course overview, seminar paper. Introduction - examples of databases. Basic definitions - database; data models (structures - linear, tree type, network type, relational) terminology of the relational database structure. Data model - entities, attributes, domains, relationships (participants, level, type) ; E-R diagrams. Database structure - lossless decomposition; candidature and primary keys; functional dependence; first, second and third normal form. Boyce/Codd, fourth and fifth normal form; relationship level; relationship types (unary, binary, ternary); entities and their relationships; cardinality; relationship models. Relationships and relations - defining cardinality (1:1, 1:N, N:M); relationship level - unary and ternary relationships; relationships of known cardinality. Data integrity - domain integrity; transition integrity; entity integrity. Data integrity - reference integrity; database integrity; transaction integrity; data integrity constraints. Structured Query Language SQL - history; basic definitions; models. SQL - DDL model; table definitions; SQL data definitions; keys; indexes; deleting indexes, tables; table structure alterations. SQL - DML model; inserting data; data alteration; deleting data; data projection. SQL - data selection; defining data constraints. SQL - joins (SQL89 x SQL92); types of joins. SQL - queries and calculations.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Demonstration, Projection, Skills training
|
|
Learning outcomes
|
The main goal of the discipline is to familiarise students with the presentation software MS Power Point and with the database software MS Access, including the necessary theoretical background. Students should prove their knowledge by passing the final test and presenting their course work successfully (defining and creating a database in MS Access without help of the Access Wizard tool). The MS Power Point will be used for the course work presentation.
The students will have mastered the majority of the database functionality of Microsoft Access upon the completion of the course. They will be able to define and solve their own routine work in Microsoft Access. The student also uses all common functions of the presentation program of Microsoft PowerPoint.
|
|
Prerequisites
|
The basic knowledge of Microsoft Windows operating system and Microsoft Word and Excel is required.
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation
Awarding course credit confirms that a student has fulfiled the required attendance and other qualifying requirements. Conditions for obtaining the credits are: active work at the seminar, min. 75% presence, passing computer tests. Student passes the exam if he/she obtains 50 points of possible 100 points. Form, contents and length of the exam are determined in accordance with the Study and Examination Regulations of University of Pardubice. The exam consists of two parts - a computer test and an oral exam. Student passes the exam if he/she obtains at tminimum 50% of possible points in each part.
|
|
Recommended literature
|
-
Kruczek, Aleš. Microsoft Office Access 2007 : podrobná uživatelská příručka. Brno: Computer Press, 2007. ISBN 978-80-251-1608-1.
-
Lambert S., Lambert III M. D. and Preppernau J. Microsoft? Office Access? 2007 Step by Step. Computer Press, 2007. ISBN 978-0735623033.
-
Oppel, A. Databases Demystified. McGraw-Hill Osborne Media, 2004. ISBN 10- 00722-5364-1.
-
Oppel, Andrew J. Databáze bez předchozích znalostí : [průvodce pro samouky]. Brno: Computer Press, 2006. ISBN 80-251-1199-7.
|