Download Database Development and Security: MySQL Workbench, C#, Visual Studio, SQL Queries and more Assignments C programming in PDF only on Docsity!
MYSQL workbench: MySQL Workbench is a visual tool for the development of database.it provides the SQL development and data modelling.it enables a developer to design database visually and to manage the database. I used SQL queries to develop a database as well it accesses us to connect the database. C# Programming language: C# is a hybrid program of C-program and C++ program.it is a simple object-oriented programming language developed by Microsoft by burrowing concept from several languages. C# use .Net platform in the development of web and desktop application.
Visual Studio: Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs, as well as websites, web apps, web services and mobile apps. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native code and managed code. Visual Studio includes a code editor supporting IntelliSense (the code completion component) as well as code refactoring. The integrated debugger works both as a source-level debugger and a machine-level debugger. Other built-in tools include a code profiler, forms designer for building GUI applications, web designer, class designer, and database schema designer. It accepts plug-ins that enhance the functionality at almost every level-including adding support for source control systems (like Subversion and Git) and adding new toolsets like editors and
of data from existing table. The commands of Data manipulation language are SELECT, UPDATE, INSERT and DELETE.[ CITATION Tec19 \l 1033 ] Select statement is used to select the data of row from the table. Update statements is used to update one or more data in a record. Insert statements is used to add one or more data into the database. Delete statements is used to delete one or more records from the table. Screen shot of all module for insert, update, delete, select, create, alter, and drop:
Database Security: Database security is protection of data in database system against unauthorized access means only right people can get the right access to the right data. There are different causes of database physical destruction such as fire, water, heat, dust, power failure, theft etc. It might be accidental loss or physical damage in computer system. In order to protect from such damages database is stored in different 2location in different disk (RAID: Redundant Array of Independent Disk). Different types of data recovery and data locking modification, failure, losses destruction. The authorized access techniques are used for the security. Some of the data security methods are Using proper backup in disks, tapes, CD etc. provides the data from the accidental loss. Making physical prevention by using stabilizer and UPS to supply a regular power through which we can prevent hardware and software from high electricity voltage and irregular power supply Using strong password protection system, making log in the system to prevent data from unauthorized access to the database by keeping the system under lock or safe place. Security against SQL injection and other vulnerability: SQL injection is a type of injection attack by an attacker which cause undesirable action by an application. Due to the common availability of SQL database, SQL injection is common attack
on the internet.[ CITATION hac19 \l 1033 ] We can be prevent from SQL injection by keeping the database server software and its components up to date, by not sharing database in different websites. We can also secure database by not sharing database. To be free from other type’s vulnerability, database should be share with valid and authorized users only. Data backup and restore: Sometimes, due to the unusual use and vulnerability attack on database may cause loss of data. So to save the data from loss, all the data of database must be back up. Back up data helps to restore our original data. If we copy the data and back up it then we can restore the original data in case of data deletion and corruption. Data backup access us to restore the original data after the data loss. It is necessary to back up the data. I had also backup the data of database Beacons management system to get prevent from the unnecessary data loss and data deletion. Conclusion: Hence, the query language has different purpose or functions. From this document we were able to know about the query language, its functions and types of command language and its benefits along with the pictures of data manipulation language types of our application beacons_management_system. We successfully implemented query language into relational database system and to conclude, the basic query of CRUD functionality is used for the back end and front end of the application so that the users can easily use the application without the knowledge of the database and developers handle those all the back-end part of the software.
