Fall 2016CIS 33522DatabaseDatabase–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.
Fall 2016CIS 33523MotivationMotivationOrganisations 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.
Fall 2016CIS 33524The Database ApproachThe Database ApproachOrganizations must have access to operational data that is–accuratetimelyconvenient–up-to-date–secure but availableAs control decentralizes in an organization, there is a danger that data management decentralizes as well.
Example of Student DataExample of Student DataFall 2016CIS 33525
Database before computersDatabase before computersData was stored in:–books–ledgers–card files–folders–file cabinetsFall 2016CIS 33526
Database storage in computer Database storage in computer ageageFall 2016CIS 33527
DBMS vs RDBMSDBMS vs RDBMSThe 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 tablesFall 2016CIS 33528
Some DBMSSome DBMSBankingAirlinesUniversitiesCredit card transactionsTele communicationFinanceSalesManufacturingHuman resourcesFall 2016CIS 33529
DBMS vs RDBMSDBMS vs RDBMSRelationship 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 2016CIS 335210