Database management systems (DBMS)

Database management systems (DBMS) What is a database management system? - a program controlling the structure of a database and access to the data; creates, processes, and administers database What are some advantages of a DBMS? - -reduced data redundancy -improved data integrity -more program independence -increased user productivity -increased security What is DBMS used for? - to create tables and relationships in databases What do applications use DBMS for? - to read, insert, modify, and delete data What is a structured query language (SQL)? - SQL is an international standard language for manipulating relational databases What do SQL queries consist of? - an action, database table name, set of parameters What are SQL keywords? - they issue instructions -create, delete, insert, etc. What are boo lean operators? - AND, OR, NOT for searching What are global updates? - based on some criteria What are joining tables? - creating relationship What are some things that go into selecting a DBMS? - database size number of concurrent users performance integration features vendor cost What is a database structure? - an arrangement of the fields, tables, and relationships . - . What are some techniques for creating a data model? - entity relationship data model unified modeling language Database content? - entities stored in database and relationship among those things What is an entity? - item for which