2. The Database Environment Flashcards
(144 cards)
1
Q
What are the components of a database environment?
A
- Users
- Database management systems
- Physical database
2
Q
What are the advantages of a database?
A
- Reduces data redundancy
- Reduce costs of capturing data. Only entered once
- Data integrity is maintained and improved. Updates made in one place
- Improved data security, centrally controlled
- Application software independence. Data is stored separately from application software so updates won’t require rewriting.
- Standardization of data structures.
- Improved data access. Data made available to different users at the same time.
3
Q
What are some disadvantages of databases
A
- Start up costs are large
- Database systems are complex to use
- Time-consuming to design
- A database failure will shut down the organization
4
Q
Who are the different users of a database?
A
- End-users
- Application programmers
- Database administrator
- Data administrator
5
Q
Who are the end users?
A
They capture data and extract information
Low skill level and use application software
6
Q
What are the applications programmers for?
A
They are responsible for creating, maintaining, updating and managing application and DBMS software
7
Q
What are the database administrators for?
A
- Responsible for controlling and managing database.
- Their roles include;
- implement and maintain standards
- Ensure application software complies with database management standards
- Define database structures
- Design and create databases in line with standards
- Implement, maintain and Evaluate access policies
- Monitor data and database access and security
- Monitor and maintain database performances
8
Q
What is another name for a data administrator?
A
Database analyst
9
Q
What are the data administrators responsible for?
A
- Managing and controlling data
- Manage integrity and setting and enforcing data standards
10
Q
Are the database admin and data admin usually the same person?
A
Yes
11
Q
What is a DBMS?
A
An integrated set of software that provides user friendly interface to users.
12
Q
What is an example of DBMS?
A
Microsoft access
13
Q
What are the functions of the DBMS?
A
- Design create and maintain database structures
- Control and organize data retrieval and and storage
- Capture, maintain and manipulate data
- Share data between multiple users
- Executes queries and generate outputs
- Control movement of data between users
- Control,and manage access
- Analyze and monitor database performance
14
Q
Who suggests the three-level database architecture?
A
ANSI-SPARC
American national standards institute - standards planning and requirements committee
15
Q
What are the three-levels of database architecture?
A
- External level
- Conceptual level
- Internal level
16
Q
Is the three-level view of database architecture used commonly?
A
Yes
17
Q
What is the external level also called?
A
The user view
18
Q
He many different user views could there be?
A
An infinite amount
E.g. A creditor clerk’s user view screen will look different from a cash book input screen.
19
Q
What is the conceptual level?
A
A complete view of the entire database and all it’s data.
20
Q
Who will generally use the conceptual level view?
A
The database administrator
21
Q
He many conceptual views of the database are there?
A
Only one
22
Q
What is another name for an internal view?
A
Physical view
23
Q
What is the physical view?
A
It is a low level view of how the data is physically stored, such as storage device like a magnetic hard drive.
24
Q
He many physical views are there?
A
Only one
25
How is the binary code related to the physical view?
Is it only now facet of the physical view.
26
What does the database administrator do for all levels?
They update and maintain all three levels of the database architecture.
27
What are the key components of the DBMS?
1. Data dictionary
| 2. Data languages
28
What is a data field?
A single data value and the smallest unit of data that can be accessed
29
What is a data dictionary?
Contains records for all data fields and can give a detailed description of all data fields
30
What does a data field description include?
1. Name and description of data
2. Other names the data field might have
3. Data type
4. Field length
5. Software
6. Source of data field
7. Outputs in which it's used
8. The authorized user groups for that data field
31
What is a database language?
The different language that different users use to interact with the database
32
What are the different data languages Inlcuded?
1. Data definition language
2. Data control language
3. Data manipulation language
4. Data query language
33
What is the most common language used?
SQL (structured query language)
| It combines the languages mentioned
34
What is DDL used for?
1. Define a database and includes commands to;
- Create, modify and delete databases and database objects
- Define and describe database structures
- Create data dictionary
35
What do database objects include?
1. Database tables
2. Views
3. Rules
4. Indexes
36
Use usually uses the DDL?
The database administrator
37
What is the DCL used for?
To control the security and access to the database
38
Who uses the DCL?
Usually only the database administrator
39
What is DML use for?
Routine operations on the database, including insert, delete, modify and maintain the date stored on database.
40
Who can use the DML?
All users use it, usually accessed through application software
41
What is the difference between DDL and DML?
DML is to manipulate the data stored in the database where DDL is used to manipulate the database objects and structures.
42
What is DQL used for?
Usually to retrieve data from the database
43
Who can use DQL?
All users can use it. Usually through application software
44
What are database models?
The theoretical data structures
45
What are the main types of data models?
1. Hierarchical
2. Network
3. Relational
4. Object-orientated
5. Multidimensional
46
When was hierarchical models used?
In earlier databases
47
What relationship did the hierarchical database have?
One-to-many relationship
48
Is the hierarchical structure flexible?
No
| Inflexible
49
What is an example of a hierarchical database model?
Microsoft windows explorer
50
What is a network model?
A many-to-many relationship. Data may be accessed through many paths.
51
Is the use of a network model common?
No
| Mostly obsolete
52
What does a relational model look like?
Data is stored on rows and columns, like a table.
53
What is the disadvantage of relational model?
It is slower than hierarchical and network because it uses more processing power to query data
54
What are the benefits of the relational model?
1. Data can be accessed, inserted, deleted without changing the structure of the model
2. Database can be adult customized
3. Data does not need to be duplicated
4. Most users can easily understand the structure
5. It's easy to search for and extract data
55
What is the most common structure?
Relational model, because of its many advantages.
| Common in business and financial databases.
56
What is an object-orientated model?
Where data and the operations to be performed are stored in the database.
57
What is the benefit of object-orientated model?
Can further process more types of data beside text and numerical types. Such as video, audio and images.
58
Who would use object-orientated models?
More specialized databases such as web-based applications, molecular biology databases and defense industries
59
What is a disadvantage of object-orientated model?
It is used less because it is expensive and many organizations don't need to process more data types besides text and numericals.
60
What is a multidimensional model?
Similar to a relational model, but with Merle dimensions, kind of creating a cube.
61
His data views from a multidimensional model?
Usually in a spreadsheet form.
62
What is an advantage of a multidimensional model?
It is easy to maintain.
63
What is the multidimensional model usually used for?
Usually storage warehouse
64
What does multidimensional models make possible?
1. Online analytical processing (OLAP)
| 2. Business intelligence software (BIS)
65
How do we classify according to the physical location of the database?
Between;
1. Centralized
2. Distributed
66
What is a centralize database?
Where the database is stored in one location
| E.g. One server
67
Hw do users interact with a centralized database?
Through networks
68
What is an advantage of centralized databases?
The information and data on them is up to date all the time provided online input and real-time processing is used
69
What is a distributed database?
Where there are several databases stored in different locations
70
What two different distributed databases a there?
Either;
1. Partitioned
2. Replicated databases
71
What is a partitioned database?
Where database is split into smaller parts and where a part is applicable to a user it will be made available to them.
72
When is partitioned database generally used?
Where data sharing isn't necessary
| E.g. Branches where customers don't visit other branches
73
What is a replicated database system?
Where the original database is replicated at each location
74
What is an example of replicated databases?
Pharmacies where customers can use different branches to renew prescriptions etc.
75
How are the different databases updated in a replicated database system?
Either;
1. Duplication
2. Synchronization
76
What happens with duplication updating?
The master database is duplicated at regular frequencies.
77
What happens with synchronization of databases?
Much more complex, involves two way updating of master and distributed databases.
78
What is a data value?
A single character such as letters or numbers to populate a data field
79
What is a data field
Contain a single data value. Similar to a cell in a spreadsheet
80
What different data field can exist?
Compulsory,optional or calculated
81
What is an attribute?
Also seen as a column
| Represent one unique characteristic of a collection of data fields
82
A field name?
Then name given to the attribute.
| No attribute can have the same field name
83
Can different attributes have the same name?
No
84
What is a data record?
A set of related data field about a single member of an item
85
What is another name of a data record?
Tuple
| Similar to rows in spreadsheets
86
What is a primary data field?
A unique data field that will identify the data records in a database
87
What else is a primary data field called?
Primary key
88
What is a foreign key?
Where a primary data field is entered into another database to create relationship between the two.
89
What is the purpose of foreign keys?
They prevent data from being duplicated.
90
What is another name for a database file?
A database table
91
What is a database file?
An organized collection of related data records
92
What are the different types of database files?
1. Master
2. Transaction
3. Reference
4. History files
93
What nature of records do master files contain?
Records of a relatively permanent nature. They do not change often.
94
What information do they master files contain?
Info about the organizations resources and subjects. E.g. Customers, suppliers, employees and inventory.
95
What do transaction files contain?
Data records of daily activities
96
He often are transaction files changed?
Regularly as new data is processed often
97
What is a replicated database system?
Where the original database is replicated at each location
98
What is an example of replicated databases?
Pharmacies where customers can use different branches to renew prescriptions etc.
99
How are the different databases updated in a replicated database system?
Either;
1. Duplication
2. Synchronization
100
What happens with duplication updating?
The master database is duplicated at regular frequencies.
101
What happens with synchronization of databases?
Much more complex, involves two way updating of master and distributed databases.
102
What is a data value?
A single character such as letters or numbers to populate a data field
103
What is a data field
Contain a single data value. Similar to a cell in a spreadsheet
104
What different data field can exist?
Compulsory,optional or calculated
105
What is an attribute?
Also seen as a column
| Represent one unique characteristic of a collection of data fields
106
A field name?
Then name given to the attribute.
| No attribute can have the same field name
107
Can different attributes have the same name?
No
108
What is a data record?
A set of related data field about a single member of an item
109
What is another name of a data record?
Tuple
| Similar to rows in spreadsheets
110
What is a primary data field?
A unique data field that will identify the data records in a database
111
What else is a primary data field called?
Primary key
112
What is a foreign key?
Where a primary data field is entered into another database to create relationship between the two.
113
What is the purpose of foreign keys?
They prevent data from being duplicated.
114
What is another name for a database file?
A database table
115
What is a database file?
An organized collection of related data records
116
What are the different types of database files?
1. Master
2. Transaction
3. Reference
4. History files
117
What nature of records do master files contain?
Records of a relatively permanent nature. They do not change often.
118
What information do they master files contain?
Info about the organizations resources and subjects. E.g. Customers, suppliers, employees and inventory.
119
What do transaction files contain?
Data records of daily activities
120
He often are transaction files changed?
Regularly as new data is processed often
121
What is a replicated database system?
Where the original database is replicated at each location
122
What is an example of replicated databases?
Pharmacies where customers can use different branches to renew prescriptions etc.
123
How are the different databases updated in a replicated database system?
Either;
1. Duplication
2. Synchronization
124
What happens with duplication updating?
The master database is duplicated at regular frequencies.
125
What happens with synchronization of databases?
Much more complex, involves two way updating of master and distributed databases.
126
What is a data value?
A single character such as letters or numbers to populate a data field
127
What is a data field
Contain a single data value. Similar to a cell in a spreadsheet
128
What different data field can exist?
Compulsory,optional or calculated
129
What is an attribute?
Also seen as a column
| Represent one unique characteristic of a collection of data fields
130
A field name?
Then name given to the attribute.
| No attribute can have the same field name
131
Can different attributes have the same name?
No
132
What is a data record?
A set of related data field about a single member of an item
133
What is another name of a data record?
Tuple
| Similar to rows in spreadsheets
134
What is a primary data field?
A unique data field that will identify the data records in a database
135
What else is a primary data field called?
Primary key
136
What is a foreign key?
Where a primary data field is entered into another database to create relationship between the two.
137
What is the purpose of foreign keys?
They prevent data from being duplicated.
138
What is another name for a database file?
A database table
139
What is a database file?
An organized collection of related data records
140
What are the different types of database files?
1. Master
2. Transaction
3. Reference
4. History files
141
What nature of records do master files contain?
Records of a relatively permanent nature. They do not change often.
142
What information do they master files contain?
Info about the organizations resources and subjects. E.g. Customers, suppliers, employees and inventory.
143
What do transaction files contain?
Data records of daily activities
144
He often are transaction files changed?
Regularly as new data is processed often
