BCS 260 Lecture Notes - Lecture 5: Database Application, Relational Database, Compound Key
Document Summary
A database system has four components consisting of: users, database application set of one or more programs that serve as intermediary between user and the dbms. Application programs read or modify database data by sending sql statements to the dbms: database management system (d b m s) computer program used to create, process and administer the database. Received requests encoded in sql and translates those requests into actions on the database: database- collection of related tables and other structures. Contains a collection of separate tables that hold data bout one and only one theme in most circumstances. If a table has two or more themes, they should be broken up into two or more tables. This idea is the foundation of relational databases. Relational database contains a collection of separate tables. Table holds data about one and only one theme in most circumstances. If more than one theme, usually have to break up to more tables.
