Requirements and Business Rules

Requirement is something a database has to do.

Data Requirements (what has to be in database)

:

It has to list local venues
(name, address, description , website? Restrictions, capacity)
It has to list acts (artists)
(name, description, genre(s), email, website?)
It has to list show times and show information
(times, date, address, restrictions, price,
admission requirements(cover charge or tickets)
Fan information
(name and email, genres and acts they are interested in)
Login table

Reporting Requirements (have to get out of database)

You must be able to:
Search venues to get lists of coming shows
Search by calendar
By area (neighborhood, city, zipcode)
By Act (name), genre,
By price (including free)
By Age restriction
Search fans who are interested in a particular genre or act
Administrative reports

Access and Security Requirements

Venues can enter and edit their own venue and
show information but they should not be able to edit or enter
for any other venue (login) (insert update)
Fans can register which means they can enter and their own
Info including bands and genres they want to follow
But nothing else (insert and update)
Artists enter and edit their own info/ genres (insert/ update)
Public can select artists, venues and shows

Admin all permission

(wish list)

Business Rules

Venues will be able to enter and edit their information and show information
Acts and fans have same rule
Local consists of defined zip codes
Only (local) artists can register
Venues (local) can list all acts at their venue even if not local
Artist list will be public
Venue list and shows will be public
Fan emails will be private
How long keep records?
Fan, artist (1 year after last show) and venue information
remains as long as accurate

Keys

Unique identifiers for each row primary key
Candidate keys (looking at data to determine which fields
Are potential keys)
Natural key—sconge01
Surrogate—auto-numbers
Composite key 3206 Fall 2013
Foreign Key
Artist

ArtistKey	ArtistName	Email
1	Adarna	adrana@gmail.com

 

GenreKey	ArtistKey	GenreName
1	1	Alternative