discuss the difference between hierarchical and relational database model?

Let us discuss the difference between hierarchical model and relational database model?

Hierarchical model

Hierarchical model is tree like structure.

In the structure where the parent is only one parent in all over structure organization of any object. The parent who has no parent in the structure is also known as grandparent.

In the structure the child quantity is two or more than two in numbering.

The base of the hierarchical model is inheritance of the hierarchical character which means the hierarchical character relates as inherit their properties in the form of one to many relation.

The hierarchical structure shows the connection using connection line in the model.

discuss the difference between hierarchical and relational database model?

Image reference of the hierarchical model of the basic components in their structure model

In the given model there are three layers of the hierarchical model shows in the image. From the top to bottom direction first layer is the “grand parent”, second is “parent family” and third one is “children family”. In the model you can also add the layer at the top of the grand parent is the “great grandparent” above the grandparent layer.

Now back to the main point the children family is minimum attribute of every child entity. So you can say it is also called lowest class entities in the whole model that works for the parent entities which is connected to the parent family layer.

The parent family is more than higher level entity in the whole model that work for grandparent layer or family. The parent family is the more advance than the children family entities that smartly.

In the grandparent class level that makes a final decision of the whole database structure to operate the whole system according to the hierarchical model. You can say the grandparent is the root of the higher level of the database is called highest level database in the structure.

Relational model

The relational model is a table like a structure.

There is no parent in the model because in the relation there are group of records which has own unique identity of every records object data recorded in the tuples one by one.

In the structure the attributes of a record can create in large number of quantity for every record.

The base of the relational model is matrix structure which is called the combination attribute and a record. It is in the tabular form where the record is in the horizontal direction and the attribute is vertical direction. The cross connection of the attribute and record is a cell.

The unique identity is a primary key or serial number of a record to identify.

Comments

Discuss the role played by the various components of the CPU

Q Discuss the roles played by the various components of CPU? The CPU is the brain of the computer system. All major calculations, manipulations and comparisons are made by the CPU. The CPU is also responsible for activating and controlling the operations performed by all other units of the computer system. The major components of the CPU are: a) Arithmetic Logic Unit (A.L.U.) b) Control Unit (CU) c) Primary Memory Arithmetic Logic Unit (A.L.U.): What is ALU Arithmetic logic Unit? ALU is a part of the CPU. It is a part to calculate the logical term in the CPU where the term refers to an operation of logical type. It also calculates the arithmetic terms in the CPU where the term refers to an operation of arithmetic type. It is used to direct access through the processor controller. The ALU connected to the input and output peripheral system through the bus with the different types of bus. Such as control bus, data bus etc. ALU is a part of the CPU that can calculate the input...

About the memory and its Classification of the computer Memory

What are the memories in the reference of computer system? What is Computer Memory?:- The memory is the essential for the computer to store the data, instruction and information. Without memory, computers are not be able to store data, instruction etc. The memory is an essential part of a computer system. It is require by the computer system to store information. Memory can be divided into the following two categories types: i) Primary or Main memory ii) Secondary Memory or Permanent memory In this figure I'll show the classification of the memory of computer system peripheral and architecture of organisations Primary Memory or Main memory:- i) Primary memory is the memory which is fastest memory of the computer. ii) It is a small but relatively fast storage unit that stores data and instruction which are used by the CPU (central processing unit). iii) This type or category of a memory is the main memory of the computer.It is a temporary memory and also we ...

What are the three main purpose of an operating system?

What are the three main purpose of an operating system? There are three main purpose of an operating system. 1. The first main purpose is User interface between hardware and users. 2. The second main purpose is to operate the internal parts of the computer properly and systematically using binary code system in the form of 0 and 1. 3. The third main purpose is to provide an environment for development of an application software and program to uses the hardware resources of the computer and connected to the computer parts which provides output to the user, the output from application software is very useful for users. Interface between user and hardware device The operating system uses all types of interface such as command line interface, batch command interface and Graphical User Interface to interact with users to hardware peripheral devices through the monitor screen. Monitor has a big role making interface between hardware and users. Monitor visualization of all types ...

computers-achievers

Search This Blog