Basic Database Concepts Flashcards
What is an integrated database?
A combination of several otherwise distinct files without any redundancy
What is a database system?
A computer based system to record and maintain information
What is a shared database?
The sharing of data by different users
What is data in a database?
The actual stored descriptive information
What is a metadata?
Describes the structure applied by the database
What is a file-based system?
A collection of application programs that performs services for end users, defining and managing it own data
What is Isolation of Data?
Data kept in different locations, unrelated formats causing under utilisation and inaccessibility.
What is Duplication of Data?
Same data held by different files/programs that leads to updating difficulties and data redundancy
What is Data dependence?
The way the file is structured that is independent of the processes that works with the data
What is Incompatible file format?
Where programs that are written in different languages/format cannot easily access other files
What is the problem with having NO PROVISION FOR SECURITY OR INTEGRITY?
Recovery is limited or non-existent
What are the concerns with File-based systems?
Isolation of data, Duplication of data, Data dependence, Incompatible file format and No provision for security or integrity.
What are the advantages of having a DBMS
Independence of data ad program, Data sharing and non redundancies of data, Integrity, centralised control, security and Performance and Efficiency.
What are the disadvantages of a DBMS
Complexity, Size, Cost, Additional hardware costs, Conversion costs, Performance and Higher impact of failure.
What are the advantages of DBMS over a file-based systems
More information from the same amount of data, Better data consistency, Control of data redundancy, Better sharing of data and an integral system
