chapter 5 Flashcards Preview

BUS4 188 > chapter 5 > Flashcards

Flashcards in chapter 5 Deck (7)
Loading flashcards...
1
Q

What are the differences between an spreadsheet and a database?

A

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

2
Q

what is the Hierarchy of Data elements?

A

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

3
Q

Components of a Database

A

tables or files, relationships among rows in tables, metadata

4
Q

what is a key

A

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

5
Q

What is DBMS

A

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

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

6
Q

Traditional DBMS

A

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

7
Q

processing power to support DBMS–ACID

A

ACID- atomic, consistent, isolated, durable