Requirements and Business Rules
Here are the notes that we did in class, such as they are
Things the database must do
*Data requirements
*Reporting Requirements
*Security Requirements who will be using the database
what permissions will they need
Some data requirements
Show Dates and times
Venues address city state zip phone webpage name email
Capacity restrictions description handicap access
Act capacity reserved vs open
Restrictions
Contact for venues acts
Customer list subscription to acts or venues
Reporting Requirements
Calendar
View a particular venue and see upcoming shows
View an act and see where they are playing
Query a venue based on restrictions
Security requirements:
Access management--
support
Application—general
Select (read) (CRUD) (except the customer or fan lists)
Insert (put in new records)
Update (change or edit existing records)
Delete (delete records)
Venues—update, insert, select --constraint
only their own data
Customer fan—select insert update only own information
Business rules
How things
Venues have to enter their own schedules
Rule that venues must update weekly
Confirmation email for new customers
No comments:
Post a Comment