+1835 731 5494 Email: instantessays65@gmail.com

Database Requirements Analysis


Database Requirements Analysis Introduction: The relational database design process involves identifying the information requirements, identifying the required entities, determining which entities are related, determining the nature of each relationship, normalizing the proposed database, creating a table map, assigning the attributes to each table including the primary and foreign keys, and developing a data dictionary for each of the tables. Work in pairs to complete this exercise. Scenario: John and Joan Worcester manufacture and sell a line of electronic pet feeders. Sales are completed over the Internet, by mail order, and by phone. The feeders can be programmed to dispense a specific amount of food on a regularly programmed schedule. Customers can use the feeder to feed their pets for up to a week while they are away on holiday, or to carefully restrict the quantity of food delivered to their pet for dieting purposes. Each feeder can be plugged in and also has back up batteries so that it is functional even during a power outage. Each feeder is guaranteed to provide trouble-free service for 3 years, and the Worcesters provide free repair services for the feeders throughout the warranty period. The business is growing and Joan and John would like to create a database to keep track of all of the feeders they have sold and the customers who bought them. They also want to keep a record of all of the repairs that have been carried out. Instructions: 1. Identify the entities (tables) that John and Joan will require. 2. Create an ERD that shows how a normalized relational database would be constructed in Access, including any join tables required. 3. Create a table map and add the necessary fields including the required primary and foreign keys. 4. (If assigned by your instructor) Create a data dictionary for each table showing the properties that would be assigned to each field in each table.


There are no reviews yet.

Be the first to review “Database Requirements Analysis”

Your email address will not be published. Required fields are marked *