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

What is an example of a relational database?

What is an example of a relational database?

Relational database included attributes and records. Where the record is made up of rows and attributes are made up of columns.

The row is also known as tuple on the relational database model.

The columns have many names such as attribute, property, characteristic etc.

The key attributes are also included in the relational database model which is used to identify the user is unique and easily accessed and found from the relational database through the key attributes that are applied in the user record and its attribute. Such as serial number as a primary key, department of ID number which is in the sequence with number and alphabet combination.


Introduction to the topic of computer related and the topic is related to the computer database technology and architecture following below here:


What is an example of a relational database?


Let's discuss the topic related to computer systems and database and the topic is "What is an example of a relational database?" following below here:


In this topic you can learn about the relational database model and its components that describe the relational database model.

Such as record or tuple and attribute or property and key attributes also included in the relational database model which is easily used for manipulation query applying with the primary key attributes if the particular record is needed to update information, insert a data or delete the data etc.

These are the manipulation commands in the relational database model performed in the relational database model which is known as Data manipulation language commands or DML in the relational database model.

The relational database model only processes the text data.


What is an example of a relational database?

There are some points on the computer system and relational database model development example related to the topic of "What is an example of a relational database?" following below here:


What is an example of a relational database?

  • Relational database contains the records and attributes or tuple and fields or property in a row and column respectively
  • Relational database is defined by DDL category of command 
  • Relational database manipulate by DML category of commands
  • Relational data model controlled by the DCL commands
  • If you find the particular record using the key attributes then give an example


Let's discuss the points listed above about the computer system and database technology related to the topic of "What is an example of a relational database?" explanation following below here:


Relational database contains the records and attributes or tuple and fields or property in a row and column respectively

Relational database contains the records, the records are the row detail of the object or subject or any personal detail described with their attributes filled in the columns of every record mentioned in relational database model.

Relational database contains the attributes which describe the properties or characteristics of the records of the object or subject or any person.

The description is also a part of an attribute which is used to explain the object, subject, person in one or more sentences in 100 to 10000 words of consistency to tell about the records that have unique key attributes to identify quickly and uniquely.


Relational database is defined by DDL category of command 

Relational database is defined by the DDL category of command that means the relational database defines the data defines types of command to create a database file in the database software.

And some commands which are used delete the database file from the database server application software.

The database file is used to store the records and attributes data in the table format.

Row and column are based on the relational database file on the database software.

The data definition language is used to define the database file and delete also, where the triggers and indexes are also defined by the DDL commands in database server application software.


Relational database manipulate by DML category of commands

Relational database manipulation by DML category of commands means the dml is used to manipulate the data in the database file which has been defined by the DDL commands.

DML commands to edit the data in the database files which have been already defined by the DDL commands on the database server application software.

The database server application software is used to provide the DML commands to manipulate data such as update the data from the particular selected record on the database file which has defined already but it need to update or change the not for whole record it just change the attributes mentioned also if the user requires to change the data of record.


Relational data model controlled by the DCL commands

Relational data model controlled by the DCL commands that means the relational data model controlled the data for security model of application software or database server application to apply on the database file to grant the permission who knows the username and password to access the database file which has defined stored some data in the record and it's attributes.

The DCL command is used to protect the data using the data control language to apply the command to get access with the data of username and password which is correct to verify.

Relational data model controlled on the database file by the DCL when the user applies these types of command to protect the personal database file.


If you find the particular record using the key attributes then give an example

If a user finds some record from the particular database file on the database server application software then the user uses the command of the select command from the DML commands group to apply and manipulate to search the particular records from the database file on the database server application software.

For example:- If the user finds a record such as 09 of serial number, Brad, from the department of Computer science engineering. Then the user apply the command of select then SELECT where "serial number = 09";

Then enter it on the query processor of the database software.

It is a basic example of record finding from the SELECT command where it is used to mention the user id number which is serial number and the serial number attribute is a key attribute of primary key.

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