Chapter 4 Databases

Question 1

What is the purpose of a database?

Answer 1

To keep track of things

Question 2

What is a spreadsheet?

Answer 2

List of data involving single theme

Question 3

What is a database?

Answer 3

Lists of data that involve multiple themes. Seld describing collection of intergrated records

Question 4

What is an abyte?

Answer 4

A character of data

Question 5

What is a table/file?

Answer 5

Group of similar rows

Question 6

What are the 3 elements of a database?

Answer 6

1)Tables
2)Relationship among rows in tables
3)Metadata

Question 7

What is a key? (Primary)

Answer 7

Colums or a group of colums that identifies a unique row in a table

Question 8

What is a foreign key?

Answer 8

A key of a different table than the one in which they reside

Question 9

What is relational databases?

Answer 9

databases that carry their data in form of tables and that represent relationships using foreign keyrs

Question 10

What is metadata?

Answer 10

Datta that describes data

Question 11

What is DBMS?

Answer 11

Database management system

Question 12

What are DBMS used for? (3)

Answer 12

1) Creating the database and its structures
2)Processing the database
3)Administering the database

Question 13

What is included in the creation of the database and its structure? (3)

Answer 13

1)Database (tables, relationshiips, metadata)
2)DBMS
3)Database apps (forms, reports, queries, programs)

Question 14

In proccessing the database, what are the 4 operations?

Answer 14

1)Read
2)Insert
3)Modify
4)Delete

Question 15

What is structured Query Language (SQL)?

Answer 15

International standard language for processing database

Question 16

What are the common activities in administering the database? (4)

Answer 16

1)security system
2)backing up data
3)adding structure to improve performance
4)removing data

Question 17

What are database apps?

Answer 17

Collection of forms, reports, queries, appllication programs that use DBMS to process database

Question 18

What are forms?

Answer 18

data entry

Question 19

what are queries?

Answer 19

locate data, create lists

Question 20

What are reports?

Answer 20

Show data in structured context

Question 21

What are the 2 complex functions of database apps?

Answer 21

1)Process logic that is pecific to a given business need
2)Enable database processing over the Internet

Question 22

What are multi-users processing?

Answer 22

Multiple users processing the database

Question 23

What is the Lost update problem?

Answer 23

Problem in which 2+ users try to change data but database cannot

Question 24

How to fix the lost update problem ? (2)

Answer 24

1)Need locking to coordinate activity
2)Convert to a multi-user database

Question 25

How do data models facilitate database design?

Answer 25

Design of database depends on how users view their business environment, user involvement is critical for database development

Question 26

What is a data model?

Answer 26

Describes data and relationships that will be stored in database

Question 27

What are the requirements to create data model? (3)

Answer 27

1)Forms 2)Reports 3)Queries

Question 28

What are the 2 steps to create database?

Answer 28

1)Create data model 2)Create database design

Question 29

What is the entity-relationship data model?

Answer 29

Tool for constructing data models ; to describe content of a data model by defining entities that will be stored and relationships

Question 30

What is an entity?

Answer 30

Something that users want to track

Question 31

What are attributes?

Answer 31

Describe characteristics of an entity

Question 32

What is an identifier?

Answer 32

Attribute whose value is associated with 1 entity instance

Question 33

What do entity-relationship diagrams do?

Answer 33

Show data, represented by attributes

Question 34

What is crow's feet?

Answer 34

Line that represent relationship between 2 entities

Question 35

What does the 1:N mean?

Answer 35

One to many relationship

Question 36

What does the N:M mean?

Answer 36

Many to many relationship

Question 37

What is normalization?

Answer 37

Process of converting poorly structured table into 2+ well structured tables

Question 38

What are data integrity problems?

Answer 38

When database contains inconsistent data

Question 39

When do you use normalization for data integrity?

Answer 39

when data are duplicated, to eliminate duplicated data

Question 40

What are normal forms?

Answer 40

Classifications of tables according to the kinds of problems they have

Question 41

What are the 2 user roles in development of database?

Answer 41

1)Final judges 2)Review of data model

Question 42

What is NOSQL databases?

Answer 42

Catchall category that includes many different types of DBMS