Find Jobs
Hire Freelancers

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

$30-250 USD

Closed
Posted almost 8 years ago

$30-250 USD

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

About the project

25 proposals
Remote project
Active 8 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
25 freelancers are bidding on average $151 USD for this job
User Avatar
Hi I would like to do this project if given the opportunity. Let me know if you are interested so I can start. Thanks.
$50 USD in 1 day
4.9 (105 reviews)
5.6
5.6
User Avatar
I am a Database Developer. I have 5 years of experience working with SQL/MYSQL and Oracle. I am currently working on SQL server 2008 and Oracle10g. I can Develop you ER Diagrams (Crows foot notation), EERD, I can convert them to Rational DB, I can do its Normalization up to 3rd Normal form. I can show you my previous work related to DB. Please see my profile and reviews as well. Thanks
$40 USD in 1 day
4.9 (16 reviews)
5.2
5.2
User Avatar
Hello, I'm ready to work with you on this project , let me know when you want me to start. thanks, hafiz
$277 USD in 3 days
5.0 (7 reviews)
4.8
4.8
User Avatar
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 nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert in SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish-Point5Nyble
$233 USD in 3 days
4.8 (38 reviews)
4.9
4.9
User Avatar
You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.
$250 USD in 5 days
5.0 (8 reviews)
4.2
4.2
User Avatar
I am extremely well versed with SQL Server and will definitely be able to design the database as described. I have worked with SQL Server for more than 15 years and have the necessary experience to design databases that are efficient and relational. I will develop this application using best practices, ie. using Stored Procedures, Views, and normalization where applicable. Please contact me to discuss your requirements further. Looking forward to working with you. Regards, Shayalin
$150 USD in 3 days
5.0 (1 review)
3.5
3.5
User Avatar
I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.
$90 USD in 3 days
4.4 (20 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
$133 USD in 10 days
4.8 (7 reviews)
3.3
3.3
User Avatar
I am oracle certified , SQL and databases expert, can do the task as per your requirement with complete accuracy.
$37 USD in 1 day
4.9 (5 reviews)
2.8
2.8
User Avatar
HI. I AM ENRICO I WOULD BE HAPPY TO WORK ALONG WITH YOU ON THIS PROJECT. MY SKILLS INCLUDE MS ACCESS-DATABASE DESIGN,INCLUDING QUERY WRITING ,MS SQL SERVER ,MS EXCEL AND VBA. LEASE FEEL FREE TO CONTACT ME FOR FURTHER ASSISTANCE . LEAVE ME A MESSAGE,I WILL FOLLOW UP ASAP KIND REGARDS,ENRICO
$70 USD in 3 days
5.0 (3 reviews)
1.8
1.8
User Avatar
Hi, Hope you doing good! Pleasure reviewing your job description, We have expert Database developers. Who has working experience on Ms SQL Server, MySql, Oracle etc. We will provide you best quality of work. We have understood your requirements and we are interested in doing this project. Please checkout our portfolio. We are waiting for your positive response so that we can discuss more about the project.
$170 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi i will this database work for you .I have good reviews and experience in this work On FIVERR and can show samples and profile on demand .Please come in inbox to discuss details.
$90 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Software Engineer with a vast experience in designing complex databases. This, however, is more like an assignment, so it is more than definitely do-able for me.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am SQL Developer and my work is to build and manage database. So I am suitable to your job.
$166 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've 20 years programming and database design experience. I work with SQL Server T-SQL and Oracle SQL and PL/SQL in a regular bases. I design projects by myself from A to Z. Analysis, design, coding, testing and deployment.
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
More than 15 years experience in data modeling and SQL programming. ready to deliver as soon as possible with complete document and support
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have developed many similar systems before and can put together a quality database with all your requirements very quickly. Such a database uses around 60 to 120 tables so I am assuming the purpose of the project is learning. (I have over 12 years experience developing within an educational environment) I will build such a database using only 10 to 20 tables focusing on quality and strict academic principles (such as normalizing) as apposed to optimizing (ex. denormalizing in some cases) and alignment with company strategy and policy. Meeting your stated requirements first and fully, I will (as added value) include full explanations of the academic knowledge applied and processes to follow. Contact me or visit my LinkedIn page so we can discuss your exact needs and how I will provide for them. Your nod of approval is more important to me than the money; don't hesitate to load the project (I have some magic up my sleeves!). I bid low as my references are all face to face business clients and I wish to build on an online presence and reputation.
$40 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$161 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 20 years of experience in MS SQL Server and T-SQL programing and administering. Scripts, Stored Procedures
$155 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Northville, United States
5.0
1
Payment method verified
Member since Mar 26, 2016

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.