Question

Create a simple ERD

A friend of yours is starting a party business. She is organising events for clients. She needs to keep lists of her clients (i.e. the event hosts), of the events she organises and of event locations, where she runs her events. She does not need to know who the event participants are. She asks you to help build a database for her. You argue that the first step should be to design a data model. For the above scenario, design a simple ERD with at least three entities. Try to model one entity as an associative entity. Include the most important attributes (at least three per entity).

Answer 1

Answer:

Entity Relationship Diagram : This the diagram which shows the relation between each and every entity in the business organization. The entity diagram shows the exisiting connection between all the entities of the organization.

Party Business Organization: The Party business organization is the organization which shows the relation of the all the key entities of the party business. Like the clients are the most improtant entity of this party business. Then location is the another entity which is important for this business. Type of party and contenets of part detaisl can be the additinal information for the party business.

The Entity Relationship Diagram for the part business could be as below.

Party Business - Entity Relationship Diagram Party Type -1 Party Type -2 Party Type-3 Hosts/Clients -1 Loc.-1 Hosts/Clients -2 Loc.-2 Hosts/Clients -3 Loc.-3 ﹂|Hosts/Clients-4 | Loc-4 - Hosts/Clients-1 |Loc.-1 Hosts/Clients-2 | Loc.-2 Hosts/Clients -3 Loc.-3 Hosts/Clients -1 Loc.-1 Hosts/Clients -2 Loc.-2 Hosts/Clients -3 Loc.-3 Hosts/Clients-4 Loc.-4 Hosts/Clients -4 Loc.-4