Skip to main content

Newer Post or latest post

what is data cable? Types of cables, uses of data cables, importance of data cable explained!

Introduction of data cables Data cable is an important part of computer network model . From smartphone to supercomputer connections and wide range network uses and network models. It helps in network model in different types of topology models also. But we discuss what exactly called a data cable? How it is working with network model? Why these data cables are so important? In this guide, I will provide some information about the definitions, types, uses of data cables on network model with easy explanation of data cable covered topics. What is data cable? [Definition] A data cable is a wire that can transfer the data from one to another computer system. It connects to the ports available on the computer system. The user can transfer the data from one computer to another data cable connection. If two computers are connected then:- In according to data cable male port:- Port 1:- the male port of data cable is used to receive the data from the sender computer. Port 2:- th...
Post a Comment

Which characteristic of the record is too important and necessary to apply in the [RDBMS] Relational Database Management System?

Which characteristic of the record is too important and necessary to apply in the [RDBMS] Relational Database Management System?

Main characteristic of the record in the Relational Database

In the Record of the Relation database there are so many characteristics or properties and attribute to shows uniqueness of the record but there is one attribute that identify the record is unique to shows there uniqueness. There are some points to follow below to understand the type of attribute and it work.

  • The unique attribute of the record in the relational database is called primary key.
  • It is also called key attribute in the database property.
  • The primary key attribute take numerical data in their field.
  • It also called auto number in the table database.
  • It automatically counts the serial numbers and inserts in the field of the record.
  • Serial key attribute is the best way to find the record easily in the RDBMS.
  • The primary key is also important role in the Relational database because when you manipulating the data in the record you have to give the id number of the record which is applied by the queries on the relational database.

How to use the primary key attribute on the records in the database?

To find the records using primary key

Suppose you had applied the primary key attribute on all the records in the database. You can use the SELECT keyword apply and find the particular record in the database. There are some steps to find the records from the database by using a SELECT query with the primary key attribute.

Steps to apply the select query with the primary key attribute on the database to find a particular record

  • Open your code editor of your database server.
  • Type SELECT keyword then * asterisk primary key numbers column (s) from table database name.
  • This is a syntax of finding a particular record from the database.

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

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

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

Labels:

Comments

Post a Comment

Popular posts from this blog

About the memory and its Classification of the computer Memory

"Hi everyone, I'm Rudra, a CS engineer and passionate blogger. Welcome to my post on [About the memory and its Classification of the computer Memory. ], where I'll share insights on Information Technology and Computer Science education. My goal is to provide helpful information and answer your questions. Feel free to ask me anything in the comments below. Let's dive into today's topic…🙂” 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 s...
Post a Comment
Read more

what are the function of the joystick and light pen?

Q 1. State the functions of a joystick and that of a light pen? Introduction to the joystick device, virtual or soft joystick tool, game controller, virtual or soft game controller and light pen topics are covered below here: Joystick What is the meaning of the joystick in computer? What is the joystick as a peripheral device in the computer system? What is main use of joystick in computer system peripheral devices? What is the purpose of the joystick in computer? What are the types of joysticks in the peripheral system for game purpose? What do you mean by analog joystick in peripheral system? What are the advantages of analog joystick device? What are the disadvantages or drawbacks of analog joystick device? What are the uses of joysticks? What are top 5 uses of joystick device in the computer system peripheral? Where is the use of joystick? How to connect the joystick for game in computer system? Can you connect the joystick to the laptop? Why do n...
Post a Comment
Read more

how the track ball is differ from the mouse and joystick

What are the differences between trackball, mouse and joystick devices? The differences are according to the track ball device verse mouse and joystick Trackball The track ball is a pointing device which contains a ball over the device or above the device. The track ball is a statics device that cannot move from one place to another. The track ball gives you a stability to use the device without moving the whole and just move the ball or roll the on the device. It uses as input device that depends on finger and thumbs only to moves the ball. It is slower than mouse due to cause the dependency the finger and thumb to move the ball to track the path of the pointer. What is trackball used for? The trackball is an input device which is used to provide 2 dimensions to move the ball over the device the ball is attached to. The trackball is used to move the pointer of the operating system where the ball is moved according to the position of the 2 dimensions x and y axis on the...
Post a Comment
Read more