MGCR 331 Lecture Notes - Lecture 11: Sql, Database Administrator, Sensitivity Analysis
Document Summary
S e s s io n 1 1 : d a t a b as e s a n d d a t a as a n a ss e t. A database is a single table or a collection of related tables. Database management systems (database software) is used for creating, maintaining and manipulating data. Structured query language (sql) is a language used to created & manipulate databases. Database administrator (dba) is a job title focused on directing, performing, or overseeing activities associated with a database. Table/file is a list of data organized in columns & rows. A column represents each category of data in a record. A row represents a single instance of whatever the table keeps track of. A key is a field used to uniquely identify a record. Relational databases are used for expressing databases in which files are related by common keys. It is composed of records, which are composed of fields/attributes.
