chapter 5

Question 1

What are the differences between an spreadsheet and a database?

Answer 1

The spreadsheet uses tables to display information, but a database is a collection of tables that are related in some manner typically through a “key” so that it can be easily accessed, managed and updated

Question 2

what is the Hierarchy of Data elements?

Answer 2

table or file -> records or rows-> fields or columns -> Bytes or characters

Question 3

Components of a Database

Answer 3

tables or files, relationships among rows in tables, metadata

Question 4

what is a key

Answer 4

a unique value that ties rows or records together across different tables

Question 5

What is DBMS

Answer 5

database software program used to create, process, and administer a database

licensed from vendors: IBM, Microsoft, Oracle, and others

Question 6

Traditional DBMS

Answer 6

purpose/functions of DBMS ; DBMS process operations: read, insert, modify, delete

Question 7

processing power to support DBMS–ACID

Answer 7

ACID- atomic, consistent, isolated, durable