Database & Design, Entity Relationahip model, ERD, SQL

The Full description is attached.

1a) Entity-relationship model mapped to a relational database

Produce an Entity-Relationship Model using UML notation for the above case.

Convert to a relational model by specifying the primary and foreign keys, mapping any one-to-one relationships into relations, and decomposing any many-to-many relationships. This is the Relation diagram and the diagram which you should submit.

Note that there is no need to include the type of each attribute. State any assumptions that you may need to make particularly about optional and mandatory relationships. Note that assumptions are about how you have interpreted the scenario, not about the E-R modelling process.

The ERD is not trivial – it involves at least 10 entities. I suggest you start by each member of your group concentrating on different parts of the ERD and then coming together to discuss.

1b) Validate the model

Checking for connection traps

Examine your model and identify one potential trap (fan trap or chasm trap) - if present. Consider whether this may cause a problem to your model and re-draw if necessary, arguing your case either way.

Supporting the functional requirements

Validate the model to check it can support the following functional requirement i.e. specify the access path by listing the appropriate relations (taking into account the correct relationships) from your diagram:

‘List all members by name who have ever belonged to the Science group, who have a talent for music and have attended an event with Goldie as the outside speaker.’

Will pay $50

Habilidades: SQL

Ver más: potential fan trap erd, uml for sql, the design group, parts database access, music by design, interpreted, how to design uml, design science, access parts database, entity design, sql r, r sql, sql support, notation, Functional requirements, erd, entity relationship, e/r diagram, access database note taking, sql database relationship

Información del empleador:
( 3 comentarios ) ginseng, United Kingdom

Nº del proyecto: #2616689

Adjudicado a:


pls check PM !

$30 USD en 1 día
(0 comentarios)

9 freelancers están ofertando un promedio de $66 por este trabajo


I have done many similar projects. Confident to handle this easily. Waiting for you to accept my bid.

$50 USD en 1 día
(65 comentarios)

Hi, I am ready to do this job, Please check PMB

$50 USD en 1 día
(11 comentarios)

Hi, kindly check your inbox for my inquiries. Thanks.

$50 USD en 1 día
(11 comentarios)

Ready to do it. Thanks.

$50 USD en 1 día
(9 comentarios)

Professional software-engineer. software design is my trade.

$30 USD en 1 día
(3 comentarios)

Hi mehan123, I understand the requirement and I can do this for you.

$30 USD en 2 días
(0 comentarios)

Dear Sir/Madam, I am interested in the work because of the emphasis on the Design and Developing skills which are applicable to your requirements for Software Developer. I also have extensive experience in Crystal Más

$250 USD en 25 días
(0 comentarios)

Dear Sir, we have a very good team which has experience in developing project on RDBMS(relational database management system) which is required by you. UML diagrams will be as your requirements. Customer satisfaction i Más

$50 USD en 5 días
(0 comentarios)