Skip to main content

what do you understand by the key attribute in the relational model?

What do you mean by key attributes in the relational model?

Key attributes in the relational database

  • The key attributes are the properties to separate the record in a unique or consistency form in the database of relational model.
  • When we applying the keys attributes on the relation the keys identify the records which has a specific value.
  • The key attributes are uses to find the characteristics of the records in the database.
  • As comparison to find the records by manually that is too slow to find the records.
  • The key attributes allows the consistency of the records when we apply on the database.
  • There are some types of key attributes in the database management system in the relational database. Such as primary key, composite key, super key, candidate key, foreign key and secondary key are uses in the relational model.
  • All of the key attributes are uses to uniquely identify the record in the relation.
  • All names of key attributes are related to their work.

Points to be remember about the key attributes in the relational model

  • It uses to separate the records from the database and identify.
  • It allows the consistency of the records form the database.
  • It is uses to find the records by using query to apply on the database.
  • If you have not unique identity to find your record in the relation you can use other properties such as two or more attributes combination to find the record by using query for key attribute. 

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