Diagnosis . Object Model Object model stores the data in the form of objects, attributes and methods, classes and Inheritance. This model handles more complex applications, such as Geographic information System (GIS), scientific experiments, engineering design and manufacturing. It is used in file Management System.
It represents real world objects, attributes and behaviors. It provides a clear modular structure. It is easy to maintain and modify the existing code. Circle Radius Shape () () Rectangle Length breath O bject Model Fig.
. Triangle Base Height An example of the Object model is Shape, Circle, Rectangle and Triangle are all objects in this model. • Circle has the attribute radius. • Rectangle has the attributes length and breadth.
• Triangle has the attributes base and height . • The objects Circle, Rectangle and Triangle inherit from the object Shape. . .
Types of DBMS Users Database Administrators Database Administrator or DBA is the one who manages the complete database management system. DBA takes care of the security of the DBMS, managing the license keys, managing user accounts and access etc. 12th Computer Chapter - - Database Concepts Application Programmers or Software Developers This user group is involved in developing and designing the parts of DBMS. End User All modern applications, web or mobile, store user data.
Applications are programmed in such a way that they collect user data and store the data on DBMS systems running on their server. End users are the one who store, retrieve, update and delete data. Database designers: are responsible for identifying the data to be stored in the database for choosing appropriate structures to represent and store the data. Difference between DBMS and RDBMS .
Basis of Comparison DBMS RDBMS Expansion Database Management System Relational DataBase Management System Data storage Navigational model ie data by linked records Relational model (in tables). ie data in tables as row and column Data redundancy Present Not Present Normalization Not performed RDBMS uses normalization to reduce redundancy Data access Consumes more time Faster, compared to DBMS. Keys and indexes Does not use. used to establish relationship.