CSCI 1001 Lecture 9: Schemas and Tables
Document Summary
Schema = outline: what should the table look like, what are the column/row names. Tables = actual data within the schema (framework) There needs to be a key field in every table: unique and used for identification. Comma differentiates between two tables or multiple things. from = what table are you obtaining data from. When you"re referring to values/string in a table, use single quotes. Example when needing to use both tables: find instructors that teach a one credit course.