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