Database Environment and Development Process Chapter 1
30 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

A database is an organized collection of logically related ______.

data

Structured data includes ______, text, and dates.

numbers

Unstructured data includes ______, video, and documents.

images

Information is ______ processed to increase knowledge in the person using the data.

<p>data</p> Signup and view all the answers

______ is data that describes the properties and context of user data.

<p>Metadata</p> Signup and view all the answers

The three-schema architectures are ______, conceptual, and internal.

<p>external</p> Signup and view all the answers

Metadata includes descriptions of the properties or characteristics of the ______, including data types, field sizes, and allowable values.

<p>data</p> Signup and view all the answers

The traditional methodology used to develop, maintain, and replace information systems is called ______ Development Life Cycle.

<p>Systems</p> Signup and view all the answers

One of the disadvantages of file processing is ______ of data, which occurs when different systems or programs have separate copies of the same data.

<p>duplication</p> Signup and view all the answers

The ______ stage involves preliminary understanding of business situation, enterprise model and conceptual data modeling.

<p>Planning</p> Signup and view all the answers

The program-data dependence disadvantage of file processing means that all programs must maintain ______ for each file they use.

<p>metadata</p> Signup and view all the answers

80% of information systems budget is spent on ______ program maintenance.

<p>excessive</p> Signup and view all the answers

The database development process involves two main approaches: ______ and Prototyping.

<p>SDLC</p> Signup and view all the answers

The table of metadata for the class roster includes fields such as Course, Section, ______, and Student IS ID.

<p>Name</p> Signup and view all the answers

In the ______ stage, logical and physical database design is developed to develop technology and organization.

<p>Design</p> Signup and view all the answers

One of the disadvantages of file processing is ______ development times, which occurs when programmers must design their own file formats.

<p>lengthy</p> Signup and view all the answers

The ______ stage involves writing programs, building databases, testing, installing, training, and documenting.

<p>Implementation</p> Signup and view all the answers

The ______ stage involves monitoring, repairing, and enhancing.

<p>Maintenance</p> Signup and view all the answers

Business analysts analyze ______ situation and establish requirements

<p>business</p> Signup and view all the answers

Programmers are the coders of the programs that interact with the ______

<p>database</p> Signup and view all the answers

The need for ______ data access for less technical personnel contributed to the evolution of database systems

<p>ease</p> Signup and view all the answers

Data administrators are responsible for ensuring ______ and consistency in existing databases

<p>data integrity</p> Signup and view all the answers

Project managers are responsible for overseeing the ______ and managing the personnel

<p>projects</p> Signup and view all the answers

Database architects establish standards for ______ in business units

<p>data</p> Signup and view all the answers

Personal databases are typically sized in the _______

<p>megabytes</p> Signup and view all the answers

Departmental Multi-Tiered Client/Server Databases usually don't exceed _______ users

<p>100</p> Signup and view all the answers

Enterprise Applications typically have a size ranging from _______ to petabytes

<p>gigabytes</p> Signup and view all the answers

Figure 1-11 illustrates the range of _______ technologies

<p>Database</p> Signup and view all the answers

Figure 1-12 illustrates the concept of _______ Client/Server Database Architecture

<p>Multi-Tiered</p> Signup and view all the answers

Copyright © 2020 _______ Education Ltd.

<p>Pearson</p> Signup and view all the answers

More Like This

Database Fundamentals
5 questions

Database Fundamentals

InnovativeIntegral avatar
InnovativeIntegral
Database Administration and Development
10 questions
Concepts de base de l'informatique
8 questions
Use Quizgecko on...
Browser
Browser