Find Jobs
Hire Freelancers

Create an EERM

£10-20 GBP

Færdiggjort
Slået op cirka 8 år siden

£10-20 GBP

Betales ved levering
a university wants to set up a database to store information about a conference it is hosting. Participants will be authors and reviewers of academic papers. Some participants will only be authors, some will only be reviewers, and some will be both. For all participants, their name and email address will be stored. In addition, the system will store the name of the organisation to which authors are affiliated, and a field of specialisation for each reviewer. A paper can have more than one author. There will be exactly one contact author for each paper (this is the author the conference will contact wrt a specific paper). Every paper has a unique id, a title and a set of keywords. Papers are reviewed by reviewers. Each paper will be reviewed by more than one reviewer, and each reviewer might review several papers. A reviewer gives every paper reviewed a rating. Reviewers have a status property that is based on the number of papers they review. Add constructs, where appropriate, from the EERM: these might include enhanced cardinalities, inheritance relationships, etc. Choose any two entities from your model that are connected via a many to many (m:n) relationship and show how these two entities and the relationship between them would be implemented as SQL tables. Your answer should be in the form of create table statements: you should include as many tables as you need to implement your chosen entities and their relationship. Do NOT give SQL statements to implement any other parts of your model.
Projekt-ID: 9816523

Om projektet

2 forslag
Projekt på afstand
Aktiv 8 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
£23 GBP på 4 dage
0,0 (0 anmeldelser)
0,0
0,0
2 freelancere byder i gennemsnit £37 GBP på dette job
Brug Avatar.
I have 5 yrs of experience in sql development
£50 GBP på 2 dage
4,8 (3 anmeldelser)
2,2
2,2

Om klienten

Flag for UNITED KINGDOM
London, United Kingdom
4,8
4
Betalingsmetode verificeret
Medlem siden dec. 11, 2015

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.