# RDBMS Design Question

**URL:** <https://forum.kirupa.com/t/rdbms-design-question/205202>\
**Category:** Uncategorized\
**Created:** [October 27, 2006, 2:14am UTC](https://forum.kirupa.com/t/rdbms-design-question/205202 "2006-10-27T02:14:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anif](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@anif](https://forum.kirupa.com/u/anif)\
**Post date:** [October 27, 2006, 2:14am UTC](https://forum.kirupa.com/t/rdbms-design-question/205202/1 "2006-10-27T02:14:43Z")

</div>

Hi

This is in regards to the RDBMS design tutorial on [Kirupa.com](http://Kirupa.com). On this page here [http://www.kirupa.com/developer/php/relational\_db\_design4.htm](http://www.kirupa.com/forum/../developer/php/relational_db_design4.htm), when the author created tbl\_works\_categories, he said work\_id & category\_id are foreign keys. I got a bit confused because I did not see anywhere in the code where he defined the foreign key parameter. I just wanted to know if this is a mistake or is it that you don’t need to specify the word “FOREIGN KEY” next to a column…or does MySQL automatically assign them as foreign keys because you used thesame column name?? I just wanted to clear this part up since I’m a bit stuck on that part.