I asked a question similar to this before about designing a database for my WebApp.
This is how it is now.
class_name (Primary Key)
info_id (Primary Key) (This is set to Data Type of Int and as an Identifier)
class_name (Foreign Key to class_name in Classes table)
The problem is that I can't change the name of class_name.
Classes can have many info_dates and notes
One Class can only have one professor, time_start, time_end, days and room.
I want to be able to change the class name.
Not sure how to design it so I can do this. I tried to add another column to Classes called class_id and it the PK. Then I tried to make class_id from Classes be the foreign key to class_id from Info. MS SQL didn't like this.
Not sure what to do.