Chapter 1

Question 1

Agile software development 25

Answer 1

An approach to database and software development that emphasizes “ individuals and interactions over processes and tools, working software over comprehensive documentation, customer collaboration over contract negotiation, and response to change over following a plan

Question 2

Conceptual schema 23

Answer 2

A detailed, technology - independent specification of the overall structure of organizational data

Question 3

Constraint 15

Answer 3

A rule that cannot be violated by database users

Question 4

Data 7

Answer 4

Stored representations of objects and events that have meaning and importance in the user’s environment

Question 5

Data Independence 13

Answer 5

Separation of data descriptions from the application programs that use the data

Question 6

Data Lake 34

Answer 6

A large integrated repository for internal and external data that does not follow a predefined schema

Question 7

Data model 11

Answer 7

Graphical systems used to capture the nature and relationships among data

Question 8

Data modeling and design tools 19

Answer 8

Software tools that provide automated support for creating data models

Question 9

Data warehouse 33

Answer 9

An integrated decision support database whose content is derived from the various operational databases

Question 10

Database

Answer 10

An organized collection of logically related data

Question 11

Database application 10

Answer 11

An application program (or set of related programs ) that is used to perform a series of database activities ( create, read, update, and delete ) on behalf of database users

Question 12

Database management system (DBMS)

Answer 12

A software system that is used to create, maintain, and provide controlled access to user databases

Question 13

Enterprise data modeling 20

Answer 13

The first step in database development, in which the scope and general contents of organizational databases are specified

Question 14

Enterprise resource planning ( ERP )

Answer 14

A business management system that integrates all functions of the Enterprise. They are software applications that provide the data necessary for the Enterprise to examine and manage its activities.

Ex: manufacturing, sales, finance, marketing, inventory, accounting, and human resources

Question 15

Entity 11

Answer 15

a person, place, an object, an event, or a concept in the user environment about which the organization which is to maintain data

Question 16

Information 7

Answer 16

Data that have been processed in such a way as to increase the knowledge of the person who uses the data

Question 17

Logical schema 23

Answer 17

The representation of a database for a particular data management technology

Question 18

Metadata 8

Answer 18

Data that describe the properties are characteristics of end-user data and the context of those data

Question 19

Physical schema 23

Answer 19

specifications for how data from a logical schema are stored in a computer’s secondary memory by a database management system

Question 20

Project 27

Answer 20

A planned undertaking of related activities to reach an objective that has a beginning and an end

Question 21

Prototyping 24

Answer 21

an iterative process of systems development in which requirements are converted to a working system that is continually revised through clothes work between analyst and users

Question 22

Relational database 12

Answer 22

a database that represents data as a collection of tables in which all data relationships are represented by common values in related tables

Question 23

Repository

Answer 23

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components

Question 24

Systems development life cycle ( SDLC )

Answer 24

The traditional methodology used to develop, maintain, and replace information systems

Question 25

User view

Answer 25

A logical description of some portion of the database that is required by a user to perform some task