Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start 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

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

DATABASE SYSTEMS

No description
by

Kehinde Afolabi

on 1 October 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of DATABASE SYSTEMS

What is a Database
"a structured set of data held in a computer, especially one that is accessible in various ways"
About them?
Databases
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
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.



Database
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.
DATABASE SYSTEMS
Relational Database
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
Full transcript