Create ER Model

1. Assets are resources that are used in CMS to display content. Each asset is either an image or an article. An asset has a description and creation date; Pictures have picture dates, articles have a title
2. Articles contain sections. (With these sections, articles can be broken down into a main article and subsequent pages, for example.) Sections are used by exactly one article and numbered within one article. Sections contain the text. (So if you want to create a single website in the CMS, you create an asset of the "Article" type with the heading and a section for this article that contains the text. For articles that are to be displayed on multiple HTML pages, an article asset is created with the heading and several sections, each containing the text of the individual pages)
3. Users are saved in the CMS with their name, a login and their password
4. Editors are users who can edit assets. For editors, in addition to their attributes as users, their personnel numbers are also saved (including accounting reasons)
5. Each user is a member of at least one group
6. Each group has name
7. Groups can have any number of subgroups, but only belong to one supergroup. (An example is a "editors" group that has subgroups "sports editors" and "business editors")
8. To manage rights, there are roles that have a name and one or more privileges - e.g. "Edit pictures" or "Create user". (These privileges are defined in the application program that uses this database, so the privileges should not be modeled as an entity.)
9. Groups can have one or more roles. Roles can belong to one or more groups