Database Management I

GENERAL

OBJECTIVE

Early existing problems regarding the processing of data (in the 1960s) has been the motivation to deﬁne a novel (hierarchical) concept to manage data. Because of many disadvantages regarding a multi-use of the system, security, or data organisation, this original concept has been improved step-by-step and ﬁnally found its triumphal procession by the workings of E. F. Codd (1970s), who proposed the use of relational algebra as the fundamental concept (which bases on the theory of sets). Since this time, Relational Database Systems have established and are still the most popular database system in almost any domains and applications.

PRELIMINARY SCHEDULE

In this course, we thereore discuss the concept of data, aspects regarding modelling, and fundamental issues with respect to database systems. The preliminary content will be as follows (42h in total):

C01: DBMS Systems - yesterday and today: Historical Review - Evolvement of database systems - Types of databases - Vendors - et cetera.
C02: Requirements, Requirement Analysis, Business Rules.
C03: Semantic Modeling with Entity Relationship Models.
C04: Relational Algebra.
C05: From ER Models to a Relational system.
C06: Sequential Query Language (SQL): Overview and Query Optimisation.
C07: Normalforms (1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
C08: The Relational Database System MySQL (alternatively: IBM DB2): Conception - Architecture - How To Use.

A written examination is offered at the end of the course. This course is followed by Database Management II.

AIMS OF QUALIFICATION

The course counts for 5 ECTS (= 3h per week) and is split into 2h lecture and 1h exercise. The requirements of the course are a general mathematical understanding, an abstractive thinking, and a general will concerning an understanding. The course is followed by Database Management II (Application Programming) and Database Management III (Business Intelligence).

LEARNING OUTCOMES

In this course, we foster on the aspect of the Database Management and discuss several aspects as described above. The student will learn how to collect data, to analyse requirements, to transfer these to a semantic model and (ﬁnally) to a (relational) database system. Additionally, we introduce the database system mySQL, the student gets to know to its maintenance and retrieve of data by SQL as well as with the optimization of queries.

MISCELLANEOUS

The course will be held in the English language. All students are obliged to participate each session. During course time, it is not allowed to use mobile phones and other electronic devices that potentially disturb the course execution.

SELECTED REFERENCES

R. Elmasri, S. Navathe: Fundamentals of Database Systems. 5th Edition. Pearson Addison Wesley. 2006.
H. Garcia-Molina, J. D. Ullman, J. Widom: Database Systems � The Complete Book. Prentice Hall International. 2008.
R. Ramakrishnan, J. Gehrke: Database Management Systems. Mcgraw-Hill Professional. 2002.
A. Silberschatz, Henry F. Korth, S. Sudarshan. Database System Concepts. Sixth Edition.
J. Ullman: Principles of Database Systems. W. H. Freeman & Co Ltd. 1982.

"Database Management I" is mentioned on: Courses | Database Management II | Database Management III | Members