Wednesday, October 7, 2015

Requirements and Business Rules

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