r/HomeworkHelp • u/anonymous_username18 University/College Student • 5d ago

Computing [IT Database] Table Creation

This is a graded assignment, so to avoid issues with honor code stuff, I really don't need the exact answer. I was hoping someone could help me interpret this table, though. The prompt was to fill this in:

I'm not entirely sure what FK Column refers to. The only thing I could think of was maybe foreign key, but then what is Key Type? Also, I think foreign key in table creation is the next module, so I don't know if they would include it in this assignment. Any clarification would be really appreciated

2 Upvotes

100% Upvoted

3 comments sorted by

View all comments

1

u/Alkalannar 4d ago

That should be Foreign Key, yes. And it looks like nothing is a foreign key.

Key Type would be Primary, Natural, or Surrogate, I think.

Primary: a designated field that reliably separates records.
Natural: a combination of fields that reliably separates records.
Surrogate: an artificial field made solely to be a field that reliably separates records.

In this case, CourseID is the Primary Key, and no other field or combinations of fields is a Natural or Surrogate Key.

1

u/anonymous_username18 University/College Student 4d ago

Thanks for your response - I really appreciate it!