Lecture | Information Systems

Database design and -management


The course “Database design and -management” was designed as a web-based training. It deals with the complete procedure of designing a relational database. First of all, the basic principles and terms are explained as well as the meaning and the purpose of databases in general. The next chapter is about the single phases of database design. It starts with the definition of requirements, is followed by the conceptualization of the data model and ends with the implementation of the database. Essential models and strategies of the different phases will be introduced. One main concept is the Entity-Relationship-Model. There will be further information on how to derive specific tables from conceptual schemes and how they can be converted with the language SQL. Practice on commands for data definition, data manipulation and data control will be given, too. Finally, the learning module finishes with an introduction to the language XML, the definition language XML-schema and DTD, which allow the definition of XML-based interfaces between different programs.

Learning outcomes

  • To understand the complete procedure of designing a relational database.
  • To create an Entity-Relationship-Model.
  • To convert the Entity-Relationship-Model into a logical table and to normalize it.
  • To create a specific relational database and to use it.
  • To learn the standards of the information language SQL. 6. To understand the structure of XML-files, as well as the corresponding definition documents in DTD and XML-scheme.
Number of credit hours per week 3
Course eligibility Optional
Presence of students On-campus and on-line