2020-11-07| YouTube explanation (German) | IHK final exam Winter 2003/2004, GH1 Exercise 2
A telephone provider wants to persist all of their customer data inside a database. After talking with the telephone provider's CEO you receive the following information:
The company provides different rates, like "Mobile Data only" or "Phone flatrate". Each of the company's customer can have any number of phones. Each of those phones has exactly one rate assigned. For the billing, a customer must provide his banking details. There can be only one bank account per customer. A bank account belongs to a bank. Each customer's call is tracked, so the customer can receive a mobile itemization report. Every call has unique call id.
Your task is to create a database model with all primary and foreign keys. Additional attributes (like firstname of customer) are not relevant.
2020-11-07| YouTube explanation (German) | IHK final exam Winter 2003/2004, GH2 Exercise 4
One of your colleagues has started to design the database of an ordering application:
// Note: an article can be purchased from any supplier for a different price.
Table article_group {
id integer
name char(255) [not null]
}
Table article {
id integer
description text
retail_price decimal(8,2) [not null]
in_stock integer
__1 datatype
}
Table order {
id integer
ordered_at datetime [not null]
__1 datatype
}
Table order_item {
id integer
order_id integer
__1 datatype
__2 datatype
}
Table supplier {
__1 datatype
name char(255) [not null, unique]
address text [not null]
}
Table __ {
// Hint: this table must have its own internal id
__1 datatype
__2 datatype
__3 datatype
__4 datatype
}
Complete the schema by adding the relevant primary and foreign keys and missing table(s). Also note that an article can be purchased from any supplier for a different price.
2020-10-31| YouTube explanation (German) | IHK final exam Summer 2003, GH2 Exercise 6
For managing the inventory of his PC shop, the owner uses an Excel sheet. The following screenshot contains the current format:
The owner wants to migrate this Excel sheet to a relational database.
2020-10-24| YouTube explanation (German) | IHK final exam Winter 2002/2003, GH1 Exercise 6
A hardware development company wants to track their downtimes due to issues in their own network. Instead of using a program like Jira, they want to develop their own issue tracker.
Based upon the following screenshot you have to model an ER diagram:
2020-10-18| YouTube explanation (German) | IHK final exam Summer 2001, GH1 Exercise 4
A carsharing company provides two Excel tables and an invoice. Those artifacts are used for creating invoices for their customers.
Based upon this information we have to model the ER diagram.
Those two tables are containing the stamdata:
This is the invoice the carsharing company sends to its customers:
How has the ER diagram to be modelled?
2020-10-03
In today's exercise we want to model an internal web application for a company. Management and supervisors want to do employee interviews twice a year. Before each interview, each employee is assessed by himself and his supervisor independently. There are around 20 statements in which employees have to be assesed. Each statement belongs to one of -currently- five topics. For example the topic "Way of working" contains the statements
Each of these twenty statements can be valued by choosing a numerical value between 1 (does not apply) and 5 (applies fully) and allows a comment.
The company uses Microsoft Azure Cloud.
2020-10-03
The following screenshot is a real-world sample from a catering service
Design a database model based upon the screenshot/PDF above.
2020-10-03
A simple blog application has to be developed.
A blog can have multiple blog posts. One blog post belongs to exactly one author. A blog post can have one of the following status: draft, published or revoked.
For better structuring, a blog post can have any number of tags. In addition to that, categories can be also used. One blog post can optionally belong to a category.