CH 5 Flashcards
Database applications must present data to the users in the same format as the database table.
T/F?
False
A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data.
T/F?
True
_ are used by users to read, insert, modify, and delete data in a database.
Forms
Developers generally construct a logical representation of database data, called a data model, after building a database.
T/F?
False
Which of the following is the smallest data element in a database?
Byte
A spreadsheet can be used to store data if the structure of a list is simple.
T/F
True
A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably.
T/F
False
In the case of single-user databases, the application, the DBMS, and the database all reside on the user’s computer.
T/F
True
SQL is an international standard language for processing a database.
T/F
True
Q1: What Is the Purpose of a Database?
Organize and keep track of things • Keep track of multiple themes • General rule:
Single theme - store in a spreadsheet
Multiple themes - use a database
Q2: What Is a Database?
a self-describing collection of integrated records
What is the Hierarchy of Data Elements
Table/File (largest)
Records/Rows
Fields/Columns
Bytes/Characters (smallest)
What is Metadata?
Metadata is data that describes data that is stored in a table
Q3: What Is a Database Management System
(DBMS)?
Program used to create, process, and administer a database.
• Licensed from vendors such as IBM, Microsoft, Oracle, and others.
What are the Four DBMS operations
1.Read 2.Insert 3.Modify 4.Delete data
What is Structured Query Language - SQL
International standard – Used by most popular DBMS
What are the Elements of Database Applications
Forms, Reports, Queries, Application Programs
Q6: How Is a Data Model Transformed into a
Database Design?
Normalization, Goal, Purpose
What is Normalization?
Converting poorly structured tables into two or more well-structured tables.
What are Data Integrity Problems?
Data integrity problems produce incorrect and inconsistent information, users lose confidence in information, and the system gets a poor reputation. (Can only occur if data are duplicated.)
Q7: What Is the Users’ Role in the Development of
Databases?
• Users are the final judges of:
– What data database should contain.
– How tables should be related
