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
Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there

What are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha

Explain the Project-Join normal form A relation R is in PJNF along with respect to a set of functional dependencies D if for all join dependencies of the outline *(R 1 , R 2 ,

Need a sample of a clinic database relationships

What is disadvantage of multiple inheritances? There is potential ambiguity if the similar variable or method can be inherited from more than one superclass.eg: student class m

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

Normalize the given relation to 3NF, justifying each step

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

Conflicting Operations in Schedule: The three simple ways of interleaved instruction implement of transactions T1 and T2. Please note that in the following tables the first col

Can we delete data element, which is being used by table fields. No we cant delete data element.