WEEK 11 ASSIGNMENT

Tahaghoghi, 2006). ? Assessment Task 1. You are creating a database named NewDB. The database uses the server's default character. What SQL statement should you use to create the database? 2. You are creating a table in a MySQL database from previous number. The table is named Bikes and includes two columns: BikelD and BikeName. The BikelD column must uniquely identify each row in the table, and values must be automatically assigned to each row. The BikeName column must include a descriptive name for each model of bike. The names vary in length but should never exceed 40 characters. What SQL statement should you use to create the table? 3. Write a SQL statement to insert the given data into the table countries against each column. Id Country Malaysia 2 Thailand 3 Mongolia 4 Georgia 5 Turkmenistan 95 6 Philippines 7 Israel Here in the following is the structure of the table "countries". | Field | Туре | Null | Key | Default | Extra | | varchar(2) | COUNTRY_ID | COUNTRY_NAME |…

Consider a database with the following tables: Patient(PatientID. PatientName, NumberOfVisits) / Doctor(DoctorID. DoctorName) Appointment(AppID. DoctoriD, PatientID. Date, time) 1.Write SQL statement to execute the view AppointmentsView

.Considered the tables  structures that you need in this question are the same of DBS311 database : Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named “Invalid credit”. Display the result of the average as integer.

SQL Queries Specify the following SQLite queries on the chinook database.  A schema for the database is in the picture. You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine.  SQLite is already installed on labnet machines. You must submit typed queries, not handwritten ones, and save them in a .pdf document.  There is no need to submit the output (results). Each query is worth 1 mark, but some are more difficult than others.   Queries to Specify 1. List the last name, postal code and country for all customers from Germany. 2. List the city and number of customers from each city. 3. List the customer id, last name and city for the first 20 customers, when they are ordered by last name ascending. 4. List the customer id, last name and company for all customers who have any company details recorded (the company attribute is not "null").…

DATABASE Given the structure and contents of the StartAPPCo database , answer the following questions. 1. Given the information above, create the StartAPPCo database.  2. Write SQL code to insert data into all the tables created.

Computer Science Table student with the attribute’s student_Id, Fname, Lnameme, Date of Birth, Address, and GPA is included in the registration database. 1. Create the above table using the SQL command. 2. Insert 6 records into the student table using SQL command. 3. Write a PHP code to connect to the database called “registration”, that contains the student table. 4. Write a PHP code to retrieve all students with GPA between (2.5 and 4.0 ) from the student's table and display them as a list that contains: student_Id, Fname, Lname, Address, and GPA on the screen. 5. Write a PHP code to delete students with GPA between 1 and 1.99.

SQL Queries Specify the following SQLite queries on the chinook database.  A schema for the database is in the picture. You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine.  SQLite is already installed on labnet machines. You must submit typed queries, not handwritten ones, and save them in a .pdf document.  There is no need to submit the output (results). Each query is worth 1 mark, but some are more difficult than others.   Queries to Specify 5. List the customer id, last name and email address of all customers with a Yahoo or Hotmail email address. 6. List the album id and number of tracks for all albums with 15, 16 or 17 tracks, in descending order of the number of tracks. 7. Find the maximum track length in milliseconds. 8. List the last name, first name and hire date of all employees born in 1961 to 1969 inclusive 9. List the…

Complete the Performing SQL Injection to Manipulate Tables in a Database lab which is located on Infosec Learning's website. Follow the instructions for the lab and export your performance report. When you have completed the lab, attach your performance report by clicking on the title of this assignment and submit it for grading. You are required to submit the following deliverable for grading: Performing SQL Injection to Manipulate Tables in a Database.

e11] - Read-Only - Word References Mailings Review View Help 28 - in my SQL with innoDB how are the primary and secondary indexes created? a) primary indexes are automatically created for each primary key. Secondary indexes are created manually for the foreign keys. b) primary indexes are manually created for each primary keys. All the secondary indexes are created automatically. c) primary indexes are automatically created for primary key secondary indexes are created automatically for the foreign keys. d) Primary indexes are manually created for each primary key secondary index are men created manually for each foreign key. structure while those without a 29 - in MYSQL with innoBD with the primary key however primary key have a structure. a) Неар, sorted. b) Sorted, heap. c) Sorted, hash. d) Cluster, heap 30 - what approach in a database administrator used to assess the effectiveness of indexes while investigating slow queries? a) Run EXPLAIN on queries b) Change the primary key. c)…

Execute the following statements using MYSQL: 1. Insert a row with the values (005, "Your name", , "Your Dept", 50000, 40) 2. Create a trigger (model trigger) to ensure that no employee of salary less than 20000 can be inserted in the database. Show the result for your trigger condition by inserting a new row.

25- Create a SQL statement/s to insert the following records in the CLIENTS table:   CLIENTS CID CName Gender Address Contact CType 1521 Ahmed Said Male SLL 92214561 Old 1522 Salma Mohammed Female MCT 92384792 New 1523 Faiza Ahmed Female SLL 97451382 Old 1524 Noaman Said Male NZW   New

Create a user etec224. (Screenshot 1) Create a database Bank. (Screenshot 2) Grant etec224 privileges to Bank(Screenshot 3) As etec 224, create a table customers with the following structure. (Screenshot 4) CustomerID int(12) Primary Key and not null AccountNo int(12) FirstName varchar(15) not null LastName varchar(15) not null Birthday datetime Balance double(10,2) use a command to describe the table(Screenshot 5) insert 3 customers randomly to the above table(Screenshot 6) show all the contents of the table. (Screenshot 7) Were you able to complete the commands? True False

25-Create a SQL statement/s to Add/insert the following records in the CLIENTS table:   CLIENTS CID CName Gender Address Contact CType 1521 Ahmed Said Male SLL 92214561 Old 1522 Salma Mohammed Female MCT 92384792 New 1523 Faiza Ahmed Female SLL 97451382 Old 1524 Noaman Said Male NZW   New

: write the steps to design new database file as (subjtable1.dbf) that consists .(of (2) fields: subj-nbr n(2), subj-name c(20 Q2: write the steps to design new form as (frm1.scx) from table in (Q1) with .command for closing form

IN MYSQL in DBA oracel Create a user with the name IS Sead and password a789 and give him permission to connect to the databaseCreate a role function that includes allowing to create a table and create a view and then granting that function to the Sead . user Make the sead user give permission to query and enter on the student table for all users in the databaseHave the user sead withdraw the entry on the student table from user saa

MYSQL DBMS Consider the DVD Rental database named Sakila from the MYSQL examples. a) Write a query that returns the names of movies in descending order of times they were rented. Present the result obtained from the first films. b) Show the execution plan available in MYSQL and use the EXPLAIN command. Analyze and comment on the results.

Considered the tables structures that you need in this question are the same of DBS311 database : Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named "Invalid credit". Display the result of the average as integer. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BI U S Paragraph A v In x X2 Arial 10pt ...

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.

Q2/ write SQL commands to create tables of a Bank database, where these tables will have the following schemas: branch(branch_ name, branch_city, assets) customer(customer_name, customer_street, customer_city) loan(loan number, branch_name, amount)

Q2/ write SQL commands to create tables of a Bank database, where these tables will have the following schemas: branch(branch_name, branch_city, assets) customer(customer name, customer_street, customer_city) loan(loan_number, branch_name, amount)

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 documents

PL/SQL Problems Q1. Create a function to calculate a shopper’s total spending, excluding shipping and tax amount, with Brewbean’s site in a particular year. Exception handling is needed. Use an anonymous block to call the function and output the result. Q2.Create a procedure to allow an employee in the shipping department to update an order status to add shipping information. The BB_BASKETSTATUS table lists events for each order so that a shopper can see the current status, date, and comments as each stage of the order process are finished. Use an anonymous block to test your procedure. Q3.Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. Use an anonymous block to call the function and output the result. Q4.Create a function to determine the total pledge amount for a project. Use the function in an SQL statement to…

MYASQL 7. Create Avgoffreight() stored procedure to retrieve the average of freight from Orders table. Then , show the result.8. Write a database trigger TO insert the UnitPrice field.IF UnitPrice is less than 10 then make it equal to 10.(BEFORE INSERT). Test the trigger and show its result.procedure and trigger9. Select the first 10 characters of each customer's address. (Hint: You can use one of the built-in functions that are explained in functions file). (bonus, if you want to get higher mark, you can answer it, if not ,you can upload the solution file without it )

A select operation in a relational database is used to cut down on the size of a table by deleting columns that meet certain needs.True or not?