Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Software - Coggle Diagram
Database Software
Relational Databases
A database which structures data in the form of tables.
Each table contains information relevant to a particular feature
Tables are linked to other tables by a common value
Advantages
Data only has to be input once
Saves time and money
Saves on file size
Things are stored only once
Improved data consistency
No risk of the same attributes being stored in a different format in a different file
Flexibility
Tables can be combined and queried in a greater number of ways
Improved data integrity
There is no need to change data in more than one table
Improved data redundancy
No piece of data is unnecessarily repeated
Flat File Databases
A flat-file database is a simple database that stores all data in a single table
Useful for storing data such as a list of contact names and addresses
Advantages
Easy to understand
Simple to set up
Disadvantages
Errors on Input
Data is more likely to be inaccurate
Inconsistent data entry
Difficult to Update Data
If entries change, all instances have to be updated
Redundant Data
Large amounts of duplicated data
Makes data entry slower
Uses disk space
Difficult to Modify Data
If new entries are needed they cannot be added immediately
Security
All users have access to the same set of data
Program-Data Dependence
The user interface is tied to a specific file
What is a Database
A collection of organised data which has structure to aid retrieval
It can be paper-based or computer based
Database Management Systems keep the data separate from the programs
Reports
A report is a printout of the results from a database
Reports make the data printed more presentable and easier to understand
Reports can group and summarise data to provide an organised view of the data
Query
Finds data which matches a certain criteria that has been inputted
SQL enables the user to determine what data is to be extracted and from what tables