Find Jobs
Hire Freelancers

Create an EERM

£10-20 GBP

Completed
Posted about 8 years ago

£10-20 GBP

Paid on delivery
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.
Project ID: 9816523

About the project

2 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
£23 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
2 freelancers are bidding on average £37 GBP for this job
User Avatar
I have 5 yrs of experience in sql development
£50 GBP in 2 days
4.8 (3 reviews)
2.2
2.2

About the client

Flag of UNITED KINGDOM
London, United Kingdom
4.8
4
Payment method verified
Member since Dec 11, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.