Related questions
Concept explainers
An objective of this task is to implement your own simple method of auditing the
It is strongly recommended to connect to MySQL either through command line interface mysql or graphical user interface MySQL Workbench and process a script file dbdrop.sql and immediately after that the scripts dbcreate.sql and dbload.sql to refresh a sample database csit115.
Download a file solution3.sql and insert into the file the implementations of the following actions.
You must connect as a user root with a password csit115.
Your implementation must directly follow a comment with a specification of a subtask.
(1) First, the script makes a relational table that contains a general log empty.
(2) Next, the script sets the appropriate values of the variables to save a general log in a relational table and to start recording a general log from now.
(3) Next, the script makes a database csit115 a default database, it stops recording a report, it executes a script file updates.sql, and it resumes recording a report into a file solution3.rpt.
A listing of SQL statements processed from a script file updates.sql must
NOT be included in the report file solution3.rpt.
(4) Next, the script sets the appropriate values of all variables to stop recording a general log from now.
(5) Finally, the script finds and lists how many times each one of the relational tables included in a sample database have been used by the successfully processed SQL statements included in SQL script updates.sql. You have to consider the relational tables with the following names LPOSITION, DEPARTMENT, EMPLOYEE, SUBJECT, RUNNINGSUBJECT, and TEACHES. No other relational tables need to be considered. The script must list the names of relational tables together with the total number of times each table has been used. Please, find a fragment of a sample output listed below.
+------------+-------+
| TABLE_NAME | TOTAL |
+------------+-------+
| DEPARTMENT | 8 |
| SUBJECT | 6 |
... ...
+------------+-------+
6 rows in set (0.01 sec)
To simplify this task, assume that a relational table is used no more than one time in a SQL statement.
The results must be listed in the descending order of the total number of times each one of the relational tables has been used by the successfully processed SQL statements included in a script updates.sql.
When ready connect as root user, process a script file solution3.sql, and save a report from processing in a file solution3.rpt.
Step by stepSolved in 4 steps
- SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the MongoDB Shell code to completely delete the entire database, including all collections and documentsarrow_forwardWrite a script that implements the following design in a database named my_web_db: users downloads products product_id INT O product_name VARCHAR(45) user_id INT download_id INT email_address VARCHAR(100) user_id INT O first_name VARCHAR(45) KO download_date DATETIME Indexes Olast_name VARCHAR(45) O filename VARCHAR (50) Indexes O product_id INT Indexes In the Downloads table, the user_id and product_id columns are the foreign keys. Include a statement to drop the database if it already exists. Include statements to create and select the database. Include any indexes that you think are necessary. Specify the utf8mb4 character set for all tables. Specify the InnoDB storage engine for all tables.arrow_forwardplease answer DBMS ques asap! AUMarket is a retail company whose database system uses the discretionary access control to manage its data. Jennifer is the DBA of this database system and also the owner of a table called PAYMENT. Jennifer grants SELECT on the table PAYMENT to the database user Lee as follows: GRANT SELECT ON PAYMENT TO Lee; However, Jennifer does not want to grant any privileges on the table PAYMENT to the database user Paul. Paul knows very well about database hacking techniques. If Paul does not have any privilege on PAYMENT but he knows that Lee has the SELECT privilege on PAYMENT, is it possible that Paul can hack the database in order to obtain the information of all records in the table PAYMENT? If impossible, you need to explain why it is impossible. If possible, you need to explain how Paul can obtain the information.arrow_forward
- Scripts and stored procedures vary in the following ways: What's the point of each of these? Are there advantages to using Stored Procedures over other techniques in a database?arrow_forwardThe SQLiteOpenHelper and SQLiteCursor classes are described, with a focus on how they may be used to perform create, read, update, and delete (CRUD) actions on a SQLite database.arrow_forwardAfter getting a job going on a database, you can use either a trigger or a process. When should a gun be pulled? What are they?arrow_forward
- When you use a transaction, the database tables/views/other resources used in the transaction are locked until the transaction is either committed or rolled back in order to ensure all modifications are either ALL made, or none of them made. Usually databases also have options on the level of locking used such as no one can read or make changes to those resources when locked, or users can’t make changes to the resources but they can read data in the tables/views/read access to resources. Pick a potential problem with database locks on tables/views/resources and one popular way database administrators and / or database users use to address that problem?arrow_forwardSQL Database Explain the function and importance of the SQL COMMIT command and list the pros/cons of using Autocommit mode.arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education