CIS4365: Database Management
The
Match the Following Terms on the Left with the Correct Definitions on the Right:
|
____ ANSI ____ Application Development ____ Attributes ____ CODASYL ____ Data ____ Database ____ Database Maintenance ____ Data Dependence ____ Data Dictionaries ____ Data Domain ____ Data Inconsistency ____ Data Interrogation ____ Data Mining ____ Data Partitioning ____ Data Redundancy ____ Data Replication ____ Data Warehouses ____ DBMS ____ DDL ____ Distributed Databases ____ End User databases ____ Entity ____ External databases ____ File Processing Systems ____ ____ Hierarchical Databases ____ IMS ____ Information ____ Metadata ____ Multidimensional Models ____ Network Databases ____ Object Oriented Models ____ Operational databases ____ QBE ____ Relational Databases ____ SADB ____ Schemas ____ SQL ____ Subschemas ____ Tuple |
01. 02. 03. 04. 05. 06. 07. 08. 09. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. |
Databases that organized by
subject area Distribution of data by
selected rows or columns Data about data Central sources of data
extracted from various sources A collection of data and
metadata Includes creation of user
reports The user’s view of the
database Databases that are
maintained by individuals The DBMS component that
allows for Database creation A procedure that allows
data extraction by using examples The manner in which data
was maintained before DBMS The national certification
board The storage of the same
data in various forms The conceptual view of the
entire database The component of a DBMS
that updates indices The first attempt at
reducing data duplication and inconsistency The first commercially
available DBMS type Database that allow data to
be associated with methods A Non-random collection of
symbols Databases that allow
records to have multiple parents Databases that are created
outside of the organization A row in a relational
database The group that was to set
COBOL Standards A set of programs that
allow for data access Anything that increases
awareness The DBMS component that
allows users to extract information Databases that allow data
to be logically viewed as tables The Processing of data from
a variety of sources The standard language used
to extract data from a database Duplication of the same
data Something we wish to keep
information on The characteristics of an
entity Data that is related to a
unique application The set of legal column
values A DBMS that allows for
multidimensional tables Databases that are
scattered but still coordinated The collection of field
names, types, and relationships Databases that are intended
to support day-to-day operations Distribution of entire sets
of data Databases that allow
records to have only one parent |
0001. What
is the definition of a database?
0002. When
we say a database is “Large”, what do we mean?
0003. When
we say a database is “Integrated”, what do we mean?
0004. What
is “Data”?
0005. What
is “Information”, and how is it different than “Data”?
0006. What
is “Metadata” and why is it important?
010.
About how long have Databases Been around?
011.
List at least three reasons why databases were impractical on the early
PCs.
001.
How did databases originate?
002.
Define the terms Data and Information, and explain how they are
different.
010.
About how long have Databases Been around?
011.
List at least three reasons why databases were impractical on the early
PCs.
020. Explain the typical process
followed in developing an application using the traditional file processing
system.
030. List AT LEAST five (5)
Advantages and three (3) Disadvantages of the Database approach
030a. List AT LEAST three (3) disadvantages of the typical file
processing system AND three (3) intended advantages of the Database approach
(NOTE: the advantages Database approach should NOT simply be the opposite of
the disadvantages of the file processing approach).
030b. For the sake of fairness, list AT LEAST one
(1) disadvantage of the Database approach and one (1) advantage of the file
processing system. Again, the disadvantage of the Database approach should NOT
simply be the opposite of the advantage of the file processing approach.
SEE ANSWER (For BOTH Questions).
031. What is the advantage of having
a program for multiple applications?
032. What does consolidation of data
mean, and what is the advantage of consolidating data?
033. How are errors reduced by using
a database system?
034. What are some of the functions
of a Database Administrator?
035. Why is it easier to maintain a
database than traditional data files?
036. Why are applications developed
faster using a database than traditional data files?
037. Why is there more sharing of
information with databases?
038. Why are
database programs more complex than traditional data file applications?
039. Why do we say that database
programs execute more slowly than traditional data file applications?
044. What are the four
major classifications of databases in terms of how businesses are using them?
045. What are
046. What are
Departmental databases and what issues must we be
aware of?
047. What are
Workgroup and what issues must we be aware of?
048. What are Personal
databases and what issues must we be aware of?
050. What
are the six general types of databases?
050a. We listed six (6)
different types uses (NOT MODELS BUT RATHER USAGES) of databases. For example,
one type of database is an operational database. List AT LEAST three (3)
others. For one (1) of those types that you have listed, give AT LEAST two (2)
subtypes/examples/descriptions.
051. What
is an operational database? What other terms are used to describe it?
052. What
is an Analytical database? What is the data stored in them used for?
052b. What is the difference between an
operational database and an analytical database?
053. What
is a Data Warehouse? How are they analyzed?
053b. Give a thorough explanation of a data
warehouse and how it works and list some advantages of data warehousing
054. What is an End User Database? What are the
advantages and disadvantages of using them?
055. What is an External Database? What Some of the concerns with them?
056. What is a Distributed Database? Why would we
use them?
057. At what locations can data physically be
stored? What are the advantages and disadvantages of each?
058. How are Decentralized and Distributed databases
differerent?
059. How can data be distributed?
066. What is the definition of a DBMS?
067. What are the four major tasks that a DBMS
Promotes?
068. How does a DBMS help in Creating Data?
069. How does a DBMS help in Manipulating Data?
070. How does a DBMS help in Developing Reports?
071. What basic categories of reports can be
developed using a Report Generator?
072. How does a DBMS help in Maintaining Data? What
does maintainging data mean?
073. List the advantages of
a DBMS to THE USER.
080. What
event in
081. What was the original solution arrived at by
North American Rockwell in response to the problems they noted?
082. What did North American Rockwell finally end up
doing and with whom?
083. What did IBM end up doing with their joint
venture with North American Rockwell?
084. What is CODASYL, how did it come about, and
what was it supposed to do?
085. What is the DBTG and what issues did it focus
on?
086. What is a Network Schema?
087. What is a Network Subschema?
087b. Explain how a schema
and subschema differ.
088. What are data management programs which define
and manipulate data?
089. What were the major events that occurred after
CODASYL?
100. What are the four major components of a DBMS?
102. What are the four major components of a DBMS
Development Tool?
104. What does a Data Definition Language (DDL)
refer to?
106. What Does a Data Dictionary Store?
108. What does Data Storage Maintentance Do?
110. What is the data transformation Component of
the DBMS Development Tool?
112. What Are the three
major components of th DBMS Interrogation Tool?
114. What are some examples of Query Languages used
by a DBMS?
116. Why are multi-user controls necessary?
118. Why kinds of communications interfaces are in
place?
120. What are the five major activites that a DBMS
Maintenance facility takes care of?
140. What are the five major types of DBMS?
142. How does a Hierarchical Database work?
144. How terminology is used in describing a
tree-like structure?
146. List the advantages and
disadvantages of the Hierarchical Database model.
148. How does a Network Database work?
150. List the advantages and
disadvantages of the Network Database model.
152. How does a Relational Database work?
154. What are some of the special terms used in the
relational model?
156. List the advantages and
disadvantages of the Relational Database Model.
158. List at least 5 of the most
common Relational DBMS packages for the PC.
160. How does a Relational Database work?
4. Name THREE (3) of the four major components (functions) of a DBMS.
For ONE of those, list AT LEAST TWO (2) specific tasks that it performs.
4.002 What are entities and attributes and how do they vary?
5. List
THREE (3) major DBMS Models (NOT usages; by models, I mean different ways of
logically (or physically) conceptualizing the manner in which data is
manipulated). For EACH of the models, list ONE (1) advantage and ONE (1)
disadvantage to the approach. NO TWO MODELS SHOULD HAVE THE SAME ADVANTAGE OR
DISADVANTAGE.
5.001. A large retailer
needs to store its employee information about its employees. Among the information stored is the employee name, ID, address, and position. The employee information is divided into each
employees respective district. What kind of a model is being used.
6. Explain the two major approaches in distributed databases.
8.001 Give a thorough explanation of a data
warehouse and how it works and list some advantages of data warehousing
9.001 The question was brought up whether or not the common DBMS
"FOXPRO" was still in use. Is it?