Based on the analysis that the Requirements page summarizes, we recommend creating a database to process all the data and also that will serve as data source for the web site.
Given the fact that the administrator will work from home and that she already has Office 2000 and Macromedia Dreamweaver UltraDev1 on her PC, we recommend creating the database in Access 2000 and that she design the page using ASP language and server model.
The following are the entities of the skelletal user view:
Each RECIPE entity must be sent by one and only only READER.
Each READER may send one or more RECIPES.
Each RECIPE must belong to one and only one CATEGORY.
Each CATEGORY must have one or more RECIPES.
Each READER may send one or more REQUESTS.
Each REQUEST must be send by one and only one READER.
Each READER may send one or more COMMENTS.
Each COMMENT must be send by one and only one READER.
Each READER may send one or more PLACES.
Each PLACE must be send by one and only one READER.
In the following page shows the ER diagram after the 3rd normalization (no non unique identifier is dependent upon non unique identifier attribute), entities and attributes.