CIS_0002 - Introduction to Database Management Systems Mathew Tams [email protected] [email protected] Fall 2016 CIS 3352 1 Database A database is an

CIS_0002 - Introduction to Database Management Systems...

This preview shows page 1 - 12 out of 38 pages.

Fall 2016 CIS 3352 1 Introduction to Database Introduction to Database Management Systems Management Systems Mathew Tams [email protected] [email protected]
Image of page 1
Fall 2016 CIS 3352 2 Database Database A database is an organized collection of information The benefit of storing information in a database is to make data easy to access and manage. Users interact with the database through a predefined language.
Image of page 2
Fall 2016 CIS 3352 3 Motivation Motivation Organisations are increasingly aware of the importance of information in the solution of their problems. Because of decreasing cost of data storage, organisations store increasing quantities of data. This data must be managed in the most efficient and effective manner.
Image of page 3
Fall 2016 CIS 3352 4 The Database Approach The Database Approach Organizations must have access to operational data that is accurate timely convenient up-to-date secure but available As control decentralizes in an organization, there is a danger that data management decentralizes as well.
Image of page 4
Example of Student Data Example of Student Data Fall 2016 CIS 3352 5
Image of page 5
Database before computers Database before computers Data was stored in: books ledgers card files folders file cabinets Fall 2016 CIS 3352 6
Image of page 6
Database storage in computer Database storage in computer age age Fall 2016 CIS 3352 7
Image of page 7
DBMS vs RDBMS DBMS vs RDBMS The software application that enables the users to store the data is known as a database. In database architecture, there are different implementations and theories in order to store physical data. The database which stores data in the tables that have relationships with other tables in the database is called RDBMS or Relational Database Management System. However, in DBMS or Database Management System, there are no relation among tables Fall 2016 CIS 3352 8
Image of page 8
Some DBMS Some DBMS Banking Airlines Universities Credit card transactions Tele communication Finance Sales Manufacturing Human resources Fall 2016 CIS 3352 9
Image of page 9
DBMS vs RDBMS DBMS vs RDBMS Relationship among tables is maintained in a RDBMS whereas this not the case DBMS as it is used to manage the database. DBMS accepts the ‘flat file’ data that means there is no relation among different data whereas RDBMS does not accepts this type of design. DBMS is used for simpler business applications whereas RDBMS is used for more complex applications. Although the foreign key concept is supported by both DBMS and RDBMS but its only RDBMS that enforces the rules. RDBMS solution is required by large sets of data whereas small sets of data can be managed by DBMS. Fall 2016 CIS 3352 10
Image of page 10
History History
Image of page 11
Image of page 12

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture