Database design (entities, relationships, business rules, ER diagram, sql queries) -- 2

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

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.

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 10 entities 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 10 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.

Database Administration Microsoft MySQL Project Management SQL

Project ID: #10052213

About the project

11 proposals Remote project Active 7 years ago

Awarded to:

it2051229

Hi, I went through the requirements and I would like to do this project if given the opportunity. I can confidently answer all the questions because I am a database developer. Let me know if you are interested so I can More

$50 USD in 1 day
(106 Reviews)
5.6

11 freelancers are bidding on average $76 for this job

point5nyble

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in More

$55 USD in 1 day
(38 Reviews)
4.9
ashupathania

I have 5 years of experience in database development.

$50 USD in 2 days
(22 Reviews)
4.8
mdakteruzzaman

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here More

$55 USD in 1 day
(23 Reviews)
4.9
ref2

Hi I have 15+ years of experience in developing applications on various databases. I have bachelor degree in cs, 25 oracle certified trainings and web app dev certificate from University in Chicago. I will be glad t More

$45 USD in 2 days
(22 Reviews)
4.2
nyarOnyari

Hello, I have read your project description about Database Design and I would appreciate if you can open discussion with me and I see how we can work together. Am a graduate in Computer Science and have already desig More

$30 USD in 1 day
(5 Reviews)
3.3
alramparam

A proposal has not yet been provided

$40 USD in 15 days
(0 Reviews)
0.0
hhdtuan

A proposal has not yet been provided

$50 USD in 1 day
(0 Reviews)
0.0
vw8045995vw

A proposal has not yet been provided

$72 USD in 10 days
(0 Reviews)
0.0