INSY 3304 CHAPTER 1 QUESTIONS AND
ANSWERS 100% CORRECT
Data - ANSWER-Any RAW FACTS or observation that have little meaning on their own
Ex: (512) 555-1234 [Ch.1]
Information - ANSWER-Data that has been process formatted , or put into context to
give it meaning to make it useful Ex: Customer 101 phone: Data that has been
processed, formatted, or put into context to give meaning to make it useful [Ch.1]
Data vs. Information Foundation - ANSWER-Data is the foundation of information,
Information is the foundation of knowledge [Ch.1]
Database - ANSWER-repository of data shared, integrated that's stored as End-user
data also contains ;
metadata- data of the data (Ex: Customer key)- provides the characteristics in your
Database [Ch.1]
Database management system (DBMS): - ANSWER-Collection of programs that
manages the structure , controls access to data.ex: controls WHAT data goes in there
ie. characters, numbers , etc. [Ch.1]
What is the role and advantages of DBMS? - ANSWER-serves as the intermediary of
the user and database [Ch.1]
Semistructured data - ANSWER-data processed to some extent
XML - ANSWER-(Extensive Markup Language)
data element in textual format
provides semistructured data to create our own tags,
ie last name tags to a customer, but different to html is that we can customize the tags
What is Database Design? - ANSWER-Design of the database of the database
structure that's used of user-end data
Why is Database Design Necessary? - ANSWER-In Small business- design that
focuses in single user
In Big business - multiple users at the same time
Has to have a good design - in order to facilitate the management of data necessary ti
give accurate reliable information
, File Systems - ANSWER-composed of collection of file folders organic files,tagged, and
organized in logical fashion
Sharing in the DBMS - ANSWER-Shared among multiple users [Ch.1]
Integration in the DBMS - ANSWER-Viewed by multiple users [Ch.1]
Advantages of the DBMS - ANSWER-improve data sharing, multiple users, data
security, data Integration, minimizes data inconsistency
ex: 50 files, protect all 50 files, if we put a customer 2 times it will say NO cant do that,
not a long of runarounds get you what you need faster
Types of Databases (Database Classifications) - ANSWER-Desktop Database - one
user
Multiple user database- a workgroup database (50 or less)
Enterprise Database - 50 or more users
Classified by
- Number of users
-Database location
-expected type and extent of use
Location of DB - Distributed Database - ANSWER-Data on multiple locations
Type and extent of use for DB - ANSWER-Also known as operational database
day to day data transactions, accounting, production, inventory transactions, sales
transactions, payroll, and POS systems
Decision Support - ANSWER-Data stored in data warehouses that stores data used for
statistics
Ex: 5 years of sales data
Unstructured Data - ANSWER-Data in its original state
Structured Data - ANSWER-data resulting from formatting or processing data to give it
structure
Manual File Systems - ANSWER-large amounts of data is no good, too difficult
Basic File Terminology - ANSWER-See attached
Problems with file system data processing - ANSWER-Improvement over manual
system - needing more and more data, too much programming to manage, too much ,
hard to request
ANSWERS 100% CORRECT
Data - ANSWER-Any RAW FACTS or observation that have little meaning on their own
Ex: (512) 555-1234 [Ch.1]
Information - ANSWER-Data that has been process formatted , or put into context to
give it meaning to make it useful Ex: Customer 101 phone: Data that has been
processed, formatted, or put into context to give meaning to make it useful [Ch.1]
Data vs. Information Foundation - ANSWER-Data is the foundation of information,
Information is the foundation of knowledge [Ch.1]
Database - ANSWER-repository of data shared, integrated that's stored as End-user
data also contains ;
metadata- data of the data (Ex: Customer key)- provides the characteristics in your
Database [Ch.1]
Database management system (DBMS): - ANSWER-Collection of programs that
manages the structure , controls access to data.ex: controls WHAT data goes in there
ie. characters, numbers , etc. [Ch.1]
What is the role and advantages of DBMS? - ANSWER-serves as the intermediary of
the user and database [Ch.1]
Semistructured data - ANSWER-data processed to some extent
XML - ANSWER-(Extensive Markup Language)
data element in textual format
provides semistructured data to create our own tags,
ie last name tags to a customer, but different to html is that we can customize the tags
What is Database Design? - ANSWER-Design of the database of the database
structure that's used of user-end data
Why is Database Design Necessary? - ANSWER-In Small business- design that
focuses in single user
In Big business - multiple users at the same time
Has to have a good design - in order to facilitate the management of data necessary ti
give accurate reliable information
, File Systems - ANSWER-composed of collection of file folders organic files,tagged, and
organized in logical fashion
Sharing in the DBMS - ANSWER-Shared among multiple users [Ch.1]
Integration in the DBMS - ANSWER-Viewed by multiple users [Ch.1]
Advantages of the DBMS - ANSWER-improve data sharing, multiple users, data
security, data Integration, minimizes data inconsistency
ex: 50 files, protect all 50 files, if we put a customer 2 times it will say NO cant do that,
not a long of runarounds get you what you need faster
Types of Databases (Database Classifications) - ANSWER-Desktop Database - one
user
Multiple user database- a workgroup database (50 or less)
Enterprise Database - 50 or more users
Classified by
- Number of users
-Database location
-expected type and extent of use
Location of DB - Distributed Database - ANSWER-Data on multiple locations
Type and extent of use for DB - ANSWER-Also known as operational database
day to day data transactions, accounting, production, inventory transactions, sales
transactions, payroll, and POS systems
Decision Support - ANSWER-Data stored in data warehouses that stores data used for
statistics
Ex: 5 years of sales data
Unstructured Data - ANSWER-Data in its original state
Structured Data - ANSWER-data resulting from formatting or processing data to give it
structure
Manual File Systems - ANSWER-large amounts of data is no good, too difficult
Basic File Terminology - ANSWER-See attached
Problems with file system data processing - ANSWER-Improvement over manual
system - needing more and more data, too much programming to manage, too much ,
hard to request
