01-16-2008, 12:34 PM
|
#8 (permalink)
|
|
The Wanderer
Join Date: Jan 2008
Posts: 13
Thanks: 0
|
Quote:
Originally Posted by CoryMathews
Is there a way to join these tables, are the linked at all (ie any foreign keys)?
|
No there isn't.
Quote:
Originally Posted by Salathe
You've already said that your tables have been normalised (3NF) but I think your table structure could really do with being improved before moving forward. What do you expect to happen when a student and admin have the same id number (they're in different tables, so it can happen) and the same password (unlikely but again, it can happen). The admin tries to log in but gets logged into the student's account!
|
Maybe my example was wrong, but I already covert what you said. Cause students have a so called ovnummer on our school. It's there reversed birthday + a 2 digit number on the end. And they login with that number, a admin logins with the first letter of his/her first name + lastname, and a company logs in with company id. I can upload my excel file, but it's dutch so I don't know if it's has any value then. |
|
|
|