Issue with relating a 4 table database

[jmorgan_mpe@yahoo.com]

Hi everyone, I have to create a 4 table database for my MIS class. I've made 4 tables: City_Info, Graduate_Schools, Graduate_Degrees, Employers.


My intention is to relate the tables in a way that an individual soon to graduate from college can query for a city he/she might like to live in based on numerous factors. Each table contains relevant info pertaining to the subject of the table(population, job outlook for degrees, grad school ratings, employers' industry, etc). However, now that I have all the information together, I don't understand how I'm going to set up my relationships to make queries work. I've never done this before and would appreciate any advice. I can provide more information if necessary. Thanks.

[orange]

I am attaching links to free videos to help with database design concepts with examples. It is difficult (rare) to start by saying I'm going to have a 4 table database. Forget the number. Identify the things that are within the scope of your project....

I think these videos should be helpful.

Here are a number of free video tutorials related to database design concepts.

These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

The first few topics at this site are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck with your project.