Skip to main content

Logical database model and Relational database management system-computer world

 Logical Database model

The logical database models are used in describing data at the conceptual and view level.However in contrast to conceptual database models, these model are to specify the overall logical structure of the database .These model are also known as record based logical database models. In the record based logical database models, the database is structured in fixed format re-cred of different types.Each record type define a fixed numbers of fields, or attributes an each field is of a fixed length.

Relational database management system

Relational database management system(RDBMS) is a software package used to store and retrieve data that is organised in the form of tables. Relational database management system, where all data are kept in tables or relations. Relational database management system are much more flexible and easy to use, in the comparison to other models.


A Relational database management system(RDBMS) has following properties : 

  1. It store data in the form of table.
  2. It support the concepts of null value. 
  3. It does not require the user to understand it's physical implementation. 

A table should contain the following properties : 

  1. All rows in a table should be distinct, duplicate row are not allowed. 
  2. Each column should be assigned with a distinct heading. 
  3. The rows and the column of a table can be viewed in any sequence at any time without affecting the information. 



Comments

Post a Comment

Popular posts from this blog

Deadlock in operating system-computer world

  Deadlock in operating system-computer world Deadlock :  In a multi-programming environment, many process may complete for a minute number of resources. A process make a request for a resource and if the resource is not available at that time, the process enter In a waiting state. A waiting state process is never again-able to change state because the resource it has requested is held by other waiting process. This situation is called deadlock. So we can say that a process is said to be deadlock when it is waiting for an event or resources which will never occurs.   so we can say that in this situation none of the process gets executed  since the resource it needs, is held by some other process which is also waits for some other resource to be released.  Let's assume that there are three process P1, P2, p3 and three different resources R1, R2 and R3. R1 is assigned to p1, R2 is assigned to P2 and R3 is assigned to P3.   After sometime P1 demands for R1 which is being used by  P2.
9 comments
Read more

What is sound card, video card, TV tuner card and network adapter card-computer world

 What is sound card, video card, TV tuner card and network adapter card Sound card :  Sound card is also known as audio card, sound sound board or audio output device. Sound card is a expansion card that provide the input and output of audio signals to and from a computer under control of computer programs. It is an expansion card for producing sound on computer that can be heard by speakers and headphones.  Uses of sound card :  Sound card is used for for providing the audio component  for multimedia application such as video auditing , audio auditing .It is also used in the field of education.  Video card :  It is an expansion card that connect to a computer motherboard. Video card is also known as video adapter or video controller. It is used to create a picture on display. TV tuner card : A  TV tuner card is like a television tuner that allow single to be received by a computer. TV tuner card have a function which is known as video capture card that is used for record the televisio
2 comments
Read more

Memory management in operating system-computer world

Memory management in operating system-computer world Memory management :   The function of operating system which manages the memory of a computer for the processing of the program this management is known as memory management. There are several programs that consist in memory, so it became to move programs and data around the memory of a memory management system is the collection of hardware and software procedures for the Managing various program consisting in the memory. Memory management play an important role in operating system to improve the speed speed of the computer system.   Memory management determines how  memory is allocated between the processes,  deciding which gets memory, when they receive it and how much they are allowed. When memory is allocated it determines which memory location will be assigned. Main memory refers to a physical memory that is the internal memory of the computer. Main memory is also known as RAM. The computer is able to change only data that is in
1 comment
Read more