$1.$ What is a Distributed Database?

$2.$ What are the advantages of using a Distributed Database?

$3.$ What are the types of Distributed Databases?

$4.$ What is Data Replication in Distributed Databases?

$5.$ What is Data Fragmentation in Distributed Databases?

$6.$ What is Consistency in Distributed Databases?

$7.$ What are some common challenges in Distributed Databases?

$8.$ What is Two$-$Phase Commit $(2$PC$)$ in Distributed Databases?

$9.$ What is a Distributed Query Processor?

$$

$10.$ CREATE TABLE $`$customer$`($

$`$Cust$\_$id$`$ int unsigned NOT NULL AUTO$\_$INCREMENT,

$`$first$\_$name$`$ varchar$(45)$ NOT NULL,

$`$last$\_$name$`$ varchar$(45)$ NOT NULL,

$`$email$`$ varchar$(45)$ NOT NULL,

$`$phone$\_$no$`$ varchar$(45)$ NOT NULL,

$`$hire$\_$date$`$ varchar$(45)$ NOT NULL,

$`$job$\_$id$`$ varchar$(45)$ NOT NULL,

$`$Salary$`$ decimal$(2,0)$ NOT NULL DEFAULT $\text{'}0\text{'},$

$`$Commission$\_$pct$`$ decimal$(2,0)$ NOT NULL,

$`$Manager$\_$id$`$ int NOT NULL,

$`$Dept$\_$id$`$ int DEFAULT NULL,

$$ PRIMARY KEY $(`$Cust$\_$id$`,`$email$`)$

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_0900\_$ai$\_$ci

$$

$$

$$

$$

$***$ create a table$$ using the above syntax

$*****$ insert into the table $5$ records

$$

A$.$ From the following table, write a SQL query to find those employees who receive a higher salary than the employee with ID $163.$ Return first name, last name.

$$

B$.$ From the following table, write a SQL query to find out which employees have the same designation as the employee whose ID is $169.$ Return first name, last name, department ID and job ID$.$

C$.$ From the following table, write a SQL query to find those employees whose salary matches the lowest salary of any of the departments

$$

D$.$ From the following table, write a SQL query to find those employees who earn more than the average salary. Return employee ID$,$ first name, last name.

$$

E$.$ From the following table, write a SQL query to find those employees who report to that manager whose first name is $$Payam$.$ Return first name, last name, employee ID and salary.

$$

F$.$ From the following tables, write a SQL query to find all those employees who work in the Finance department. Return department ID$,$ name $($first$),$ job ID and department name.

$$

G$.$ From the following table, write a SQL query to find the employee whose salary is $3000$ and reporting person$$s ID is $121.$ Return all fields.

$$

H$.$ From the following table, write a SQL query to find those employees whose ID matches any of the numbers $134,159$ and $183.$

$$

I.$$ From the following table, write a SQL query to find those employees whose salary is in the range of $1000,$ and $3000($Begin and end values have included.$).$ Return all the fields.

$$

J$.$ From the following table and write a SQL query to find those employees whose salary falls within the range of the smallest salary and $2500.$ Return all the fields.