Read this scenario:
Patti and Dennis like to follow local bands. They often miss concerts because they only hear about them after the event. Typically, the only advertisement of an upcoming performance for some of these artists is a paper bill tacked to a street lamp or pasted on the side of a building.
Sometimes there will be ads in the free community papers, but there is no one place to locate the information. Many of their friends share similar frustrations. It is impossible to have a clear idea of who is playing where at any given time.
Patti and Dennis came up with the idea of a database that would store all of the information about artists and shows in one place. Ultimately they would build a Web page based on the database that everyone could access and use. They started by pedaling their idea to some of the more popular venues. The venues expressed interest. For the most part, they liked the idea of a central place where people could get a complete picture of the current music scene. It could result in more customers. Some even inquired about advertising opportunities.
Patti and Dennis also talked to some artists they knew. The artists also thought it was a good idea. They knew the hand bills were not very effective, though some of them liked the artistic effort of designing them. Another idea they had was that fans could register and select which artists or genres of music they liked and be informed of upcoming shows.
Encouraged by the response, Patti and Dennis are looking for someone to help design the database.
1. Make a list of questions that you would ask about these forms and reports.
2. Identify the stakeholders for your selected scenario
3. Create a plan for an hour long interview with representatives of these stakeholders. Then meet with the instructor to discuss possible answers to the questions.
4. Create a questionnaire of at least five questions for the managers.
5. Make a list of issues with the current system.
6. Make a list of the database requirements for each stakeholder involved in the database.
7. Make a list of business rules.
8. List some major security rules for the database.
9. Make a list of all the nouns in them. Do the same for the interview, the questionnaire. Set up some preliminary entities and attributes.
10. Identify some candidate keys.
11. Documentation: Store the list of the requirements and business rules in your database notebook.