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
Lossless-Join Decomposition   Let us show an intuitive decomposition of a relation. We require a better basis for deciding decompositions since intuition may not always be r

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0.      Set up database tables and account file

Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

A database is to be constructed to remain track of the teams and games of a sport league. A team has a number of players, not all of whom participate in every game. It is desired

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined

Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additi

What are the features of embedded SQL? Explain. Embedded SQL - SQL could be implemented within two ways. It can be used interactively or embedded in a host language or throu