Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DATABASE SYSTEMS > INTRODUCTION TO DATABASES > Flashcards

INTRODUCTION TO DATABASES Flashcards

1
Q

What are the limitations of file-based systems?

A
  1. Separation and isolation of data- Since each program is responsible for its own data a user may ne unaware of potentially useful information in other programs
  2. Duplication of data when the same data is held by different programs. This may lead to wastage of space and or potentially different formats or values for the same item
  3. Program-data dependence- This is disadvantageous since if any changes are to be made on the data the application has to be rewritten
  4. Incompatible file formats- Programs are written in different languages so they cannot easily access each others files
  5. Inflexibility in querying stored data
  6. Increase in number of various application programs- Any new requirement requires a new program
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a database?

A

a shared collection of logically related data and its description designed to meet an organizations information needs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is an entity?

A

A distinct object (person, thing, event, place etc) in an organization that is represented in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is an attribute

A

A property that describes a certain aspect of an object that we wish to record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a relationship?

A

An association between entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is a DBMS?

A

Software that enables users to create, define, maintain and control access to a database.
It interacts with both the actual database and the application software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What functionalities does a DBMS provide?

A
  1. Allows users to specify the types of data as well as the constraints on the data. Done using a data definition language(DDL)
  2. Allows users to create, read, update and delete (CRUD) data from the database. Done using a data manipulation language (DML)
  3. Provides controlled access to the data in the database (authorization) . Done using the data control language (DCL)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a query language?

A

Query language (QL) refers to any computer programming language that requests and retrieves data from database and information systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Give examples of query languages.

A 
Structured Query Language (SQL)
Transact SQL (T-SQL)
Contextual Query Language (CQL)
Object Query Language (OQL)
Language Integrated Inquiry (LINQ)
Yahoo Query Language (YQL)
Bing Query Language (BCL)
XQuery
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Give examples of DBMSs

A 
MySQL
Oracle
MS Access
SQL Server
File Maker
FoxPro
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is the function of database application programs?

A
  • Used to create and maintain the database
  • Enables the user to access the database
  • Access the database, process the data and generate the required information
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Give examples of database application programs.

A

Amazon
CNN.
eBay.
Facebook.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are the characteristics of the database approach?

A
  1. Single repository of data that is sharable by multiple users thus favoring concurrency
  2. Multiple views ( a subset of a database tailored for the needs of the user) of data that allows some level of customization for the user
  3. Self describing- System catalogue contains Metadata (data that describes other data) eg definitions of database objects (eg tables) and security information about the type of access users have
  4. Program-data independence- capability of leaving data intact and accessible regardless of modifications to the database that contains the data.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are the 5 major components that make a DBMS environment?

A
  1. Hardware- Can range from a PC to Network devices
  2. Software-Collection of programs used by computers in the database system eg DBMS, Operating System and Network software
  3. Procedures- Instructions and rules that should be applied when designing and using databases
  4. People-Users of the database
  5. Data- acts as the bridge between the human (people and procedures) and machine (hardware and software) component
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are the types of roles within a database environment?

A
  • Database Administrator- Management of data within the database. Tasks include maintaining the data dictionary, monitoring performance, and enforcing organizational standards and security.
  • Database Designers- Responsible for defining the detailed database design, including tables, indexes, views, constraints, triggers and other database-specific constructs. Solves a problem and makes an entity relationship diagram (ERD).
  • Application developers
  • End-Users
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Describe 5 functions of a DBMS

A
  1. Data storage, manipulation and update- The database must allow the user to ~
  2. A DBMS should provide a user-accessible catalogue that contains descriptions of data items stored in the database
  3. A DBMS should provide transaction support such that all or none of the updates corresponding to a particular transaction are made
  4. A DBMS should have concurrency control services to ensure the database is updated correctly when multiple users are updating it at the same time
  5. A DBMS should provide recovery services in case the database is damaged in any way
  6. A DBMS should provide authorization services such that only authorized persons are allowed access to the database
  7. A DBMS should provide support for data communication with hardware
  8. A DBMS should provide integrity services such that all the data and changes to the data follow pre-specified rules
  9. A DBMS should provide services to promote data independence from the actual structure of the database
17
Q

What are the disadvantages of database systems?

A
  1. Increased costs- they require sophisticated hardware, software and skilled personnel
  2. Management Complexity- Introduces changes to an organization that need to be properly managed to ensure they help advance the company’s objective eg new security issues must be handled
  3. Maintaining currency- Frequent updates are required and application for the latest patches and personnel training
  4. If the database is not properly backed-up and it fails all data is lost since the storage is centralized
18
Q

What are the advantages of database systems

A
  1. Improved data sharing - End users have access to more and better managed data
  2. Improved data security- A framework is provided for better enforcement of data privacy and security policies
  3. Better data integration- Wider access to well-managed data promotes an integrated view of the organizations operations and gives a clearer vision of the big picture
  4. Minimized data inconsistency- Data inconsistency is greatly reduced (Eg having different record s for Will Brown and William Brown yet they are the same person)
  5. Improved data access- makes i possible to produce quick answers to ad hoc questions
  6. Improved decision making- It’s possible to generate better quality information hence better decisions
19
Q

Discuss five factors you will consider when selecting a Database Management

A

1) Usability
Consider how user-friendly the system will be for all those members of staff required to use it.
2) Security
Security of your data is an essential aspect of any database implementation.
3) Scalability
Ensure that the system has the capacity to grow with your data and your business.
4) Efficiency
When we talk about the efficiency of DBMS, we usually mean the response time.
5) Implementation and Service Costs
The modifiability and availability of support and documentation needs to be taken into consideration as part of the implementation and Total Cost of Ownership

20
Q

Give three applications of databases

A
  1. In businesses to keep track of customer, staff, accounting information etc
  2. Keeping track of personal fitness eg using sport watches
  3. In education to keep track of student information
21
Q

Describe five properties of a relation in relational databases

A

Values are atomic.
All of the values in a column have the same data type.
Each row is unique.
The sequence of columns is insignificant.
The sequence of rows is insignificant.
Each column has a unique name.
Integrity constraints maintain data consistency across multiple tables

DATABASE SYSTEMS (14 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions