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 DATABASE SYSTEMS
"a structured set of data held in a computer, especially one that is accessible in various ways"
are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables . If youre familiar with spreadsheets like Microsoft Excel, youre probably already accustomed to storing data in tabular form, like we did in lesson on Excel about storing names and adresses in lesson.
DBMS NOT BDSM, is collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. examples of database applications,computerized library systems automated teller machines, flight reservation systems,computerized parts inventory systems
Types of Database
Flat File and Relational Databases.
Flat File Databases
Flat-File databases hold all of their data in one table only and they are only suitable for very simple databases. The problems with them are Duplicated Data is often unnecessarily entered, Database space is wasted with this duplicated data, Duplicated Data takes a long time to enter and update or in other words all of this is Data Redundancy.
It means all of the information is together. The information can be portable if on a laptop. The information is easy to access at any time. It's more easily retrievable. Many people can access the same database at the same time. Improved data security. Reduced data entry, storage, and retrieval costs. Some disadvantages Database systems are complex, difficult, and time-consuming to design. Initial training required for all programmers and users. Suitable hardware and software start-up costs. A longer running time for individual applications.
Relational Databases use two or more tables linked together (to form a relationship), Relational Databases do not store all the data in the same table. The advantages of using a relational database over a Flat File database is the, Duplicated Data is reduced, Database space is not wasted, Quicker to enter Data as there are less duplicates, Quicker to update Data