Record based logical models, Database Management System

Record based Logical Models: Use records as the key data representation components

Examples:

Relational Model: It shows data as well as relationship between data in the form of tables.

Constraints are stored in a meta-data table. This is a very easy model and is based on a proven mathematical theory. This is the most usually used data base model.

Network Model: In this model data is shown as records and relationship as links. A easy network model example is explained in Figure . It shows a sample diagram for such a system. This model is a very good quality model as far as conceptual framework is concerned but is today not used in database management systems.

Posted Date: 3/6/2013 5:08:32 AM | Location : United States







Related Discussions:- Record based logical models, Assignment Help, Ask Question on Record based logical models, Get Answer, Expert's Help, Record based logical models Discussions

Write discussion on Record based logical models
Your posts are moderated
Related Questions
Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.

Describe Specialsation and generalization? Specialisation /generalization: This is a top down and bottom up approach to the design of database. It displays the IS_A relation

An entity type usually has an attribute whose values are distinct for every individual entity in the collection. Such an attribute is known as a key attribute and its values can be

Discuss the mechanism to read data from and write to a disk? Disk read/write heads are mechanisms in which read data from or write data to disk drives. The heads have gone by

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

Explain I command in QBE ? I : It is the command in QBE that is used to insert tuple (s) into the database

Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

What is the difference among a database schema and a database state? The collection of information stored in database at particular moment in time is known as database state a

Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve