Write all the sql code (including create, insert and select) Create the following tables in your database with the following schema:Table: UsersI Column Name| Type+--intI account| name| varchar+-----+-----account is the primary key for this table.Each row of this table contains the account number of each user in the bank.Table: Transactions| Column Name| Туре+-| trans idI account| amount| transacted_on | date| int| int| int+--trans id is the primary key for this table.Each row of this table contains all changes made to all accounts.amount is positive if the user received money and negative if theytransferred money.All accounts start with a balance of 0.Add the following data to your tables:Input:Users table:+---I accountI name+---| 900001| 900002| 900003| Alice| Bob| CharlieTransactions table:+--| trans id| account| amount| transacted_on+---| 1| 2| 3| 900001| 900001| 900001I 900002| 900003| 900003| 900003| 7000I 7000| -3000| 1000| 6000| 6000| -40002020-08-012020-09-012020-09-022020-09-1252020-08-072020-09-07| 72020-09-11+-- Write an SQL query to report the name and balance of users with a balance higher than 10000. Thebalance of an account is equal to the sum of the amounts of all transactions involving that account.Return the result table in any order.The results should be:Output:I namebalance| Alice11000Explanation:Alice's balance is (7000 + 7000 -Bob's balance is 1000.3000) = 11000.Charlie's balance is (6000 + 60004000) = 8000.

#use the below query to create users tablecreate table users(account int primary key,name…

Answered: Write all the sql code (including…

Engineering

Computer Science

Write all the sql code (including create, insert and select)

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

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

See similar textbooks

Similar questions

Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table.
Write, but do not execute, the commands to grant the following privileges: a. User Oliver must be able to retrieve data from the CONDO_UNIT table. b. Users Crandall and Perez must be able to add new owners and condo units to thedatabase. c. Users Johnson and Klein must be able to change the condo fee of any unit. d. All users must be able to retrieve the unit number, condo fee, and owner number forevery condo unit. e. User Klein must be able to add and delete service categories. f. User Adams must be able to create an index on the SERVICE_REQUEST table. g. Users Adams and Klein must be able to change the structure of the CONDO_UNITtable. h. User Klein must have all privileges on the LOCATION, OWNER, and CONDO_UNITtables.
Which of the following data dictionary objects should be used to view information about the constraints in a database? USER_TABLES USER_RULES USER_COLUMNS USER_CONSTRAINTS None of the above objects should be used.
Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be able to retrieve data from the TRIP table. b. Users Gomez and Liston must be able to add new reservations and customers to thedatabase. c. Users Andrews and Zimmer must be able to change the price of any trip. d. All users must be able to retrieve the trip name, start location, distance, and type forevery trip. e. User Golden must be able to add and delete guides. f. User Andrews must be able to create an index for the TRIP table. g. Users Andrews and Golden must be able to change the structure of the CUSTOMERtable. h. User Golden must have all privileges on the TRIP, GUIDE, and TRIP_GUIDEStables.
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); }…
This question is based on the following data and tables. Create a database named books( make sure you don’t forget to select the database) and run the MySQL queries below to be able to complete the following MySQL Queries. For each MySQL query, screenshot the output and include the MySQL query in your submission PDF. -- Authors Table CREATE TABLE authors ( author_id INT PRIMARY KEY AUTO_INCREMENT, author_name VARCHAR(255) NOT NULL, birth_year INT ); -- Sample DataINSERT INTO authors (author_name, birth_year) VALUES ('J.K. Rowling', 1965),('George Orwell', 1903),('Jane Austen', 1775); -- Books Table CREATE TABLE books ( book_id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255) NOT NULL, publication_year INT,author_id INT, FOREIGN KEY (author_id) REFERENCES authors(author_id) ); -- Sample Data INSERT INTO books (title, publication_year, author_id) VALUES ('Harry Potter and the Sorcerer''s Stone', 1997, 1),('1984', 1949, 2),('Pride and Prejudice', 1813, 3); a- Write a MySQL…
SQL: need help with importing txt file into database, how do you import .txt files? (#4 only) file contents: mail,Full Name,Country,Date Registered Carley_Bahringer@destiny.com,Carley Bahringer,Brazil,1987-10-03 22:09:54 Patricia_Fadel@avis.com,Patricia Fadel,Chile,2012-05-10 11:07:49 Sedrick@godfrey.ca,Sedrick Kuphal,Chile,2007-11-12 00:09:53 Briana_Berge@axel.ca,Briana Berge,Iceland,2006-03-26 15:32:08 Lucy_Lockman@abby.org,Lucy Lockman,Iceland,2014-02-13 10:26:57 Lucy_Lockman@abby.org,Lucy Lockman,France,1999-02-12 00:14:54 Ayden_Flatley@colin.biz,Ayden Flatley,France,1987-01-23 21:43:22 Alec.Boyle@aurore.co.uk,Alec Boyle,Brazil,2007-08-23 13:42:41 Ozella_Feil@prudence.ca,Ozella Feil,Brazil,2005-12-30 18:24:59 Ozella_Feil@prudence.ca,Ozella Feil,Sweden,2009-06-19 10:32:55
Create the following tables in a database named "roster". Make sure that your database and tables are named exactly as follows including matching case.
A mobile app for booking doctor appointments is running very slowly when accessing data from a database and the programmers think that poorly optimised SQL statements are causing it. There are three places where they think the code might be slow. 1. When users book a new appointment. 2. When the date of an appointment is modified. 3. When a user searches for doctors by name or specialty. Could any of these be improved by creating a database index? Why/Why not? What column or columns (if any) would be appropriate to add an index to?
The screenshot of the Query and the results below is from the question of each number, and saved with the file name: UAS_NIM.docx or UAS_NIM.pdf Create database : - Show the name of the supplier who sells shoes at prices below the average shoe price- Show the name of the customer who bought shoes with odd sizes- Show Customer Name and Average Payment Amount for Customers who make 5transaction more than 1 Jenis_Sepatu: INSERT INTO Jenis_Sepatu values('S-01', 'Sepatu Lari');INSERT INTO Jenis_Sepatu values('S-02', 'Sepatu Basket');INSERT INTO Jenis_Sepatu values('S-03', 'Sepatu Soccer'); Supplier: INSERT INTO SUPPLIER Values('MA', 'PT. MitraAdi', 'Jl. Monginsidi 87');INSERT INTO SUPPLIER Values('SO', 'PT. Shakti Omega', 'Jl. Sudirman 23');INSERT INTO SUPPLIER Values('SS', 'PT. Sport Station', 'Jl. GunungKelud 8'); Merek: INSERT INTO Merek values('AS', 'Adidas','MA');INSERT INTO Merek values('DA', 'Diadora','SS');INSERT INTO Merek values('PA', 'Puma','SO');INSERT INTO Merek…
Create a table named "student" with the following columns/fields: 1. id - integer not null primary key and auto increment 2. name - string with max of 200 characters not null 3. birthdate - date allows null Enter your answer 2. Create a database named "enrollment" Enter your answer 3. Get all the columns/fields of the "student" table. Enter your answer 4. Update the name of the student to "John Doe" where its id is 10. Enter your answer 5. Modify the "student" table by adding "address" column/field as string and allows null. Enter your answer 6. Delete all the records in "student" table. Enter your answer 7. Delete a record in "student" table where its id is 1. Enter your answer 8. Get only the "name" and "birthdate" of the "student" table where its "name" starts with "Jo" Enter your answer
create a SQLITE database or use an existing database and create a table in the database called "Ages": CREATE TABLE Ages ( name VARCHAR(128), age INTEGER ) Then make sure the table is empty by deleting any rows that you previously inserted, and insert these rows and only these rows with the following commands: DELETE FROM Ages; INSERT INTO Ages (name, age) VALUES ('Darrius', 17); INSERT INTO Ages (name, age) VALUES ('Dustin', 25); INSERT INTO Ages (name, age) VALUES ('Aibidh', 24); INSERT INTO Ages (name, age) VALUES ('Baron', 33); INSERT INTO Ages (name, age) VALUES ('Kayden', 33); Once the inserts are done, run the following SQL command:SELECT hex(name || age) AS X FROM Ages ORDER BY X Find the first row in the resulting record set and enter the long string that looks like 53656C696E613333. Note: This assignment must be done using SQLite - in particular, the SELECT query above will not work in any other database. So you cannot use MySQL or Oracle for this assignment.