Requirements Definition for the Member's database:
The member’s database and software application will include the member’s name, member’s address, member’s phone number and member’s email address. Keep in mind that the member may have more than one type of address, more than one type of phone (home, work, fax and cell numbers) and more than one type of email address.
1. List the other two entities for the member's contact database that were not listed in the lecture. You were given the member and address entities.
~ Member's phone numbers (home, work, fax, cell) and email addresses (personal, work).
2. List the attributes of the 4 entities for the contact database. Remember the member entity was completed in the lecture for you.
| Entity | Attribute |
|---|---|
| Member | ID Number |
| Member | First Name |
| Member | Middle Initial |
| Member | Last Name |
| Home Address | Street Address |
| Home Address | City |
| Home Address | State/Province |
| Home Address | Zip Code |
| Home Address | Country |
| Work Address | Street Address |
| Work Address | City |
| Work Address | State/Province |
| Work Address | Zip Code |
| Work Address | Country |
| Phone | Home |
| Phone | Work |
| Phone | Cellular |
| Phone | Fax |
| Personal email | |
| Work email |
Write a Business Requirements Document for a small project of your choice that contains less than 10 entities. Please include: Project Name, Designer Name, Team Member Titles, Team Member Names, Due Date, Scope Statement and Requirements Definition.
1. List the entities for the project in your Business Requirements Document.
2. List the attributes for the entities in your Business Requirements Document.
Project Name: Wine Stash/Collection Database
Client's Name: Mark W. Kiner
Designer Name: Aileen Kiner
Team Member Name/Title: Aileen Kiner/DBA and Programmer
Due Date: 09 November 2003
Scope Statement: Design a database model to collect wine details needed for organizing wine stash/collection.
Requirements Definition: The wine database will include the name of the wine, wine ID number, winery that produced the wine, country/region/subregion where the wine came from, type of wine (red or white), varietal (cabernet sauvignon, chardonnay, merlot, pinot blanc, zinfandel, etc.), score or rating (between 1 to 100 points), vintage (year) and drink recommendation (drink now or hold).
| Entity | Attribute |
|---|---|
| Wine | Item Number |
| Wine | Wine Name |
| Wine | Winery Name |
| Location | Wine Country |
| Location | Wine Region/Subregion |
| Type | Red or White |
| Type | Varietal |
| Score/Rating | Points (1-100) |
| Vintage | Year |
| Drink Rec | Drink now/hold |
1. What is the role of the database model in database design and development?
~ The role of a database model is to provide a graphical picture of a database structure to managers, users, DBAs, Data Architects, programmers and support team.
2. What is a database?
~ A database is set of tables with the purpose of organizing data logically.
3. What is a relational database?
~ A relational database is a set of tables that are related to one another.
4. What is an entity?
~ An entity is usually a noun, entities are like categories or headings that contain or generalize specifics (attributes).
5. What is an attribute?
~ Attributes are specifics defining the entities.