CPSC-2200 Lecture Notes - Lecture 2: Cardinality, Database Design, Foreign Key

39 views2 pages

Document Summary

Databases: any place that you store data. Relational database: access, more structured data base; stored in tables with relationships. Table: information linked together in rows and columns. Relationships: the way that we link different tables together; can do this by linking two fields. Key: field or a set of fields in a table that can uniquely identify a row. Primary key: type of key that is specific to a table, one key and the smallest key you can have. Foreign key: field in one table that is a key in another table. Query: asking a question in access; to pull information back out of your database. Is a more abstract way to think of a database. Instead of being specific to the database technology its just a way to organize the data. You map real world concepts to the er model to create an er diagram.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents