Chapter 17 How to manage database security Exercises using the My Guitar Shop Database Use Microsoft SQL Server Write a script that creates a user-defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission to the new role for the Orders and OrderItems table. Give SELECT permission for all user tables. 2.Write a script that (1) creates a login ID named “RobertHalliday” with the password “HelloBob”; (2) sets the default database for the login to the MyGuitarShop database; (3) creates a user named “RobertHalliday” for the login; and (4) assigns the user to the OrderEntry role you created in exercise 1

Q: Solve all parts with explanation and Don't use ai to answer

A: To complete the steps for inserting records into the database and performing the required operations…

Q: Q#1 Insert two records in each table or use if you have already created this schema. Q#2 Display…

A: Summary: In this question, we need to create the given schema using SQL and perform the given…

Q: Display all data contained in one of the tables in the JustLee Books database. Retrieve two columns…

A: Introduction Database: A database is a collection of organized data that is electronically stored…

Q: Q2/ write SQL commands to create tables of a Bank database, where these tables will have the…

A:

Q: in sql  If you have not yet used the COMMIT command to store the changes permanently in the…

A: Answer: a. True

Q: Which type of database constraint does the following trigger implement? a.Key constraint b.Dynamic…

A: Summary: We need to identify the type of database constraint that will implement the given trigger.

Q: User name is “user1_app” b. Authentication uses SQL Based Authentication c. User password is never…

A: WideWorldImporters : -  It is the database for Transaction and Analytics processing.

Q: In this exercise, you will create tablespaces and change their characteristics. 1. Connect to the…

A: 1. 2. 3.

Q: Using MongoDb do the following activities Create database named First. Create a collection named…

A: 1. use First 2. db.createCollection("dbase6211")

Q: Create a database named cis224 with an addresses table with the following : AddressNo…

A: Algorithm: Step1: Create table of details in database.Step2: Label all the inputs on the webpage by…

Q: Build Windows forms for that database tables(Separate Parent and Child forms) Do the insert data…

A: In below we make a code in which we insert the data in database table. here two forms in we insert…

Q: reate PHP Index that can generate qr code & web scanner to read qr information & display its log.…

A: Lets see the solution.

Q: 1. Create tblEmp with three columns, namely, EID, Name and Salary 2. Create an anonymous PL/SQL…

A: CREATE TABLE tblEmp ( EID INT (10) NoT NULL, Name VARCHAR (20), Salary int (10) NoT NULL, PRIMARY…

Q: Database Admin You are executing the following query script into your database SELECT * FROM…

A: The query in соlumn А will query in the tаble WоrldWideImpоrters.Purсhаsing.PurсhаseОrders by…

Q: Based on the stored procedure concepts you have learnt during this semester, answer A, B and C: A.…

A: A) create procedure GetAddress as select Person,Address from AdventureWorks where city=@city go;

Q: default character. What SQL statement should you use to create the database? You are creating a…

A: A database is basically a storage system that stores data in huge amounts. It is virtual in nature…

Q: Write an Anonymous PL/SQL block that will insert five records into the database; the records must…

A: pls find the attached solution of the given question:

Q: Which of the following are true about primary keys? SELECT ALL THAT APPLY. A) They must reference…

A: B) They are usually implemented using an index.C) They guarantee that no two rows in a table have…

Q: Create a user with the name IS Sead and password a789 and give him permission to connect to the…

A: MySQL is an open source relational database management system. It has been used in the WordPress…

Q: write the steps to design new database file as (subjtable1.dbf) that consists .(of (2) fields:…

A: Steps to design the database named subjtable1.dbf in MySQL database: Use create table command to…

Q: What is the answer for this exact sql formula?

A: SQL: SQL stands for Structured Query Language. It is used to access and manipulate the database.

Q: I have been trying to get this program to work but every time I fix one area it throws 2 more codes,…

A: In this question we have to understand about the code and correct the code to perform all the menu…

Q: In this assignment you will write an SQL script that will create a database with five tables.  In…

A: Dear Student, As per the requirement submitted above, kindly find the below solution. This…

Q: First Task: Create Database using PHPMyAdmin that includes two tables: 1. Order (OID, Price, and…

A: Below are the required queries:

Q: How many times has each book title been borrowed? Give the new column an alias.

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: • Using the MySQL client: o Create a new table in the dogs_db database called student (id int, name…

A: show databases;create database dogs_db;use dogs_db;

Q: 1. Create tblEmp with three columns, namely, EID, Name and Salary 2. Create an anonymous PL/sQL…

A: The Answer is

Q: Write a script that adds an index to the MyGuitarShop database for the zip code field in the…

A: Write a script that adds an index to the MyGuitarShop database for the zip code field in the…

Q: ) Create a database called cars that has these tables or write the SQL command to create the…

A: Create database: CREATE DATABASE cars; Create tables: Car: CREATE TABLE Car(car_ID int PRIMARY…

Q: in mysql Take a picture of the inputs and outputs Create a user with the name IS Sead and password…

A: Following are the input and output of creating a user named ISsead: When testing the connection,…

Q: You will normalize the following data (each user gets different data), and insert the following data…

A: We have to normalize the given data and create a relational database to store the information about…

Q: Create a database trigger for the following situations:                       update the…

A: A block of SQL or PL/SQL code that is automatically triggered, by the DBMS when some specific data…

Q: Create a user with the name IS Sead and password a789 and give him permission to connect to the…

A: The answer is given in the below step

Q: Compulsory Task 1 Follow these steps: ● Create a Python file called database_manip.py. Write the…

A: In this question we have to write a python code for database main file where we need to create a…

Q: Problem: JMS TechWizards is a local company that provides technical services to several small…

A: Note: - As per our guidelines we can only answer one question at a time. Please resubmit the other…

Q: The idea of the project is to develop a simple Android app with real-time database. you decide your…

A: An Android application, or "app," which refers to the one it is a software program designed to run…

Q: The following Form is same as 2nd example of lecture 17 with 2 additional button "Fetch" and "Reset"…

A: Code: <?php        include "connection.php";        if(isset($_GET['id'])){    $sql = "delete…

Q: Sdb-new PDO('mysql:host-localhost;dbname-ordersDB;charset-utf8', 'root', 'abc123);…

A: As we need to create placeOrder.php, in order to maintain the database and insert the data…

Q: that

A: The correct answer to the given question is option (d)"GRANT"

Q: Create a table named "student" with the following columns/fields: 1. id - integer not null primary…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: Hello. I am having trouble with a question for my database devlopment class. I need help with this…

A: To display a list of all books in the BOOKS table, along with the corresponding order number and…

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.