Find Jobs
Hire Freelancers

Database Design For Online Ticket Purchase

$30-250 USD

Closed
Posted over 8 years ago

$30-250 USD

Paid on delivery
Hellow Freelancers, I need help with Database design of my application. Database should be in MS SQL Server. See the attached design of what i have done so far and read the below for clarity 1. When user purchase tickets they must provide their cell number 2. User can purchase ticket on his friends behalf and reference numbers must be sent to friends mobile number. 3. The are three ticket categories (Regular, VIP, VVIP) 4. Event attended will produce ref numbers(will be sent to them by SMS) to be admitted on the event. 5. Each event will have tickets limited. No overselling of tickets. Eg event will admin 100 people and ticket can be grouped as 30 VIP 20 VVIP 50 Regular Each ticket category has it own pricing 6. Payment will be done via credit card using 3rd party gateway 7. The buyer must create profile before making any purchases and we will be awarding frequent buyers will loyalty points 8. Buyer can buy more than one ticket( i think we need to have a cart)... 9. The staff details table is for staff that will be at the gate on the event admiting attendees. They will have 3 levels 1. Normal user (can only admit ticket) 2. Manager (can refund ticket) 3. Admin(create tickets) This database will be used on the application and will like to see stored procedures or you tell me how we can develop a quality database. Each event houses around 100 000 people
Project ID: 8069252

About the project

29 proposals
Remote project
Active 9 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
29 freelancers are bidding on average $266 USD for this job
User Avatar
Hello, I have read your requirements and also reviewed database design you had made till now. As I have 5+ years of experience and I have did similar works and made database design for many projects. As database design is very important part of applications and I know all facts while design database. As I am design similar database like your was online Cinema tickets reservation and in that all information was similar to your once and have many similar steps. As I see we have to add temp booking table where we can do reserve for few minutes while user will do payment so won't get sale twice. I can do database design for you and can deliver in time with very good quality. Please let me know if you need anymore information from me. Please let me do this task for you. Looking forward to hear good from you. Thanks.
$200 USD in 5 days
4.9 (67 reviews)
6.4
6.4
User Avatar
Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan
$200 USD in 3 days
4.9 (32 reviews)
5.5
5.5
User Avatar
Hello, I have reviewed your requirement fully and I have good working experience in such type of application in which we will have single database and multiple systems like desktop/window application, web application and mobile application to push/pull data from database. Please send me message, so that we can converse further about this. Best Regards,
$350 USD in 3 days
5.0 (10 reviews)
5.2
5.2
User Avatar
Hi, I am 16+ years experienced oracle Certified Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant, Database Migration Assistant, OEM, SQL/Oracle Trace, EXP/IMP, SQL*Loader. Can you please share your requirement document? Let me know when can we discuss.
$250 USD in 3 days
4.8 (13 reviews)
4.7
4.7
User Avatar
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in SQL SERVER 2008 , i have more than 8 years in IT projects with 6 years working around SQL server database development , administration and BI. My last job was Microsoft SQL Server administration and BI Expert.I worked on several projects relating with SQL Server on behalf of European Customers (Carrefour, LOREAL,Eurovia). I have all the mastery of SQL Server on administration and development and all the skills needed to give you high quality of work withing budget and time. I have the following certifications. Certified Microsoft MCSA: Implementing a Data Warehouse with Microsoft SQL Server 2012 Certified Microsoft MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Certified Microsoft MCSA : Administering Microsoft SQL Server 2012 Databases. Best regards,
$277 USD in 3 days
4.8 (4 reviews)
4.0
4.0
User Avatar
Hello Sir/Madam I have solid experience as Oracle, SQL Server, Sybase, Access DBA. I am SQL server certified DBA in both as DBA and Designer. I worked as DBA in USA for 13 years. I came back recently to start my own work. I have a number of excellent reference as DBA, Architect and Modeler. We have done similar work for a projects using these skills java, Web design, CSS, HTML, HTML5, Jscript and PHP. Please take a look at my resume and you will find that I am the best fit for this job. I have just completed couple of projects on database and the clients were from Australia, Canada, GB, USA and Russia. Currently I am working on a USA project Please see the review. Appreciate your kind attention in this regard, Warm regards,
$201 USD in 7 days
4.8 (7 reviews)
3.3
3.3
User Avatar
A proposal has not yet been provided
$88 USD in 3 days
4.7 (4 reviews)
2.7
2.7
User Avatar
Hi, Greeting! Sir i can understand that you are looking for database management for your event management website, I am here to solve your query efficiently, We can manage all the data that you have suggested in the project description. -May i have current link of your running website ? -Which type of event you are handling ? -Total ticket are 100 000 right ? -Do you have cart for purchasing orders/tickets ? Waiting for your precious response. *Placed bid is not final one, It is negotiable. Regards, Avtar.
$927 USD in 12 days
5.0 (1 review)
1.6
1.6
User Avatar
As a data architect and with more than 11 years of industrial experience in database development I should be able to deliver the model and script in the mentioned time and with quality
$222 USD in 3 days
5.0 (1 review)
1.0
1.0
User Avatar
A proposal has not yet been provided
$250 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like you to specify the task. Do you need me to create the database structure only ? You mentioned stored procedures. What functions should they perform ?
$222 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
1- Any project should be developed with proper road map. 2- For this project first of all, it needs to analyse briefly what are the basic needs for your application and that will be done only after discussions which will be done through online Video/Audio conferencing that will need exchange of few mails with sign-off of proper requirement is being understood and confirmed. 3- I am a Team lead in Database development in a reputed financial domain company and having 8+ years of experience, in which 7+ is in database development.
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm new on freelancer but I have 6 years exp. on database designing.
$278 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Experiencia en lenguaje SQL de MSSQL con querys , vistas , stored procedures, triggers de sistema contable, sistema de inventarios y sistema ERP
$277 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have delivered several projects with the Data base modeling along with the DB schema as well as with the good design approaches.
$224 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$300 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am interested to work in your project. I have more than 10 years of experience in software development. I have developed many projects for manufacturing industry using VB.net, C#.net & SQL server2014.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
The first most important thing to develop a quality database is for the schema to be correct so you're taking the right first step by getting second opinions. Database should be normalised to 3rd normal form using EF CODD principles of database normalisation. To ensure integrity of the data, key constraints should be added where necessary to ensure data remains intact. With 100000 users for any one event, performance must be a consideration otherwise it will be slow. Additional indexes may need to be added later to speed up performance. Looking at your design, the TicketHolders doesn't look right. HolderCellNumber can be stored in the IssuedTickets table as their will only be 1 Holder cell number for an Issued Ticket. You can derive the Qty of tickets from the total number of records against the IdNum so no need to store it. The self join to the cart table also doesn't make sense. The Cart table does not need to store Total as this is derived from the Sum of the LineTotal in the CartItems table for that Cart (CartId). There is more - I can help make your schema perfect.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've been working on sql development for very long time. As I've made many project by myself and did all the client interaction so I am pretty good at making databases according to the requirement and this is my first online freelancing work so I not charging a big amount coz all I need is customer satisfaction so that I can get more work.
$55 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
RICHARDS BAY, South Africa
4.7
10
Payment method verified
Member since Nov 7, 2014

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.