Bus Ticketing and Management System Technology

Comments

Rules:
1. One admin can manage one or many tickets.
2. One ticket may be managed by one or many admins.
3. Each passenger can pay for one or more tickets.
4. Each ticket should have one or many seats.
5. Each seat may have zero or many tickets.
6. Each route has many tickets.
7. One bus should have 40 seats.
8. One or many buses may travel in one route.
9. One driver will drive in one route.
10. Each route has a different price.


Data Manipulation with SQL:
i. At least one aggregate function (count, max, min, avg, sum)
ii. At least one query with a group by and having clauses
iii. Triggers
iv. Stored procedure
v. View
vi. Use of subqueries/nested queries
vii. At least four queries not covered in lecture such as display the 
top n records, auto increment by 1 for every new row inserted, 
etc.
Description  

Rules: 1. One admin can manage one or many tickets. 2. One ticket may be managed by one or many admins. 3. Each passenger can pay for one or more tickets. 4. Each ticket should have one or many seats. 5. Each seat may have zero or many tickets. 6. Each route has many tickets. 7. One bus should have 40 seats. 8. One or many buses may travel in one route. 9. One driver will drive in one route. 10. Each route has a different price. Data Manipulation with SQL: i. At least one aggregate function (count, max, min, avg, sum) ii. At least one query with a group by and having clauses iii. Triggers iv. Stored procedure v. View vi. Use of subqueries/nested queries vii. At least four queries not covered in lecture such as display the top n records, auto increment by 1 for every new row inserted, etc.

Skills, Technologies or Software
DB2
Teammates