Practice on Database Organization
In the following tasks, you need to outline the structure of the tables: their names and fields.
A blog containing articles. Articles are divided into categories. Users leave comments on the articles.
A forum containing categories, within them topics (a topic belongs to only one category), and posts within topics. A topic has an author. Users can exchange private messages. Outline the table structure.
A social network with users, their friends, a wall, and comments on wall posts. Users can exchange private messages. Outline the table structure.
There are seas, rivers, and their tributaries. Rivers can be tributaries of other rivers or flow directly into a sea or an ocean. Outline the table structure.
User, exchange of messages between users. Outline the table structure.
A website with dates of football games. Each game contains the game date, the first team, and the second team. There are players, each of whom belongs to one team. Outline the table structure.
A family tree. A user, their grandmothers, grandfathers, mother, father, brothers, sisters, children. It should be possible to find any relative in any generation (e.g., a great-great-great-grandfather). It is necessary to store and retrieve family relationships. Outline the table structure.