Am I doing things right...

[Carola]

My dad thought i was "smart enough" to make the database for his company and cooperating companies.. but i have never used access in my life. I have to be done by the end of the week and i have absolutely no idea what im doing. I followed youtube tutorials but that doesnt give me any confirmation as to whether im doing it right.. So can anyone tell me if this looks ok or just horrible haha thankss
i1232.photobucket(.)com/albums/ff364/carolabrus/818a905d-dc04-4ff4-9824-573fbe0c6486.jpg[/url]

 

[plog]

No, its not right. For one, you aren't using your primary key fields to link tables.

Example: Company_People is linked to People via the UserName field. It should be joined via PersonId.

Also, this seems wrong, but I don't know if it is: Can companies be more than one type and in more than one country? The way you have it set up, it appears so. What's really odd is that you have a City field in Company, but you've broken out the Country into a new table which implies it can be in more than one country.

The last big thing I see is all those tables shooting off of People. Most likely those can all be condensed into one table called 'Roles'. I would have to see some data from each and get an explanation to be sure, but that's what it looks like so far.