Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Transcript of Databases
By Matthew Shore, Thomas Bartlett and Dan
What is a Database?
A database is a persistent and organized store of data.
This is a presentation on databases.
Types of Databases
There are two main types of databases. The first type of database is what is known as a Computerized database. An example of a Computerized database would be the SIMS database that the school uses. The second type of database is known as a paper-based database. An example of a paper-based database would be the homework diary's that we have.
Advantages/Disadvantages of a computerized database
Advantages and Disadvantages of a paper based database
Advantages of a paper based database
It is simpler than a computerized database
There are less potential problems
If a computerized database has a problem then it can be much more complicated to fix than a paper based database
Uses of a Computerized Database
Some clear examples of a computerized database are SIMS or I-Tunes. These are normally used to store a large amount of data for an electronic based service where only certain information is accessible for different users. These databases can also be used in a workplace to store the information of employees or clients for fast, on demand, availability .
Flat File Database
A flat file database is a database that holds all of it's data in one big table, some examples include a vet appointment system which would include a telephone number. This has the potential problem of data duplication. This is where data can be accidentally duplicated, taking up more space which is unneeded and also making search results more complicated.
Relational Databases are a group of tables that have been linked together. Relational databases tend to be better than flat-file databases as they allow for more detail and more variations
Glossary of Keywords to Remember
Advantages of a computerized database:
Computerized databases can be re-edited.
Very fast to find a specific record.
Can store vast amounts of information.
Records are stored safely and are available when needed.
Easy to make back ups of the data.
Disadvantages of a computerized database:
Could be more complicated than a paper-based databases.
Can sometimes be more expensive.
Can be corrupted/destroyed easily.
Disadvantages of a paper based database:
Hard to edit.
Slower to find a specific record.
Can't store vast amounts of information in a small area.
The physical copies can be lost
Can't make back ups of the data.
Field: a row of data.
Record: a field.
Database: an organized set of data in a table.
Computerized database: a database on the computer.
Paper database: a database written on paper.