CS 3410 Lecture Notes - Lecture 1: Object Database, Stored Procedure, Database
Document Summary
Lecture 1 powerpoint and textbook- chapter one- introduction . Data is stored in tables (with rows and columns) Databases may have multiple tables, where every table may store different things. Each row in a table stores data about an occurrence or instance of the thing on interest. Most common = relational database: a relational database stores data in tables (w/ rows and columns) Primary key: each row in a table is uniquely identified by a primary key and the values of these keys are used to create the relationship between the tables. (5) ie. student number. Surrogate key: if numbers are used in primary key are automatically generated and assigned to the database itself, they are also surrogate keys. Foreign key: provides the link between 3 tables, therefore creating an relationship b/t 2 tables. Information: knowledge derived from the data; data processed by summing, ordering, auging, grouping or comparing. Tables names are in all caps: ie. student.
