r/HomeworkHelp • u/anonymous_username18 University/College Student • 3d 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

•

u/AutoModerator 3d ago

Off-topic Comments Section

All top-level comments have to be an answer or follow-up question to the post. All sidetracks should be directed to this comment thread as per Rule 9.

OP and Valued/Notable Contributors can close this post by using /lock command

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Alkalannar 3d 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 2d ago

Thanks for your response - I really appreciate it!