Find Jobs
Hire Freelancers

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.
Project ID: 5460980

About the project

4 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Assignment of university hah :) I would love to do it for you :) I got A+ in my subject :) If you like to discuss feel free to contact
$55 USD in 1 day
5.0 (7 reviews)
3.9
3.9
4 freelancers are bidding on average $151 USD for this job
User Avatar
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?
$111 USD in 3 days
5.0 (17 reviews)
4.9
4.9
User Avatar
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
$250 USD in 3 days
4.2 (1 review)
3.5
3.5
User Avatar
Aucune proposition n'a encore été fournie.
$188 USD in 9 days
5.0 (3 reviews)
3.3
3.3

About the client

Flag of UNITED STATES
Leeds, United States
5.0
24
Member since Jul 9, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.