Skip to main content

The representation of the data and information from the relational database management system model

How can the relational database model be able to show their information and data from the database?

Describing the information from the database

  • The relational database made by some components are rows, columns, rows number, columns name, key attributes etc.
  • This database is made by the combination of rows and columns called cells in the model where the column direction is a vertical type data and rows direction is a horizontal type data.
  • To describe the information we can use queries command to take information of a particular record from the rows and the columns show their attributes of the record.
  • The records are searched by their unique identity of a particular record from the relational model which is known as a key attribute of the record.

Describing the data from the database

  • The data is raw in a database but in the combination of record and attribute, the data is meaningful data which is called information. 
  • The data is entered by the user in the database.
  • The data is entered by the user using queries or it can be updated, deleted and processed in the database for an application.
  • The data from a particular cell is also a description data about the records of an object and it can be an information of the object data. The description gives you information about the object where the column name is “description” and the data of the description cells are known as information of the object.
Labels:

Comments

Post a Comment

Popular posts from this blog

Discuss the role played by the various components of the CPU

Q Discuss the roles played by the various components of CPU? The CPU is the brain of the computer system. All major calculations, manipulations and comparisons are made by the CPU. The CPU is also responsible for activating and controlling the operations performed by all other units of the computer system. The major components of the CPU are: a) Arithmetic Logic Unit (A.L.U.) b) Control Unit (CU) c) Primary Memory Arithmetic Logic Unit (A.L.U.): What is ALU Arithmetic logic Unit? ALU is a part of the CPU. It is a part to calculate the logical term in the CPU where the term refers to an operation of logical type. It also calculates the arithmetic terms in the CPU where the term refers to an operation of arithmetic type. It is used to direct access through the processor controller. The ALU connected to the input and output peripheral system through the bus with the different types of bus. Such as control bus, data bus etc. ALU is a part of the CPU that can calculate the input...
Post a Comment
Read more

About the memory and its Classification of the computer Memory

What are the memories in the reference of computer system? What is Computer Memory?:- The memory is the essential for the computer to store the data, instruction and information. Without memory, computers are not be able to store data, instruction etc. The memory is an essential part of a computer system. It is require by the computer system to store information. Memory can be divided into the following two categories types: i) Primary or Main memory ii) Secondary Memory or Permanent memory In this figure I'll show the classification of the memory of computer system peripheral and architecture of organisations Primary Memory or Main memory:- i) Primary memory is the memory which is fastest memory of the computer. ii) It is a small but relatively fast storage unit that stores data and instruction which are used by the CPU (central processing unit). iii) This type or category of a memory is the main memory of the computer.It is a temporary memory and also we ...
Post a Comment
Read more

What are the three main purpose of an operating system?

What are the three main purpose of an operating system? There are three main purpose of an operating system. 1. The first main purpose is User interface between hardware and users. 2. The second main purpose is to operate the internal parts of the computer properly and systematically using binary code system in the form of 0 and 1. 3. The third main purpose is to provide an environment for development of an application software and program to uses the hardware resources of the computer and connected to the computer parts which provides output to the user, the output from application software is very useful for users. Interface between user and hardware device  The operating system uses all types of interface such as command line interface, batch command interface and Graphical User Interface to interact with users to hardware peripheral devices through the monitor screen. Monitor has a big role making interface between hardware and users. Monitor visualization of all types ...
Post a Comment
Read more