Create table1 with UID, last name and telephone
create a uniqur index on UID
Create table 2 with OSID and OSName. It will have rows that look like
OSID OSName
1 Windows
2 Linux
3 mac
create a unique index on OSID
Create table3 that has MID, UID and OSID
They have foreign keys point to UID and OSID
Discuss This Question: 5  Replies