Based on what you said about being able to recover from bad deletes and updates, my recommendation would be to setup the tables for System-Versioned Temporal Tables.  That means that...

A bit over the top, I'd say.  I asked only for the CREATE TABLE statements for the Achievements and Achievements_Audit tables but thank you for posting all of it because...

• This reply was modified 4 years ago by  thetubageek.

OK, let me start by answering your questions/concerns:

• The Trigger methodology I am using is what wasa showed to me. I figured it would be good for a "first try"...

• This reply was modified 4 years ago by  thetubageek.

Yeah, I discovered that myself. Again, somehow I was able to make it work.

My new issue as that I have Triggers set up and I have certain columns configured as...

• This reply was modified 4 years ago by  thetubageek.
• This reply was modified 4 years ago by  thetubageek.
• This reply was modified 4 years ago by  thetubageek.

Somehow I was able to get this to work. I may have some other issues, though RE: my triggers. I will provide all the code as well as the errors...

You said - it. Users are people.

Students? Most likely, they are people too. At least most of them.

So, you must have a table "Person".

Student and User tables contain PersonID plus...

From those tables I cannot figure out - how can a user participate in more than 1 team? Is it considered an impossible situation?

Users are people who are logging into...

May I ask about the alternative approach?  Is it more of a document model?

This project is part of a 12-week long class. The Development Team for this project advised they...

OK, it turns out that after meeting with the Development Team, this was a much more complex table design than originally needed. So, I don't need any of this, after...

OK, I obviously need to provide some additional context:

This database is meant for a website that will show what students have done each semester in their respective courses.

Explanation of tables:

...

No and no, to answer your two questions.  I saw how the OP was basically ignoring design suggestions and came to the same conclusion as Scott's last statement and your...

I'm thinking that everywhere you said you wanted to "add columns", you really mean you wanted to "add rows", yes?

Yes, I meant rows. I have no idea why I was...

OK, for some reason the files did not upload. I'll just insert the CREATE TABLE code here. I also tried attaching the ERD as a .png file to see if...

Don't implement is as a table.

make it into a view. May be dynamically created view, to handle changing requirements for the column set.

Then you're not gonna need to do horribly...

For SQL Express, you'd need to use the task scheduler in Windows directly, instead of using SQL Server jobs.  It's more of a pain, but it should work.

The only thing...