1. Mission Statement 2. Mission Objectives 3. Final Table List 4. Table Structures (Tables with fields associated with them, keys and alternate keys) 5. Write 4 field specifications (Your pick, you only have to write 4) ? Check BB for the Field Specification Sheet. ? Major fields are primary keys/foreign keys/ones that require restrictions, etc 6. Elicit 4 business rules (Your pick, you only have to write 4); at least one of them should be relationship-specific ? Check BB for the Business Rule Specification Sheet 7. The ER diagram including all tables, fields, relationships, type of participation, degree of participation, deletion rules, and validation tables
Assume you are in charge of designing the logical database for a website which helps customers find restaurants and cafes. The website allows customers to review these places as well as read other people's reviews. You have interviewed the website owner and collected a sample for presenting the data (Figures 1) Interview You: Can you tell me why you believe you need a database? Participant: I think we need a database to keep track of all the reviews which people give about restaurants and cafes. You: 'm sure the database will address these issues. Now, what would you say are the most important functions of your system? Participant: This system will contain the profiles of businesses (cafes and restaurants). The profile will contain information about the business name, location, hours, and contact info. People should be able to find such businesses based on many filters such as location, Wi-F availability, parking availability, etc. People can also read existing reviews or review businesses based on their experience with the business. You: Are all reviews submitted by people posted online? Participant: No, we have moderators who either approve or reject reviews. Only when approved, reviews get published You: Any additional requirements? Participant: We need to allow business owners to add tags to their businesses that allow people find their businesses efficiently. For instance, business may add tags that describe their business such as "Mediterranean food", "cozy", "espresso", etc Assume you are in charge of designing the logical database for a website which helps customers find restaurants and cafes. The website allows customers to review these places as well as read other people's reviews. You have interviewed the website owner and collected a sample for presenting the data (Figures 1) Interview You: Can you tell me why you believe you need a database? Participant: I think we need a database to keep track of all the reviews which people give about restaurants and cafes. You: 'm sure the database will address these issues. Now, what would you say are the most important functions of your system? Participant: This system will contain the profiles of businesses (cafes and restaurants). The profile will contain information about the business name, location, hours, and contact info. People should be able to find such businesses based on many filters such as location, Wi-F availability, parking availability, etc. People can also read existing reviews or review businesses based on their experience with the business. You: Are all reviews submitted by people posted online? Participant: No, we have moderators who either approve or reject reviews. Only when approved, reviews get published You: Any additional requirements? Participant: We need to allow business owners to add tags to their businesses that allow people find their businesses efficiently. For instance, business may add tags that describe their business such as "Mediterranean food", "cozy", "espresso", etc
