Skip to content

JoeFriday/B2B-Transactional-Ticketing-Database-Design-using-MySQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 

Repository files navigation

In this task, I designed a reporting system that will help decision-makers track business results by venue organizers and resellers and analyze the needs of selling event tickets.

Resellers get a fixed commission per sold ticket based on different events. Resellers can have multiple branches offices or sell on their websites, while venue organizers can sell on-site or online. Customers can buy tickets from a reseller or a venue organizer.

Defined a relational database

Uploading Screen Shot 2021-10-03 at 3.51.06 PM.png…

Inserted sample data for the relational database

Reporting requirements:

Compare sales results by weeks and by channels.

Comparison if the commission rate is in relation to sales results.

Analyze most popular tickets per offices, resellers.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published