===== Week 1 Asynchronous Material Part 1: A little about databases, DBMSs, and application programs... ===== * what is a database? * our first definition: it is a collection of tables, holding information about different interrelated entities * what is an entity? ...a set of something important in a world or scenario ...an entity in a scenario will be represented by ONE OR MORE tables in a database * what is a DBMS? * DataBase Management System * a DBMS is a program or collection of programs that acts as the INTERFACE between a user or application program and a database * Oracle is an example of a DBMS. So are programs such as Microsoft Access and MySQL and Microsoft SQLServer and PostgreSQL. * be a little careful -- SQL is a language often implemented and provided by a DBMS. * and Excel, while it is a lovely and powerful spreadsheet program, is not a DBMS * and remember: an application program, then, USES the DBMS to access a database managed and controlled by that DBMS