Skip to main content

Newer Post or latest post

Li-Fi vs Wi-Fi: A Battle of Light and Waves

Li-Fi vs Wi-Fi: A Battle of Light and Waves Li-fi is a light fidelity device that supports only the infrared and other lighting systems to transfer the data to the device which is used to receive from the sender device. Wifi is a wireless fidelity device that supports the radio waves to transfer the data to the wifi device which is used to receive the wifi signals at the limited ranges due to the device version capacity. Introduction to the computer system and computer applications related topics are listed following below here: Li-Fi vs Wi-Fi: A Battle of Light and Waves Let’s discuss the computer system related topic and questions above listed and their answers are following below here: Li-Fi vs Wi-Fi: A Battle of Light and Waves There are some points on the computer system and data communication related to the topic of “Li-Fi vs Wi-Fi: A Battle of Light and Waves” following below here: Lifi based data communication system:- Li-Fi is a light based signal data transmission ...

How to create a Database Management System on the computer?

How to create a Database Management System on the computer?

Database file is used to create through the SQL program on the RDBMS software to provide the file to provide the solution of database processing on the software systems.

Database system is used to provide the new file on the database software to provide the file which is used to provide the processed data on the database file through the database programming to provide the output data to the output data interface of any type of software systems such as:- menu application of operating system or application software etc.

Database is used to process the data through the DDL, DML and DCL through the database SQL programming on the database file in the model relational database system.

Database management systems provide the processed data to the output interface of software systems and the user has a solution from the database processing system that applies some commands on the database file through the SQL program in the relational database model. Such as:- create a database file is a command to create a new file on the memory device of the computer system and a database file is generated when the query processor completes their process and provides the blank file of the database in the format of relational database model. The database file provides the processed data through applied some logical operations on the record in the relational database file.

The record has so many attributes that define the data category and provide more information defined uniquely in the record for showing data in the tabular format in the relational database model.


Introduction to the computer system related topic and the topic is following below here:


How to create a Database Management System on the computer?


Let's discuss the computer system related topic is mentioned above and the explained following below here:


How to create a Database Management System on the computer?

There are some points on the computer system and database model related to the topic of "How to create a Database Management System on the computer?" following below here:


How to create a Database Management System on the computer?

  • The database file can be create through the command of SQL in relational database
  • The blank file need to apply some manipulation commands for new record and attributes
  • Database file can be managed and process the value
  • Relational Database also used for security of data as a verification


Let's discuss the points above about the computer system and the database model related to the topic of "How to create a Database Management System on the computer?" explanation following below here:


The database file can be create through the command of SQL in relational database

The database file can be created through the command line and keywords of SQL on the relational database model to provide the file to process the saved input value that comes from the input resource of the computer system or smartphone device.

The SQL program is used to define the new file when the user wants to create a new blank file for storing the new data on the record and their attributes to store the data in the category of attributes mentioned in the Relational database file.

If the record is based on the user details then their attributes are name, city, state, zip code, pin code, contact number etc.

The database file can be created through the command and it provides the blank database file to store the record data according to the attribute of the record that defines the data in the unique category of data in the special attribute of the record in the relational database model.

The database file can be deleted from the command of drop database name to provide delete operation applied on the database file which is selected to delete and mentioned in the command line of the database programming.


The blank file need to apply some manipulation commands for new record and attributes

The blank file needs to apply some commands that are used to store the new value and data into a cell of the attributes of the particular record in the relational database file.

The cell is the part of the relational database file that is used to store the value or data in the cell, the cell is made from the cross section of the attributes and the records in the relational database file.

The relational blank file is used to store the new data through the SQL commands of manipulation of sql commands such as:- INSERT new data in the records. All types of commands are applied on the records, not a particular attribute on the relational database files. The UPDATE is a command to provide the new changes into the existing records which are created in the relational database file and insert new information in the record on the relational database file.


Database file can be managed and process the value

Database file can be managed and process the value that means database file can managed from the DDL and DML means the DDL is a command line on the SQL program language that means Data Definition Language and DML is a Data Manipulation Language that process the data in the relational database file.

The DDL works on the Database file and the DDL is used to define the database file to provide the blank file for storing the new data and information on the relational database file.

The data can be managed from the data manipulation command language that applies such keywords of manipulation language as update, insert and delete are used to manage the data on the relational database file.

The management of data in the relational database model processes the data through the manipulation commands operations to provide the management of the data in the records and attributes in the relational database file.

The management is also necessary for data consistency to make the data consistent after performing the manipulation command on the relational database file.


Relational Database also used for security of data as a verification

Relational databases are also used for security of data as a verification on the software systems such as:- web applications, operating system, website and application software. The security model includes the username and password to verify the user identity on the security interface on the application of any types of software systems.

The security model uses the relational database file that included the username and password with target of key attribute such as:- primary key is a primary attribute for define the data of record is unique and provide the triggering system on the record through the SQL commands on the relational database file on the particular software systems.

The username and password attributes are used to verify the relational database file used for the security model for the verification system through the data control language of the SQL programming language.

The Data control language is used to provide the verification and controlling system on the security model on the application software or any type of software systems.

The database file also applies to more security systems on the software systems for end users such as:- secret code after username and password verification and provide the account access after verification of these three types of attributes on the security model on the software systems or application software.

Comments