I don't know how to design my database. I would like to set up a sistem of storing data about courses that user attended. I already created a user table.
username, password, firstname, lastname, email
Now I don't know how to store users links(bookmarks). I'm considering three variations.
1. To make a table for each user where users courses will be stored
2. To make one table to store courses of all users and just add a field which will show who is the attended the course (who insert it).
3. To make one table for each year (1999, 2000, 2001) and than store data in appropriate table depending on the date when the course was held.
Can you make any suggestions?
Thanks
Blaz
username, password, firstname, lastname, email
Now I don't know how to store users links(bookmarks). I'm considering three variations.
1. To make a table for each user where users courses will be stored
2. To make one table to store courses of all users and just add a field which will show who is the attended the course (who insert it).
3. To make one table for each year (1999, 2000, 2001) and than store data in appropriate table depending on the date when the course was held.
Can you make any suggestions?
Thanks
Blaz