



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
An introduction to Database Management Systems (DBMS) and discusses various database models, including Hierarchical, Network, Relational, Object Oriented, and Entity Relationship models. the key features and real-world applications of each model, such as the hierarchical tree structure of Hierarchical Model, the graph structure of Network Model, the two-dimensional table structure of Relational Model, the object-oriented features of Object Oriented Model, and the conceptual design of Entity Relationship Model.
Typology: Assignments
1 / 5
This page cannot be seen from the preview
Don't miss anything!




Database Management System DBMS (Database Management System) is a software package designed for defining, manipulating, retrieving and managing data in a database. Generally, data, the data format, record structure, filed names and file structure are manipulated itself by a DBMS. The rules are defined to validate and manipulate the data by database management system. Database Model Database model can be defined as a representation or logical structure of a database and the data within it will be stored, managed and processed. A database can be designed with its help which while creating a database serves as blueprint for application developers and data administrators. There are various database models and some of the most popular database models include: Hierarchal Model Network Model Relational Model Object Oriented Model Entity Relationship Model [ CITATION tecnd4
l 1033 ]
1. Hierarchal Model: This model is the first model of DBMS where the data are organized in the hierarchal tree structure. In 1968, IBM developed this model and was introduced in Information Management System (IMS0. The hierarchy begins from the root having root data which later develops as tree where child node is added to the parent node. Some of the real-world relationships can be represented by this model such as recipes of food, site map of websites and many more. For instance: The relationship between the shoes that is present in the shopping website can be represented as:
2. Network Model: Network model was one of the most popular models before the relational model and it is also the extension of hierarchical model. Network model and Hierarchical model are same except for the fact that more than one parent can be taken by the record. The hierarchical tree is replaced with a graph by it. For instance: We can see in the picture below that there are two parents of node student which are parent 1 as CSE department and parent 2 as Library. Network model is simply an improved version of the hierarchical model where among the records, we can have many to many relationships (M:M). 3. Relational Model: Relational model, the most widely used model of DBMS maintains the data in form of two-dimensional table. The information stored by this model is in form of row and columns. Tables are the basic structure of a relational model due to which relations in relational model are identified as tables. Data about specific instance of an entity in question are listed in each row, which are termed as tuple. Example; an employee. The relationships between those tables are also accounted by this model which includes relationships such as one-to-one, one-to-many, and many-to-many. Emp_id Emp_name Job_Name Salary Mobile_no Dep_id Project_id AfterA001 Sundar Engineer 100000 9806778313 2 99 AfterA002 Saajan Analyst 100000 9816192218 3 100 AfterA003 Anshu Manager 100000 9806640845 2 65
5. Entity Relationship Model Similar to that of network model, this model also captures the relationship between real-word entities but the physical structure of database isn’t directly tied with the model. Instead, the database is designed using this model conceptually. In this model, the people, places and things about which data points are stored are indicated as entities and each of the entity contains a certain attribute that make up their domain collectively. Also, the relationships or cardinality amongst the entities are mapped.
Star Schema is a common form of ER diagram where a central fact table is connected to multi- dimensional tables. [ CITATION lucnd \l 1033 ] To work with the different kinds of databases, various kinds of DBMS software such; Microsoft SQL Server, MySQL, MS Access, phpMyAdmin, Oracle database etc. can be used. The selection of DBMS software depends on the type of database that the developers will be using and other various factors.