Data model is a way of storing and retrieving the data. There are three different data models. Data models differ in the way they allow users to view and manipulate relationships between entities. Each has its own way of storing the data. The following are the three different data models:
In this model, data is stored in the form of a tree. The data is represented by parent-child relation ship. Each tree contains a single root record and one or more subordinate records. For example, each batch is root and students of the batch will be subordinates.
This model supports only one-to-many relationship between entities.
This was used in IBM’s Information management system, IMS.
Data is stored along with pointers, which specify the relationship between entities. This was used in Honeywell's Integrated Data Store, IDS.
This model is complex. It is difficult to understand both the way data is stored and the way data is manipulated. It is capable of supporting many-to-many relationship between entities, which hierarchical model doesn’t.
This stores data in the form of a table. Table is a collection of rows and columns. We will discuss more about relational model in the next second.
There is given sql interview questions and answers that has been asked in many companies. For PL/SQL interview questions, visit our next...
1.Write a program to print the following format WELCOME TO PL/SQL PROGRAMMING BEGIN DBMS_OUTPUT.PUT_LINE('WELCOME TO PL/SQL PROGRAMMING...
Step1) Write the PL/SQL code in the note pad and save it as with extension name .sql ex: "test.sql" DECLARE x NUMBER; BEGI...
DECLARE emp_name_c CHAR(32); emp_name_v VARCHAR(32); BEGIN emp_name_c := 'sateesh.bagadhi'; emp_name_v := 'sateesh.ba...