ERD Modelling for a case study. Need Help

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.


Taidot: tiedonsyöttö, tietojenkäsittely

Näytä lisää: erd case study, case study erd, diagram case study, database erd case study, case erd, erd case help, erd case, erd scenario, eerd model sample case study, diagram case study project, case study diagram data, study case erd database, getting members, erd given case study, project erd database case study, erd database case study, case study entities erd, erd database case studies, cases erd database, erd senaro, free erd modelling, erd university, entity relationship diagram case study, sql erd case study, erd modelling

Tietoa työnantajasta:
( 2 arvostelua ) birmingham, United Kingdom

Projektin tunnus: #419894

Myönnetty käyttäjälle:


Sir, Plz check PM. regards. Diana.

80 $ USD 0 päivässä
(2 arvostelua)

14 freelancers are bidding on average $105 for this job


hi, i m expert in DB design. i do analysis for real project including more than 30 entities. regards, Hussien Sharaf

150 $ USD 4 päivässä
(15 arvostelua)

Hi, We are a group of data warehousing professionals. We can work on this but need more details of the project. Regards, Techno SGIT

113 $ USD 4 päivässä
(20 arvostelua)

I can do it once the case study is available

150 $ USD 2 päivässä
(10 arvostelua)

Hi, it can be perfectly done. Regards, Al

125 $ USD 2 päivässä
(3 arvostelua)

Please check PM

120 $ USD 2 päivässä
(4 arvostelua)

Hi, I am an Oracle Consultant, and your assignment forms part of Functional Phase. It's not a big deal to do the ERD for u, since your case study is a scenario which i have already done before. The ERD can be done Lisää

80 $ USD 2 päivässä
(1 arvostelu)

Hi, I can do the two models. Please provide more details. Thanks! Monica

30 $ USD 4 päivässä
(2 arvostelua)

I need the complete scenario of the project.

150 $ USD 5 päivässä
(0 arvostelua)

Honorable Buyer I am David Schlaver is a fresher freelancer. But I did a lot of jobs like this before. By the by I am proud to say that it’s my happiest moment to bidding you as a fresher freelancer. Please try to vi Lisää

150 $ USD 3 päivässä
(0 arvostelua)

Hi, please check PM.

40 $ USD 3 päivässä
(0 arvostelua)

I can do the [url removed, login to view] check PM

30 $ USD 2 päivässä
(0 arvostelua)

I am a fresher to freelancer. I can do this.

50 $ USD 3 päivässä
(3 arvostelua)

i am interested about ur [url removed, login to view] see my pm.

200 $ USD 4 päivässä
(1 arvostelu)