You are asked by the organisers of the Conference on Web and Internet Economics (WINE), to design…

You are asked by the organisers of the Conference on Web and Internet Economics (WINE), to design a database that captures as many requirements as possible. The Conference on Web and Internet Economics (WINE, formerly Workshop on Internet and Network Economics) is an interdisciplinary forum for the exchange of ideas and results on incentives and computation arising from these various fields. Invited speakers of previous WINEs include not only many famous theorists from prestigious universities in the world, but also top researchers from many big businesses, such as Microsoft Research, Yahoo! Research, IBM Research, Google Inc., ebay Research Labs and so on. Participants of WINEs come from universities and industries as well. The organisers anticipate several hundred papers to be submitted for the conference. All the submissions are to be reviewed by referees and, due to the length of the conference, no more than 100 of the submitted papers are to be accepted. Each paper that is submitted will be classified into one of the conference topics. WINE19 will last for 4 days, during which 8 topics (e.g., “Mechanism Design”) will be discussed in two parallel streams. The conference sessions will be held in 2 large lecture theatres, with each session lasting a maximum of 2 hours and being dedicated to one of the topics; each topic takes 4 sessions (one per day). Therefore, each day there will be 4 sessions at each lecture theatre, summing up to 8 sessions per day (one for each topic). Each paper is presented in exactly one session during a 20-minute slot followed by 5 minutes of questions. The chair of the Programme Committee appoints the Senior Programme Committee (SPC’s) members. Every SPC must be an authority in at least one of the conference topics and is solely responsible for reviewing all submissions within his or her topics of expertise. Normally an SPC handles several submitted papers and assigns each paper to three referees. It is the organisers intention that at most 16 papers per topic will be accepted. Several hundreds participants are expected to attend the conference. Each participant typically plans to attend some of the sessions of their interest and may also present their own accepted papers, if they have any. When enrolling, every participant is required to provide some personal data (e.g., title, name, affiliation, address, etc.) and state which session(s) they wish to register for; this is required for calculating the individual fee for every single participant. The standard single session fee is £30. The following discount scheme will apply: 20% reduction for all participants with papers accepted, 30% for participants who actually present their papers at the conference and 40% for the session chairperson. Every participant can register for as many sessions as they wish, provided the selected sessions do not clash. The required database is to hold all the relevant data about the organization of the conference, including information about participants, the sessions they registered for etc. The necessary details about all the papers which are accepted for presentation (together with their session allocations) are also to be stored. The basic function of the database is to provide information on the conference programme and registration status of the participants.

Task : A database designer that possibly didn’t know how to create a proper Conceptual Data Model using Entity-Relationship modelling, created a large relation schema to store all the data associated with the registration information of participants to sessions, together with information about the accepted papers that are to be presented in a session (e.g. who was the SPC that handled a particular paper etc). The relation has the following schema:

ConferenceData (participantID, participantName, participantAddress, sessionLocation, sessionDate, sessionStartingTime, sessionDuration, topicID, topicName, paperID, paperTitle, SPCID, SPCName)

You are required to decompose, using the formal process of normalisation, the ConferenceData table into relations which are in 3rd normal form. In the absence of any data you may assume that the table is flattened. You are not supposed to add any further attribute, like authors or presenters of the papers. You should present your work logically providing details about the result of each stage of the normalisation process with clear annotations and explanations.

Note • Note that the problem description, discusses a much more general scenario, so some of the information that is described there, might not be useful for your task. However, the scenario will be useful for identifying the functional dependencies.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Online Academic Experts
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Thank you. No issues
Customer 453139, April 17th, 2022
English 101
Thank you for this excellent analysis of the Alchemist.
Customer 453213, June 15th, 2022
The writer was timely and proficient. I had to ask for a revision, but I got it back quickly with no other issues. Would use this essay writing service again
Customer 452441, November 14th, 2021
Emergency Management
Overall, I think it's a great service. I have yet to submit the assignment, so I don't know what kind of grade I'll get. But customer service was excellent. Reviews were made and the assignment proofed for satisfaction.
Customer 453015, December 15th, 2021
Health Care
awesome work
Customer 452777, October 14th, 2021
Human Resources Management (HRM)
Very well written and very impressed with this service!
Customer 453077, February 16th, 2022
Business Studies
Paper is great. Just only needed the one reference. Thank you
Customer 453139, May 4th, 2022
Human Resources Management (HRM)
I finished the first deliverable of a project presentation but had no time to finish my second deliverable. The writer revamped my first deliverable and made it much more appealing! Not only was I impressed with the content but I was so grateful for the time they took to redo the background. I have been under a lot of pressure at work and at home so this has been a great service when I have had little time! I appreciate the detail and help! Always on time and always exceeding expectations!
Customer 453077, April 5th, 2022
quick, fast and exact!
Customer 453027, May 24th, 2022
Professions and Applied Sciences
Thanks. This helps a lot. Was a bit late but some cushion was given.
Customer 453015, February 10th, 2022
Business Studies
Thank you very much for a good job done and a quick turn around time.
Customer 452615, March 31st, 2021
Love this writer!!! Great work
Customer 452597, April 5th, 2021
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp