Completado

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:

geaninaPrague

pls check PM !

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

9 freelancers están ofertando el promedio de $66 para este trabajo

eperfections

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)
5.9
diegogarcia0531

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

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

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

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

Ready to do it. Thanks.

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

Professional software-engineer. software design is my trade.

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

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

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

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)
0.0
Abhilashpuri

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)
0.0