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
let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

1. Explain different addressing modes of 8086 Explanation of all addressing modes 2. Write a sequence of instructions to exchange two register contents using stack

Explain the Aggregation implies concurrency Concurrency actually is: This in objects can be identified by the way they change state. Present objects can change state independen

Multi-list file Organisation Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical orderin

Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include

Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series

Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo