Database management systems (DBMS) Study Guide Solution With Correct Answers.

What is a database management system? - correct answer 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? - correct answer -reduced data redundancy -improved data integrity -more program independence -increased user productivity -increased security What is DBMS used for? - correct answer to create tables and relationships in databases What do applications use DBMS for? - correct answer to read, insert, modify, and delete data What is a structured query language (SQL)? - correct answer SQL is an international standard language for manipulating relational databases What do SQL queries consist of? - correct answer an action, database table name, set of parameters What are SQL keywords? - correct answer they issue instructions -create, delete, insert, etc. What are boo lean operators? - correct answer AND, OR, NOT for searching What are global updates? - correct answer based on some criteria What are joining tables? - correct answer creating relationship What are some things that go into selecting a DBMS? - correct answer database size number of concurrent users performance integration features vendor cost What is a database structure? - correct answer an arrangement of the fields, tables, and relationships . - correct answer . What are some techniques for creating a data model? - correct answer entity relationship data model unified modeling language Database content? - correct answer entities stored in database and relationship among those things What is an entity? - correct answer item for which we want to store information -tables What is an attribute? - correct answer specific piece of data about an entry -fields What is an entity relationship diagram (ERD)? - correct answer picture of how data is related Are entities something that users want tracked? - correct answer yes Entities may be... - correct answer physical object logical construct transaction Entities are always... - correct answer singular