consider the database below and answer the query. pk refers to primary key and FK refers to foreign key.    Employee(Employee_id(PK), First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK) COmmision_pct, manager_id, department_id(FK))   Departments(Department_id(PK), dept_name, manager_id(FK), location_id)   Locations(Location_id(PK), street_address, postal_code, city,

Q: Employee_Id, First_Name, Last_Name, Email, Phone_Number, Hire_Date, Job_Id, Salary, Commission_Pct,…

A: a. To get the average salary and number of employees working in department 90, we can use the…

Q: Refer to the given tables. Salesperson Salesperson Commission Year of Department Manager Number Name…

A: In order for a relation to be in the 2NF, it must be: Should not include partial dependency in 1NF.…

Q: E. The AMD venue is where the music festival showcases up-and-coming bands. We want to identify…

A: This query can be defined in such a way that it will first be part of the ticket_sales_fact table…

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: DELETE CASCADE: - When we constitute a foreign key using this option, it deletes the referencing…

Q: write a query to drop all tables(Hint: make sure to consider foreign keys)

A: WE have to  write a query to drop all tables(Hint: make sure to consider foreign keys)

Q: Write a query to find the name of the student(s) who has scored maximum mark in Software…

A: Introduction: As per the given problem statement we are required to develop a SQL code to find the…

Q: What data types would you use for the attributes in this entity? How would you code a CREATE TABLE…

A: In a database management system (DBMS), an attribute is a piece of data that describes an entity.…

Q: Hospital Doctor Patient District Patient doctor h_id Hospital_name Area d_id d name p_id p_name c_id…

A: Primary Key:         Primary Key in a table ensures that the primary key value are unique and…

Q: Write SQL code for the following questions: Add a new table called SALES_YourFirstName. Please note…

A: As per company guidelines we are suppose to answer only 1 question. Kindly re-post other  questions…

Q: Please write the MySQL query for the following task: Find the first_name, last_name, employee_id,…

A: we can use the following MySQL query:

Q: Using the World database, display the distinct districts that have more than 20 cities within them.…

A: To display the distinct districts that have more than 20 cities within them.   The query can be…

Q: The foreign key in the table adult is called a foreign key.

A: Referential Foreign Key

Q: The Car Maintenance team considered that the available maintenance tasks should also have the price…

A: TASK 1: -- Creating a new table MAINTENANCE_TYPES with following fields create table…

Q: Figure Q3.16b The CUSTOMER and CAR Tables Database name: Ch03_Questions Table name: CUSTOMER Table…

A: Attributes are the properties or characteristics of entities. Relationships describe how entities…