Database & Design, Entity Relationahip model, ERD, SQL

完了済み 投稿 Nov 2, 2012 着払い
完了済み 着払い

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

SQL

プロジェクトID: #2616689

プロジェクトについて

9個の提案 リモートプロジェクト アクティブ Nov 3, 2012

アワード:

geaninaPrague

pls check PM !

$30 USD 1日以内
(0レビュー)
1.0

9人のフリーランサーが、平均$66 で、この仕事に入札しています。

eperfections

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

$50 USD 1日以内
(65件のレビュー)
5.9
diegogarcia0531

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

$50 USD 1日以内
(11件のレビュー)
4.3
it2051229

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

$50 USD 1日以内
(11件のレビュー)
3.8
ranjitsinha

Ready to do it. Thanks.

$50 USD 1日以内
(9件のレビュー)
3.3
mlambrichs

Professional software-engineer. software design is my trade.

$30 USD 1日以内
(3件のレビュー)
2.1
tung238

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

$30 USD 2日以内
(0件のレビュー)
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 もっと

$250 USD 25日以内
(0件のレビュー)
0.0