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

What is web browser-computer world

                    What is web browser Web Browser A web browser is a program that your computer runs to communicate with web servers on the internet. Web browser must understand HTML and display text. Web browser are interpreter of HTML language web pages are HTML document send by server on client request and after reaching this document to client side the web browser intro parrots this HTML document in graphical interface.  Web client run Special software called a browser that allow them to  Connect to an appropriate server Query the server for the information to be read.   Provided and interface to read the information returned by the server. web Browser are software installed on your PC. To Excess the you need a web browsers, such as Netscape navigator, Microsoft Internet Explorer or Mozilla Firefox. There are four leading web browser Explorer, Firefox, Netscape and Safari but there are some other browsers a...
Post a Comment
Read more

What is computer and its characteristics-computer world

  What is computer and its characteristics  Computer  :  Computer is an electronic data processing device, which accept and store data input, process the data and generates the output in a required format. computer is made up of integrated  parts (input, control, ALU, storage and output unit) All the part work together to process data so, we can say that a computer is a programmable electronic device accept row data as input and process it with  set of instruction to produce the result as output. Meaning of computer The word "computer" comes from the word "compute" which means to "calculate". The word computer is derived from the Latin word compute which means to calculate. Characteristics of computer Automatic : It is a automatic machine work by itself without human instruction. Speed :  A computer is a very fast devices. It can perform in a few second, the amount of work that a human being can do in an entire year.  Accuracy : In addition t...
1 comment
Read more