Tuesday, November 12, 2013

Primary and Foreign Keys and Data Dump

I spent most of the day trying to figure out when to use primary and foreign keys and I sort of understand it and I figured out how to dump data. That's basically all I did because I'm a bit confused about primary keys but I almost have the entire fruit database done and I understand most of SQL.

1 comment:

  1. What about primary keys is still confusing you? A primary key is just a field or set of fields that is unique in each row of a table (see http://en.wikipedia.org/wiki/Primary_key for more on this).

    Please start to post your sql files (either on students.gctaa.net or on google drive or dropbox or github or something). You can then link to them from your blog posts.

    ReplyDelete