Welcome to Live Chat

Welcome to LiveWebTutors Services, World's leading Academic solutions provider with Millions of Happy Students.

Call Back
logo

24x7 Support Available

To Get the Best Price Chat With Our Experts

chat now

In A Hurry? Get A Callback

shopping cart 0

Subject Solutions Code Description Price Delete

Amount Payable : $0

continue shopping proceed to checkout

World's Leading Assignment Library

Design a relational database, expressing that design in an entity-relationship diagram. Implement the design in MySQL. Construct SQL queries over the resulting database implementation.

Question Preview:

Design a relational database, expressing that design in an entity-relationship diagram. Implement the design in MySQL. Construct SQL queries over the resulting database implementation. Problem Statement: The organisers of a music festival have asked you to design a database which they can use to provide more efficient administration during the festival. The festival consists of a number of concerts by different artists at different venues. Some venues host more than one concert during the festival. Some popular artists are scheduled to appear at multiple concerts, whilst most concer...

View Complete Question >>

Question Preview:

Design a relational database, expressing that design in an entity-relationship diagram. Implement the design in MySQL. Construct SQL queries over the resulting database implementation. Problem Statement: The organisers of a music festival have asked you to design a database which they can use to provide more efficient administration during the festival. The festival consists of a number of concerts by different artists at different venues. Some venues host more than one concert during the festival. Some popular artists are scheduled to appear at multiple concerts, whilst most concerts feature multiple artists appearing. Customers have to book tickets for concerts in advance. There are no limits on the number of concerts a customer may attend. If a customer wishes to buy many tickets for one concert the organisers only need to know the details of the customer who is actually making the booking. The organisers need to store basic contact details for customers. For artists, basic contact details are required, a brief biography and the name and contact details for their booking agent. Note – a booking agent is a person or company which represents an artist and handles the administration surrounding booking that artist to appear at concerts. One agent might represent multiple artists. For each venue basic contact details, the venue’s seating capacity and the telephone number of the venue manger are required. Finally, the organisers would like you to include some information about each concert - the date, start time, venue and the number of tickets sold so far. Each concert also has a unique reference number (starting at 1) which is used in the festival programme. Tasks: 1)Draw an entity-relationship diagram for the above scenario. You must explain any assumptions that you make during the design process. (20 marks). 2)Implement your design in MySQL. Populate your database tables with data of your choice. However, you should ensure there is a venue with the name ‘Civic Centre’ to enable you to answer part 3c below. If you make any changes to your original design from Task 1, these must be explained. NB: Remember to include the SQL statements you used to create your tables in your answer document. If you do not do this you will not gain the marks for this section (10 marks). 3)Construct SQL queries for the following (16 marks). In ALL cases, include screenshots showing the results of your queries – instructions on how to do this are given at the end of this document. a.List the name and seating capacity of all venues starting with the largest. b.List the names of all customers booked to see concert number 2. c.List the number of artists represented by each booking agent. d.List the names of all artists who appear in a concert at the Civic Centre. 4)Explain how you could find out how many tickets for concert 1 remain unsold. Give the SQL for any queries you would need to execute (4 marks). What to submit: A single Word or PDF document containing your answers to the above tasks. You should submit your work electronically through r. Producing Screenshots: Pressing the “Print Screen” key on your computer keyboard takes an image of what’s on your computer screen at the present time. You can then go to your answer document and paste this image in. Notes: If you press “Print Screen” again without pasting, the new image taken over-writes the previous one. If you have the Linux.cs command line (or the MySQL query browser) in focus, if you press the “ALT” key at the same time as the “Print Screen” key then the computer will only take an image of the current window that is in focus. Mac users see: http://guides.macrumors.com/Taking_Screenshots_in_Mac_OS_X One possible drawing tool you can use to create your ER diagram is https://www.draw.io/. This will create a PNG image.

View Less >>

Solution Preview

Music Festival chosen

question Get solution

$30

Orginal Price : $39.0

Pay Now

Upload Assignments

250 words

side

Get Your Assignment

Don’t delay more, place your order now. Quick assignment help will be offered to you.

Order Now

CUSTOMER REVIEWS

Excellent

logo

Based on 702 reviews See all reviews here

One of the Best Service

I trust LiveWebTutors for my assignments because of their ability to deliver the perfect assignments time and again. Only a few of my assignments required minor revisions. The rest assured it is the best assignment writing service in the market.

Elizabeth
Sydney

Great Service and on time

I felt so exhausted and burdened with the large number of assignments I had to write and desperately needed someone to help me with all the writing and there was LiveWebTutors company on the internet. They finished my assignments before the due date and also offered me a first-timer discount.

Christina
Perth

One of the Best Assignment Provider

I ordered my Mathematics and Marketing assignments from them last month. I received the content on the set date. Most importantly, the assignments were well-written and plagiarism free. I scored a top grade for the assignment written by them. They are a reliable company.

Oli
Brisbane

Very Helpful Customer Service

I was quite unsure about getting my assignment written online but after coming across LiveWebTutors.com, all my worries have vanished. The quality of the assignments written by their writers is just invincible. Their customer support is very polite and helpful. You should try their service at least once

Kabir
Adelaide