Skip to main content

Types of DBMS

Types of DBMS


According to the structure the DBMS is divided into four categories:
1. Hierarchical Database
2. Network Database
3. Relational Database
4. Object-oriented Database
1. Hierarchical Database – In hierarchical database, records contain information about their groups of parent or child relationship just like as a tree. The structure implies that a record can have repeating information.

2. Network Database – A network databases are mainly used on large digital computers. A network database model is a database model that allows multiple records to be linked to the same owner file. The network database follows many to many relationship model, and because of many to many relationship model network database model can easily access any table record in the database. It is easier to navigate and search for information because of flexibility. It is suitable in complex data because of the multiple relationship founded among its data.

3. Relational Database – The relational database is a digital database on the relational model of data, as proposed by E.F. Codd in 1970. A software system used to maintain relational database is Relational Database Management System (RDBMS). Virtually all RDBMS use SQL for querying and maintaining the database.
This model organizes data into one or more tables of columns and rows, with a unique key identifying each row. Rows are also called records or tuples. Columns are also called attributes. Generally, each table represents one "entity type" (such as customer or product). The rows represent instances of that type of entity (such as "P001" or "Mark") and the columns representing values attributed to that instance (such as Product number or Product name).

4. Object Oriented Database – An Object Oriented Database is a database management system in which information is represented in the form of objects as used in object oriented programming (OOP).
OODBMS is the combination of Relational Database and Object Oriented Programming (OOP). In OODBMS every entity is considered as class and every attribute of entity can be accessed by an object.

Labels:

Comments

Post a Comment

Students you can ask your doubts in comment section

Popular posts from this blog

Bit by Bit | Chapter 6 - Graphics and Sound in QB64 | QBasic | Class 7 CBSE | Computer Application

Bit by Bit | Chapter 6 - Graphics and Sound in QB64 A. Tick the correct option. 1. (d) screen mode 0 2. (b) 640 x 350 3. (d) White 4. (a) Lower-Right 5. (c) PSET 6. (c) Generate a tone for a short duration B. Fill in the blanks. 1. CIRCLE 2. PAINT 3. PLAY 4. Graphic 5. Pixels 6. Box C. True or False. 1. True 2. False 3. False 4. True 5. True 6. True D. Answer the following questions. 1. What is the use of SCREEN statement? The SCREEN statement is used to set the screen mode for displaying graphics. There are many screen modes and each screen modes have their own number which is from SCREEN 1 to SCREEN 13. The various screen modes differ in resolution. 2. What is a pixel? How is it related to resolution? The graphics which is displaying on the computer screen is made up of thousands of dots called pixel. Pixel stands for picture element. The number of pixels in an image determines the resolution of the image. Higher the resolution, cleaner the image will appear. 3. What is the differenc...
Post a Comment
Read more

Q & A Chapter 1 | Internet Basics | Class 10 CBSE | Computer Application

 Q & A of Chapter 1 Internet Basics A. Tick the correct options – 1. (b) TCP/IP 2. (a) Internet Service Provider 3. (a) URL 4. (b) HTTP 5. (a) Bridge 6. (a) home page 7. (d) All of these 8. (b) Domain Naming System 9. (b) Rules 10. (d) ARPANET B. Very Short Answer Type Questions – 1. In the URL http://www.myfirm.co.in/about.html , what do the following components depict? (a) http                                                 (b) in (a) Http represents a type of server and the protocol on the Internet (b) ‘in’ represents the domain extension of the website. 2. In the URL http://www.favmusic.com/contactus.html what does www.favmusic stand for? www.favmusic represents the domain name i.e. favmusic in www. 3. W...
Post a Comment
Read more

Bit by Bit | Chapter 3 Working with Queries, Forms and Reports | Class 8 CBSE | Computer Application

Working with Queries, Forms and Reports Exercise Solution A. Tick the correct option – 1. (d) Datasheet View 2. (c) Three 3. (c) Four 4. (b) Datasheet View 5. (d) Filter 6. (b) Create B. Fill in the blanks – 1. Query 2. Form 3. Objects 4. Design 5. Report 6. Result C. State True or False – 1. T 2. F 3. T 4. T 5. F 6. T D. Answer the following questions – 1. What is Query? A query is a method of getting answers to questions on data. It is used to retrieve selective data satisfying specific criteria. 2. Differentiate between Form and Report. Forms allow you to add and update data in a table, one record at a time, while reports are an effective way to present data in printed format. You can customize the appearance of tabular data on a report. 3. How can you specify multiple conditions while designing a query? Specifying the condition in the Criteria row for more than one field will result in a query that will select only those records...
Post a Comment
Read more