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

Single partition allocation, Multiple-partition allocation and Fixed Equal-size partitions in operating system-computer world

  Single partition allocation, Multiple-partition allocation and Fixed Equal-size partitions in operating system Single partition allocation In this scheme operating system is residing in law memory and user process are executing in higher memory. Advantages It is simple  It is easy to understand and use Disadvantages User job is limited to the size of available memory. It leads to poor Utilization of processor and memory. Multiple-partition allocation  It is the simplest method for allocating  memory is divided memory into several fixed size partitions. Fixed Equal-size partitions It divides the main memory Into equal number of fixed sized partitions, operating system occupies some fixed portion and remaining portion of main memory is available for user processes. Advantages It supports multi programming. A process whose size is less then or equal to the partitions size can be loaded into any available partition. Disadvantages If a program is big to fit in...
Post a Comment
Read more

Memory in computer (primary, secondary and cache memory)-computer world

  Memory : A memory just like a human brain.It is used to store data and instructions. Computer memory is the storage space in the computer, where data is to be processed and instruction  required processing are stored. Computer memory is classified into following types : 1. Cache memory : Cache memory is a very high speed semiconductor memory which can speed up the CPU. It act as buffer(small storage are ) Between the CPU and main memory. We can say that it is a high speed memory between CPU and RAM and it is used temporary store very active data and instruction during processing.  2. Primary memory : Primary holds only that data and instruction on which the computer is currently working. Data holds by primary memory is lost when power is switched of. Primary is not fast as resisters. Primary is divided into two subcategory's : 1. RAM(Random access memory) : Random access memory is a form of computer memory that can be read and change in any any order typically ...
Post a Comment
Read more

Definition of computer cables and types of cables

Definition of computer cables and types of cables Definition  of computer cables : A cable is one or more wires which are covered in plastic that transmitter power or data between devices and computers. A cables is also known as cord, connector or plug. Data cables provides communication between devices for example DVD and HDMI, USB cables and Cat 5. A power cable is used for supply the power and electricity. Types of cables : There are many types of cables used in computer science some of them are given below : Coaxial cable Twisted cable Optical cable Coaxial cable :   It is consist of a central copper wire surrounded  by a copper mess.  Coaxial cables are used for transmitting data at high rate. Coaxial tables are used by telephone companies to transmit data because cables handle  up to 40000 telephone calls simultaneously. Coaxial  cables group of specially wrapped and insulated wires.   Twisted pair cab...
Post a Comment
Read more