Evaluation
The task includes the development of a database design for a dating/match-making service. Your deliverables will be a listing of table names, field names and descriptions, and a database design diagram. Use Microsoft Word, Visio, Excel or other to create a diagram. You may print to PDF or an image file or submit the original Word, Visio or Excel file.
Your grade will be calculated in the following manner:
1. Tables (30%)- Your design must consist of at least five tables. You must provide a description of the table and what data it contains.
For example, you can create tables such as, Client_Info, Hobby_Info, Food_Info, Education_Info, State_Info, Country_Info, and Career_Info tables, etc. (Do you see where this is going?)
Description: Client_Info contains client information, including name, and codes for favorite hobbies, favorite foods, highest degree, etc.
2. Fields (30%) - Each table must have at least two data fields; some will have more. Provide a description each field. Remember: this is a dating database so your fields should be similar to the suggested fields on the introduction page.
For example, the Education_Info table would contain: Educ_Code, Educ_Desc.
Description: Educ_Code is an identification code. Educ_Desc is the text that describes the degree, such as B.S., M.B.A., M.Ed.
3. Relationships (40%) - Form relationships between the tables. Identify which fields are to be used to form the relationship.
For example, Client_Info contains client degrees earned (Degree_1, Degree_2). Degree_1, and Degree_2 would be the fields that would relate, or match, to the Educ_Code field from the Education_Info table.
See diagram below:
