-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Developing an SQL Database for a Local Recreation Business
Question
Task
Members of a small town in Tennessee are tired of having nothing to do on the weekend. They want to start a local club where people can pay a monthly fee to be a member and participate in various activities. Activities will be offered for 3 basic age groups: 12-18 years old, 19-55 years old, 56 and older. The club will have a short order grill for sandwiches and salads, a bar that operates late afternoons and evenings, basketball court, tennis courts, shuffle board, climbing wall, large TV/movie room with a flat screen TV, and a computer game room with a LAN setup and several smaller TV's and game consoles and a weight room. A few years down the road, they plan to add a swimming pool and an outdoor track.
When a person joins, he/she gets a badge with a unique member number that serves as an ID which can be swiped to get into the club, to participate in activities and to use as a charge card while at the club (to pay for meals or other incidentals).
Assumption: you can assume that each time a card is swiped, the following data will be available from the card swipe system to store into one or more tables in a database:
- member name
- member ID
- date
- time
- activity (example: enter club, purchase sandwich, computer game room, climbing wall, purchase beer)
You do not have to be concerned with how the data gets into the system. Just concentrate on the design of the system and what data needs to be stored.
Certain activities will be restricted by age:
12-18 year olds are not allowed in the bar or the weight room
56 and older are not allowed in the computer game room
The club needs you to design a database to help them manage the business. Some of the things they need to keep track of are memberships, club dues, activities that members participate in, time of day/night that members visit, operating costs for the club (bills paid out, dues coming in, taxes etc), general information about the club (ownership, hours, address, etc),
Project Requirements
Complete the following tasks:
1) Using the description above, design a database for the club.
2) Generate an E-R diagram for the database. - use at least 4 entities. each entity must have at least 3 attributes
3) Diagram the relationships between the entities, including the name, optionality and degree ---- include all the E-R diagrams and relationships in one document ----
4) Ensure that your database is in 2nd normal form and that all the tables follow the rules of referential integrity and entity integrity.
Summary
The question belongs to Computer Science and it is about creating a database in SQL for a recreation based organization in a small town. The database must include tables and queries which record and retrieve the information on how customers spend their time in the club and how much they are spending on. The ER diagram and the basic coding for SQL has been given in the solution.
Total Word Count 767
WHAT OUR STUDENTS SAY
It is important to have a constant guide while you do your dissertation as the lack of constant help often leaves you all the more bewildered. The New Zealand dissertation expert who helped me with my assignment was available on a constant basis and she helped me get a fantastic grade.
Jonathan White Student
Our professors were piling up one assignment after the other and the pressure was too much to bear. I was thinking of how to tackle the situation when one of my friends suggested this website. I sceptical at the beginning and thought they will flunk me in the assignment. Honestly I was too scared but had no choice as I was dealing with like 10 assignments in a week. However, to my pleasant surprise I got brilliant feedback from my professor. He also had posed a certain query and that too was answered by the electronics engineering assignment expert from HwA.
Lynne Davidson Student
I never expected that I could make so many grammatical errors in my college application essay. Thankfully, I took advice from HwA before submitting the same for my college admission. I got through smooth and since then take their service.
Matt Bullen Student
Was partying late night and forgot about my biotechnology assignment which was about to submit in 5 hours. Then approached several service providers but they refused to take up the assignment. Finally TheReliableTutor.com saved me. Submitted the assignment on time..!!!
Jordan Student
1. In-depth research, logical and methodical progression of writing and structured context makes each and every writing assignment help that I have received from the online writing tutors at TheReliableTutor.com truly a masterpiece. My grades have improved and I am much more confident of myself now.
Daisy Clare Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.