Q1) you have the following table given below: CUSTOMER Customer ID - Gender phone - Address - Account - Balance - Name Email ali.m@gmail.com 077099999999 Iraq/ Mosul current ali.h@gmail.com 077088888888 Iraq/ Mosul current faris.a@gmail.com 075099999999 Iraq/ Basra saving basim@yahoo.com 075088 muna@yahoo.com 078077777777 Iraq/ Erbil mazin@gmail.com 077011111111 Iraq/ Basra 17885 ali mohammed male 2500 16225 ali hadi 20002 faris ali male 4500 male 3100 52355 basim ameen male Iraq /Mosul current 1700 32154 muna ammar female saving 8500 49768 mazin salim male current 1600 huda@yahoo.com 078099999999 Iraq / Erbil mahmod@gmail.com 078055555555 Iraq/ Mosul current jalil.m@yahoo.com 077022222222 Iraq/Basra saving 19283 huda ahmad female saving 6500 76654 mahmod ali male 2000 22445 jalil mazin male 7800 * By using SQL language view: 1- Male customers' information whose balance less than or equal 4500 and accounts are current. 2- Female customers' Names, address who live in Erbil and their balance between (3000 – 5000). 3- Female customers' Names who are use KOREK company on their phone. * How many Records will be appearing after executing the following query? 1- SELECT Name, address, gender FROM CUSTOMER WHERE balance<=2000 AND name like ('*ali* ') ORDER BY name DESC. 2- SELECT address , gender FROM CUSTOMER WHERE address= 'Mosul' ORDER BY name DESC

Q: Standard two-part naming in SQL Server follows which convention? a. [server name].[table name] b.…

A: Hello studentIn the realm of SQL Server, naming conventions play a pivotal role in maintaining…

Q: Branch ID Bank Name Loan Loan Account no Client address status name William New York Phoenix 201 MBL…

A: In this problem, we will write SQL query to solve the given problems.

Q: INSTRUCTIONS  Using spreadsheet software enter the following table below that shows the number of…

A: Organization and display of tourism information is crucial to understanding trends and making…

Q: Consider the following two tables:               Table1: Customers   customerID Fname Lname…

A: SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount               FROM Customers AS c…

Q: Consider the following two tables: Tablel: Customers customerID Fname 100 101 Lname Amri Kalabani…

A: 1)Inner Join- Selects matching data from customer and orders.

Q: SQL Injection: Question: What command retrieves a list of tables where the user passwords can be…

A: SQL commands are instructions given to the database to perform different operations on it. Commands…

Q: Q4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies…

A: I have provided the dependency diagram for the DESTPATCH_LIST of the given table.

Q: Covert this table to a First Normal form. Use the following format for the table:…

A: First we will check if table is in 1 NF or not, if not then we will convert it to 1NF. Then we will…

Q: Year Gender Name_of person Date_of_birth Membership _type Contact_phone_no joined Contact_email 2018…

A: We can use Excel Forms for this.

Q: Northwind Database How many orders are shipped to a Portugal address? How many of those have a…

A: Both the queries are solved using the NorthWind Database and given in the next steps Also given a…

Q: In this comment: sudo ./lynis --auditor cisco.   cisco is           the name of the company…

A: In this comment: sudo ./lynis --auditor cisco.   cisco is the name of the auditor.

Q: 8002 1002 30/3/2020 528.10 8003 1003 12/4/2020 194.78 8004 1004 23/4/2020 619.44 1. Create both the…

A: Actually, database is a used to stores the data.

Q: Jhon work on the sales team in the international company. He got the assignment to find out the…

A: We can solve this query by using ROWNUM definition  You can use ROWNUM to limit the number of rows…

Q: Ensure the Employee Satisfaction worksheet is active, then use the FREQUENCY function to calculate…

A: 1. Add in the formula for these as such =FREQUENCY(C2:C10,F5:F9) • Do, change it according the…

Q: Answer fast in 15 min.

A: According to the given question, we are required to create the Users table having the given table…

Q: Database System Find out candidate keys, dependencies and normalize the following table upto 3NF

A: First of all lets know about the concept of Candidate Key: Candidate Key:   A candidate key is a…

Q: In what normal form is SHIPMENT? Why?

A: Given, Shipment Relation table: Shipment# Origin Destination Distance 409 Seattle Denver 1,537…

Q: Q5. They also asked you to modify the PRODUCT table by adding 10% to all the prices of 'G Tokyo…

A: The solution is given below with demo data in each of the product and vendor tables to understand…

Q: onsider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which…

A: Lets see the solution.

Q: which type of joins is not supported by mysql inner Joins Right Joins Full joins Left Joins

A: The question is asking about the types of joins that are not supported by MySQL. In SQL, a JOIN…

Q: please make this on access step by step

A: struct Cars {     string mark &amp;#91;10] =…

Q: address city state zipcode phone number

A: A denotative integrity asserts a relationship between 2 tables specified the values in a very column…

Q: bank code name address customer Fname Lname phone Birth date gender ssn Customer_location | address…

A: Normalization means splitting the large table into many smaller tables in order to minimise the data…

Q: Which type of index is the best if you have 1000 customers that you must to insert their info. Every…

A: Below i have answered:

Q: Supplier PK PK Id FK CompanyName ContactName Product Contact Title City Country Phone Fax Id…

A: A relational database contains tables. A table is a grid containing rows and columns. It is also…

Q: 2. Write an SQL statement that will insert the following records a. Table Name: StudentInfo First…

A: Dear Student, SQL Query for each Insert is given below -

Q: 1- Retrieve the name and address of passengers

A: Here we need to provide a SQL Query.  Here both the attribute Name and address belongs to table…

Q: SQL ----------------------------------------- An example of a command a user would use when making…

A: Lets see the correct answer for both of the problems.

Q: 4. Write a query to count the number of invoices.

A: 1. a)CREATE TABLE CUSTOMER (    CUST_NUM int,    CUST_LNAME varchar(30),    CUST_FNAME varchar(30),…

Q: dentify the relational keys for each table. List each relational key in a separate line. Identify…

A: the solution is an given below :

Q: Your university runs many hundreds of courses each semester and needs to keep track of key…

A: the code is given below:-

Q: Format the range K2:K3 with Accounting Number Format with zero decimal places. Format cell K4 with…

A: Following needs to be performed for the given excel : Format cells K2 : K3 with Accounting Number…

Q: how do i create this table in apex orcacle?

A: Oracle Application Express (APEX) is a low-code development platform that enables users to build…

Q: Excel: estimate the price of the commodity between (16+ 900) to (16+ 1500) units.

A: Given Data : Initial unit = 16 + 900 units Final unit = 16 + 1500 units

Q: Create an implementation of a binary tree using the recursive approach introduced in the chapter. In…

A: Each node in a binary tree has a maximum of two child nodes, known as the left child and right…

Q: SQL. find the Clients who have more than 10,000$ in one of the accounts they own. Display their…

A: SQL Query to find the Clients who have more than 10,000$ in one of the accounts they own.

Q: 7. Using only one UPDATE statement, update the table movie to insert values for prod_id for all the…

A: Solution:   This question is from Mysql