MIS 431 REVIEW QUESTIONS TEXTBOOK

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

What common problems does a collection of spreadsheets created by end users share with the typical file system?

pg 18 data modeling

What is data redundancy, and which characteristics of the file system can lead to it?

Data redundancy: same data stored unnecessarily in different places Exists when unnecessarily duplicated data are found in the database. e.g., a customer's telephone number in the customer file, in the sales agent file, and in the invoice file. Data redundancy may also be the result of poorly‑designed databases that allow the same data to be kept in different locations. problems with file systems: Requires extensive programming Cannot perform ad hoc queries System administration is complex and difficult Difficult to make changes to existing structures Security features are likely to be inadequate

What is a DBMS, and what are its functions?

Manages Database structure Controls access to data Contains query language functions: Data dictionary management Data storage management Data transformation and presentation Security management Multiuser access control Backup and recovery management Data integrity management Database language and application programming interfaces Database communication interfaces

Define each of the following: a.data b. field c. record d. file

a. data are raw facts b. group of characters with specific meaning c. logically connected fields that describe a person, place, or thing d. collection of related record

What is structural independence, and why is it important?

change file structure without affecting data access

What is data independence, and why is it lacking in file systems?

data storage characteristics do not affect data access

9, 14-23

do on paper

Problem 1, 3 (a-e), 8

do on paper


Set pelajaran terkait

Exam 3: Adulthood Ch. 14, 16, 18, 19

View Set

Chapter 24: Asepsis and Infection Control PrepU

View Set

Foundations of Education test ch. 9-11

View Set

Introduction and Descriptive Statistics

View Set

PPME Block 2 The Culture of the Navy - Lawful and Unlawful Orders

View Set

Stats Ch. 2: Frequency Tables, Frequency Distributions, and Graphic Presentation

View Set

Management Exam 2 study guide!!!!!!!

View Set

Personal and Social Psychology Case Studies

View Set