Skip to content

Latest commit

 

History

History
22 lines (15 loc) · 816 Bytes

File metadata and controls

22 lines (15 loc) · 816 Bytes

#This Sql Application is created for managing event and tickets for event management company

Entity_and_Attributes.txt -->to know about Entity , Attribute and releationship

ER-diagram.png file --> Entity-Relationship model

Create all tables using ddl.sql file

Create all Functions from Functions folder

Create all Procedure from Procedure folder

Run SELECT "eventManagement"."sampleData"() function to load sample data

Create below views from View folder which will answer below questions- 1.Get the number of available tickets per each possible sales company AvailableTcktsPerReseller.sql 2.Provide stats for each organizer to explain which resellers are doing the best work resellerPerformance.sql 3.Commissioning report for each reseller per month and event CommisionPerEvent.sql CommisionPerMonth.sql