Käynnissä

ERD 1 + 2 Modelling assignment

REPOST-Due to previous service provider not finishing on time, this has been reposted, time is a factor now so please do not bid unless you can complete the task within a day of being chosen as winner. Time is paramount for this now.

Dear users, problem here is I have been given a project that is to be undertaken by a group, unfortunately group members have dropped out and tackling this alone, I am completely lost. The task is as follows, based on a case study (that I will not put up yet, but concerns a booking system for a university, contains about 10 entities).

THese are the following question I need help with;

a) A fully annotated E-R diagram 1 and 2 showing the entities, primary and foreign keys,

composite keys, relationships, optionality and cardinality.

b) A Relational schema of your database in 3NF, clearly indicating attributes, the data

type of each attribute, primary and foreign keys, candidate keys, and which attributes

are nullable, giving reasons. List any assumptions you need to make.

There is alot more to this coursework, but so far just getting the ERD1 & 2 correct has proven difficult. I need someone to attempt both so I can compare it against what I have so far.

Case study is attached, development of erd's 1 & 2, preference is using the "crow feet" notation and in powerpoint.

Regards

Herosquad

Taidot: tiedonsyöttö, tietojenkäsittely, projektinhallinta

Näytä lisää: erd modelling, fully annotated diagram, erd case study, erd diagram, erd payment system, erd airline, case study erd, service management group, getting members, annotated diagram, erd system, erd powerpoint, erd dorm reservation, erd dormitory system, erd case study samples, erd reservation system, airlines erd notation, airline database example erd, modelling erd, erd university reservation system, erd best price, air reservation erd ppt, erd project, dormitori system erd, erd airlines

About the Employer:
( 2 reviews ) birmingham, United Kingdom

Projektin tunnus: #422368

Myönnetty käyttäjälle:

parvezsavage

Hello again, I did bid last time but you did not select me.. I have read your case study, and it's not that difficult. The case study contains lots of entities, and you just need to know how to relate these entit Lisää

100 $ USD 0 päivässä
(1 arvostelu)
2.0

3 freelanceria on tarjonnut keskimäärin 77 $ tähän työhön

lancer103

check PM please

100 $ USD 1 päivässä
(0 arvostelua)
0.0
abhiyendra

be cheap and be classy is out motto - I do part time and work as a technical consultant in sun microsystems.I have a masters degree in mathematics and computing from iit delhi

30 $ USD 1 päivässä
(0 arvostelua)
0.0