I need to create an entity attribute diagram for the following problem and i am having some difficulties doing it.
'A company is managing the creative aspects of the construction of a series of Video Games for a publisher, by collecting details of all the games assets under construction (characters, levels, sound effects). Game assets are created by designers (who work in teams, and who each work on more than one asset), each of whom have a set of skills in art, design, sound, animation, etc. (these are just samples, there are many more skills).
Assets can be reused in multiple games. All assets are stored in the same format; they have an attached media sample for use in promoting the games (an image, or sound), a filename and a description of the asset, plus the date it was created, and a version number (to track changes). It is important to be able to distinguish between each of the different types of asset (character, level, sound effect). It is also important to hold enough information on the individual designers that could be used in writing press releases for the company.
A game is made up of at least one level and at least one character, and any number of sound effects.'
I need to list all the entities and attributes. Your help will be greatly appreciated. Thanks