Nummer20204S2Zielsetzung / PurposeBy attending this course, students will learn the basic concepts underlying databases. They will be able to use Entity-Relationship diagrams to develop data models and to transform these into normalized databases.
Theory:
Students will be able to analyze and formulate SQL and QBE queries, and use these queries to extract information from databases. They will also gain practical experience with simple database development tools.
Students will learn about the architecture and usage of information systems in business management, and will understand the tasks, roles and methods used in information management.
Finally, students will learn how to use MS Excel solver to address optimization problems in different business domains.
Tools:
This part is accompanying the theory. Students are working on the design and implementation of a database solution for a particular business domain. Their work tasks include the design and implementation of the database. The design of forms and reports finally constitutes the user interface of the databse application.
Inhalt / Content- Basic concepts of databases
- Basic concepts of data modelling
- Entity-Relationship model
- Relational models
- Normalization
- Database languages and queries with SQL and QBE
- Practical usage of the database tool MS Access
- Information systems for business management
- Optimization problems using Excel Solver
Besondere Eintrittsvoraussetzungen / Special Conditions of AdmissionBusiness Information Systems 1Bibliographie/Literatur / Bibliography / Literature / ReferencesRequired textbook:
Further references:
Various materials in Moodle
Links given in the lectures, Wikipedia and
independent research in the Internet
Lehr- und Lernmethoden / Methods- Lectures
- Group work
- Interactive online tutorials
- Individual study, reading and assignments
Leistungsbewertung/Testanforderung(en) / Assessment- Written exam, 60 minutes
- The course is weighted according to the number of ECTS-credits in the module
