Note: Students must submit a PDF document with screenshots, showing their T-SQL coding, object explorer and query result, running on SQL Server Management Studio. Note: Use your Database and tables created in Question 1 to answer the following questions. 2.1 Create a view that shows all the Orders, with the customer name, for a specific order date. (Students will choose an OrderDate as per rows in their Orders table) (4) 2.2 Create a Scalar-valued function to get the total of the UnitCost, in the Products table. (4) 2.3 Use the Scalar-valued function created in question 2.2 to print "The Total cost of the products we have is R", return the Total cost from the function in rands.(4) 2.4 Write a query against OrderDetails Table, that returns the running quantity for each order using

Note: Students must submit a PDF document with screenshots, showing their T-SQL coding, object explorer and query result, running on SQL Server Management Studio. Note: Use your Database and tables created in Question 1 to answer the following questions. 2.1 Create a view that shows all the Orders, with the customer name, for a specific order date. (Students will choose an OrderDate as per rows in their Orders table) (4) 2.2 Create a Scalar-valued function to get the total of the UnitCost, in the Products table. (4) 2.3 Use the Scalar-valued function created in question 2.2 to print "The Total cost of the products we have is R", return the Total cost from the function in rands.(4) 2.4 Write a query against OrderDetails Table, that returns the running quantity for each order using

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...

See similar textbooks

Similar questions

For all Questions in this Formative, paste full screenshots of your Microsoft SQL Server Management Studio, showing object explorer, query and query results. To complete all the questions download and restore the TSQLV4 Database in your Microsoft SQL Server Management Studio. Write a query against the Sales.Orders table that returns orders placed in June 2015.
Hello can you help me to connect my registration PHP which I don't know how to insert those registration data on my database and table which is the admin table and the regular table. Can you help me for the right code for the table admin and regular to connect to my database I would appreciate if you would put the right code and SQL query for the connection. Here is my PHP code <?php session_start(); include 'database_connection.php'; if($_POST['uname'] && $_POST['password']) { $name=$_POST['name']; $lname = $_POST['lname']; $fname = $_POST['fname']; $mname = $_POST['mname']; $gen = $_POST['gender']; $birth = $_POST['birth']; $type = $_POST['utype']; $email = $_POST['email']; $pass=$_POST['password']; if($type=='Admin') admin($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con); else regular($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con); }…
Create a MySQL Database called “CSC306Class”. Create three (3) tables in the database called “studentInf”, “IntructorInf”, and “LikedAndDisliked”. Each table should consist of five columns that are relatable to the table name. Insert at least five row of data in each table. The data can be any information as long as it is related to the table name. If you were able to download and setup an php server on computer. Try to create the database, tables, and rows. Then upload a screenshot and code. Please help me with the practice problem I have created.
Write a simple 2-page app with SQL/PDO that allows users to:• View all the rows of the table.• Delete rows (by key) – the code should be written in such a way to avoid SQL injection attack.
Please solve Question 7 using the SQL command 'NOT EXISTS'. Original answer only please. Other relative info includes the data tables below: TABLE `Streams` ( `customer` int NOT NULL, `moviePrefix` char(4) NOT NULL, `movieSuffix` char(4) NOT NULL, `timestamp` timestamp NOT NULL, `duration` int NOT NULL TABLE `Previews` ( `customer` int NOT NULL, `moviePrefix` char(4) NOT NULL, `movieSuffix` char(4) NOT NULL, `timestamp` timestamp NOT NULL TABLE `Movie` ( `prefix` char(4) NOT NULL, `suffix` char(4) NOT NULL, `name` varchar(255) NOT NULL, `description` text NOT NULL, `rating` enum('G','PG','M','MA15+','R18+') NOT NULL, `releaseDate` date DEFAULT NULL TABLE `Customer` ( `id` int NOT NULL, `name` varchar(255) NOT NULL, `dob` date NOT NULL, `bestFriend` int DEFAULT NULL, `subscriptionLevel` varchar(25) NOT NULL
9.Here is ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show database CREATE DATABASE [Da]USE PETSTORE' at line 3mysql> use petstoreERROR 1049 (42000): Unknown database 'petstore'mysql> create database [da] -> use petstore -> -> CREATE TABLE USERS (user_id VARCHAR(30), password -> VARCHAR(30), first_name VARCHAR(50), last_name VARCHAR(50));ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[da] ========== whats the wrong with this work , what code is correct when i ma trying to make a new table and a new databse in this mysql commend line ?.
Database Question this is review Please keep the answer short The SQL statements that answer these questions. please keep the answer simple will give thumbs up thank you :)! INSERT STATEMENT LINK below https://drive.google.com/file/d/1qHCkrods5K2V1syyS5IG6-Eb_3QQmud7/view?usp=sharing Table.SQL below -- MySQL Script generated by MySQL Workbench-- Sun Feb 21 00:00:31 2021-- Model: New Model Version: 1.0-- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ------------------------------------------------------- Schema mydb-- ----------------------------------------------------- -- ------------------------------------------------------- Table state-- -----------------------------------------------------CREATE TABLE IF…
Db&__Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers...
There are three tables in this database (see image). Write MYSQL code for: (1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (2) Create a trigger “change_quantity” on table “Transaction”. The trigger is fired after a row is inserted in table “Transaction”. After a row is inserted in table “Transaction”, update the “quantity” in table “Inventory”. For example, if 3 iWatch are sold, then the quantity of iWatch in table “Inventory” is decreased by 3. Test your trigger by inserting a row into Transaction and displaying the contents of the relevant row in Inventory. (3) Create a trigger “change_price” on table…
Database Question this is a review question The SQL statements that answer these questions. please keep the answer simple will give thumbs up thank you :)! INSERT STATEMENT LINK below https://drive.google.com/file/d/1qHCkrods5K2V1syyS5IG6-Eb_3QQmud7/view?usp=sharing Table.SQL below -- MySQL Script generated by MySQL Workbench-- Sun Feb 21 00:00:31 2021-- Model: New Model Version: 1.0-- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ------------------------------------------------------- Schema mydb-- ----------------------------------------------------- -- ------------------------------------------------------- Table state-- -----------------------------------------------------CREATE TABLE IF NOT EXISTS state…
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
Which of the following has no partial or transitive dependencies? unnormalized data 1NF 2NF 3NF