Newer Post or latest post

What do you mean by database application on the computer?

-
Image
What do you mean by database application on the computer? The database application provides the database tools to manage the data in the model of relational database. The relational database model application includes the different types of option and applies some query processes on the record of the database file and their attributes values in the table database. The query is performed by the query processor on the record using the key attributes on the relational database model. Database application included the different types of parts that process the data into the database file, where the user mostly uses the relational database model to process the text data in the table format of database file which included the record, attributes and query processor to apply the commands on the record to process the values of the attributes on the records of the relational database file. The user get the solution of the output data using the database programming to get the values processed by t
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 ðŸ‘ˆ

Comments

Post a Comment

Popular posts from this blog

what are the function of the joystick and light pen?

-
Image
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
Read more

What are the difference between input device and an offline data entry device?

-
Image
What are the differences between an input device and an offline data entry device? Offline data entry device: i) The offline data entry devices are uses to data enters without online working. ii) The offline data entry device such as bio metric attendance device is uses generally take offline attendance then it will be able to send attendance data to attendance registrar officer. iii) Some software  services includes functions have they receives a data from bar coding to stores automatically fills data for accounting purpose as making bills receipt etc. iv) Some devices such as M.I.C.R., OCR , O.M.R. for a specific work for data entry work to safe the data of people privacy. v) Bar Code Reader is also an  offline  data entry  device to stores the data into some software for accounting purpose.  What is entering data on the computer? The entering data mean the data which is used to enter through the source document or other type of method to enter the data into the applic
Read more

What are the three main purpose of an operating system?

-
Image
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
Read more