Database design (entities, relationships, business rules, ER diagram, sql queries)
$30-250 USD
Completed
Posted about 10 years ago
$30-250 USD
Paid on delivery
See bottom of post for project deliverables (MS Visio/Word formats + simple sql script)
Varsity Bowling Inc. that houses bowling alleys for the recreation of its customers plans to create a
software application to manage its operations. You are entrusted with the task of designing and
implementing the database components of this application. Implementation of the database should be
done in SQL Server. Basic descriptions of operations are given in the paragraph below. You are also
urged to visit websites of popular local bowling alleys to find the kind of services offered in bowling
facilities. You can come up with additional/alter these descriptions based on your requirements.
Following descriptions of the Varsity Bowling operations is given for illustrative purpose only.
Description of Varsity Bowling Operations:
Varsity Bowling hosts multiple bowling lanes in its facility. The business also has a small cafeteria where
it offers popular eating options such as pizzas, burgers, hot dogs, beverage drinks etc. While both
members and non-members could rent the bowling lanes, it offers discounted pricing to members, both
for the lane rentals and at the cafeteria. While walk-in rentals are allowed subject to availability,
customers could do advance booking through phone. Lanes are rented on an hourly basis. You may
assume that the rental rates do not vary between different days/hours (peak vs. non-peak). Customer could
pay for the rental using cash, check or credit card.
Project Deliverables:
List of Entities: At least 9 entities should be identified including any associative entities identified for
resolving M:N relationships
Business Rules: Rules that involve the above mentioned entities
ER Diagram: This diagram should resolve all M: N relationships. This should clearly identify the major
attributes of various entity sets along with Primary/Foreign keys. Show appropriate connectivity. Use MS
Visio for creating ERD.
Implementation in SQL Server: Create tables and Insert at least five rows into each of the created tables
using SQL statements (You can make up the data).Turn in the SQL script used both for creating tables
and adding data.
SQL Queries: At least 8 queries using joins (involving at least two tables in each query and three tables in
three of the queries), aggregate functions, “group by” functions etc. should be turned in along with
screenshot printout of your results.
All deliverables should be in MS Visio or MS word format.
DATABASE EXPERT... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quick... Check my badge SQL Level3... there are only 4 on Freelancer... I love db theory... This is some student task?
My name is Andy Armstrong and I am 26 years old. I have a degree in Computer Science from the University of St Andrews and am highly capable in programming applications in PHP, Java, IOS, Android, ASP etc.
I believe the difference between myself and other bidders is my ability to communicate clearly and that coupled with my strong technical skills makes me a strong bidder.
I hope to start work on this project today.
Kind regards,
Andy