Skip to main content

What do you mean by tuple and attribute? Discuss the role of the tuple and attribute in the Database? Why tuple and attribute are important in the database?

What do you mean by tuple and attribute? Discuss the role of the tuple and attribute in the Database? Why tuple and attribute are important in the database?

Tuple 

What do you mean by tuple and attribute? Discuss the role of the tuple and attribute in the Database? Why tuple and attribute are important in the database?

Image reference of the relational database example of tuple and attributes

In the image of relational database example diagram shows the tuple of table or relation, the tuple is called record of any object in the real. The attribute is also shown in the image of the relational database example, the attributes are shown such as student name, subject name are English, Physics etc. are the properties of the one record or tuple in the image relational diagram.


  • Tuples are the rows in the database.
  • It contains the records.
  • Records are the different to each other in the database.
  • Tuples have their properties in the rows containing records.
  • Records of the tuples are different to each other because of their features.
  • The different features of the records takes uniquely identify.
  • It can be manipulated.
  • It can be retrieve.
  • It can be update, select, insert and apply all operations which may be possible in the record.
  • It can be processed for optimizing in searching process.

Attribute

  • Attributes are the properties of the record of the tuple.
  • The attribute shows the records of the tuples are different to each other in the database.
  • In according to attribute the database can be separated and makes a new database.
  • In the attribute the calculus operations can be apply for processing the data of the record.
  • Key attributes can be applied in the fields of the records.
  • The primary key attribute can be uniquely identified of every record of the database.
  • The attributes helps to search easily of the record in the database.
  • It helps optimized the record with data of the description attribute.
  • Attributes shows the properties of the tuples.

Discuss the role of the tuples and attributes in the database?

  • Tuples of the database are one dimensional record.
  • Tuples are follows the one direction in the horizontal way.
  • Tuples holds every type of data types.
  • The entries of the attributes in the tuples are uses generally characters data type.
  • The entries of the attributes are unique in the database but same for every record of the data such as same gender, same department and same classes etc.
  • Database can be changed according to their attribute of the record.
  • Attributes are makes relationships to the other relational database.

Why Tuples and attributes are important in the database?

  • Tuple and attribute makes the two dimensional database.
  • Without tuple and attribute the database cannot be created and also the relational database.
  • The table DBMS are created by the tuples and attributes.
  • The cross section of the tuple and attribute makes cell in the table DBMS.
  • Tuple makes relation to other table database and attribute makes properties relations in the table DBMS to another database.
  • Attributes are makes group of the tuple of the record with their same attribute or properties or features.

-----------------------------------------------------------------------------------------------------------------------------

My latest post is here links below about the databases technology

What are the components of data model in [DBMS] Relational Database Management System?

There are five main components of data model... 👉 click here ðŸ‘ˆ

What is stability of the distributed database management system?

In the distributed database model there are.... 👉 click here👈

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 of o
Post a Comment
Read more