BUS-K 201 Lecture Notes - Lecture 5: Sql, Foreign Key, Database
Document Summary
Database: a self-describing collection of integrated records. Column (field): bytes are grouped into columns, or vertical sections. Table (file): a group of similar rows or records. Key (primary key): a column or a group of columns that identifies a unique row in a table. Foreign key: columns that are keys of a different table than the one in which they reside. Relational databases: databases that carry their data in the form of tables and that represent relationships using foreign keys. Database management system: a program used to create, process, and administer a database. No organization develops its dbms, usually use licensed products such as access, or. To modify an existing table the developer opens the metadata form for that table and adds a new row of metadata. Structured query language (sql): an international standard language for processing a database. Database administration: involves a wide variety of activities such as setting up security systems and permissions.