Database course: a. List the details of all the employees who are from the department number 2.  b. List the details of all the employees who joined the company after 01-JAN-11. c.  List employeeNO and DepartmentNO of all the employees who work as ‘Engineer’ and earn more than 1800 Omani Rials. (I need the codes to copy it)

Q: What Oracle function should you use to calculate the number of days between yourbirthday and the…

A: Oracle functions are constructed into Oracle Database and can be used in multiple SQL statements.…

Q: List the years and their total gross earnings (sum of earnings per year), but do not include gross…

A: ANSWER:-

Q: Write queries in relational algebra 1- Select all employees who either work in department 6 and make…

A: SELECT * FROM EMPLOYEE WHERE (DeptNo = 6  AND SALARY > 25000) OR (DeptNo = 4 AND SALARY >…

Q: A select procedure in a relational database can shrink a table's size by deleting columns that don't…

A: Answer is

Q: What are rhe types of subquery?

A: INTRODUCTION: A subquery is a query that is contained within a larger query statement. Subqueries…

Q: Q2: Do these queries: 1. Show department name and instructor name who is having salary greater than…

A: Due to company policies I am compelled to solve only one question and that is the first question.…

Q: Make a list of how many albums each artist has released. Only include artists with more than 5…

A: To create a list of artists with more than 5 albums, we need to query the database tables and count…

Q: A select procedure in a relational database can shrink a table's size by deleting columns that don't…

A: Database: A database is a collection of data that is arranged for easy access and management. You…

Q: Which one is correct Select the constraint (if any) that is violated by each the following…

A: The Entity integrity constraint states that primary key value can't be null. -------- Domain…

Q: t the title of all books in the same category as books previously purchased by customer 1007. Don’t…

A: Lets see the solution.

Q: Why are field values sometimes coded?

A: Given: Why are field values sometimes coded?

Q: a distinct difference between subqueries correlated and uncorrelated

A: Solution :- In the above question, the statement is mention in the above given question   Need to…

Q: ect the constraint (if any) that is violated by each the following operations in questions. Use ples…

A: Here table Student_Course refers to table Course.  So when we delete an entry from Course table we…

Q: access databases Normalization Exercise Represent this table as a collection of tables in 3NF:…

A: The key for the given relation is (StudentNumber, CourseNumber)  The partial functional dependency…

Q: Using database, show the first name and birthday for all female staff whose birthday is before…

A: Introduction: The AND, OR, and NOT operators can be used with the WHERE clause. Records can be…

Q: Create the Student table with following details: Data type Number Varchar(25) Field Constraint Sid…

A: We are assuming that the field book_id references a table by name of Book which has book_id as its…

Q: Consider the Schema of the university database. Select SQL query to display a list of all students,…

A: Here we are given multple tables such as takes with primary key (ID, course_id, sec_id)student…

Q: write a MySQL procedure to retrieve and output the item number, description, storehouse number, and…

A: Always prefer to provide database of table.

Q: There are 9 workers for ASH Development Sdn. Bhd. as shown in Table Q4. Unfortunately, there are…

A: According to question there are 9 workers and 4 rooms. The Ids of workers selected for the jobs are…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: creat the following tables and insert your own values: emp(eno, ename, bdate, title, salary, dno)…

A: The SQL INSERT INTO Statement is used to add new rows of data to a table in the database

Q: Change to use the database frozenfood Alter table customerOrder add column total as data type…

A: Note: As per our guidelines we can able to solve only three questions. So, please re-post the…

Q: What are the primary roles of database functions in SQL?

A: 1) Database functions in SQL are pre-defined operations that allow you to perform various tasks on…

Q: Is there a distinct difference between subqueries correlated and uncorrelated?

A: Subqueries correlated and Uncorrelated: As if the subquery were assessed on each row of the table in…

Q: 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order.…

A: According to the information given:- We have to follow the instruction in order to perform the…

Q: ng the Henry Books database, how many book codes have more than one copy at Henry Brentwood? List…

A: query is given below select count(BookCode) from inventory where onHand >1;

Q: o an existing order, include the product id, unit price, quantity. The output of the function is the…

A: given - Create a function to insert a new product into an existing order, include the product id,…

Q: ● ● Ex: Convert the following UNF table to 3NF form? Eno Ename Age Child_name Company Serv_year…

A: Here we have converted given table from UNF to 3NF. You can find the solution in step 2.

Q: MEMBER (memberID (PK), profession, name, address, telNo, areaCode (FK) VOLUNTEER (volunteerID (PK),…

A: The answer as given below;

Q: (Consider table employees with the following colunms (EMPLOYEE ID, FIRST NAME, LAST_NAME , EMAIL…

A: Select CONCAT(M.First_Name,' ', M.Last_Name) as MANAGER_NAME , M.Department_ID from Employees E…

Q: How many patients in the database have been diagnosed with acute bronchitis (ICD9Code = 466) and…

A: Count Query :- SELECT COUNT(column_name) FROM table_name WHERE condition; Groupby Query :-…

Q: 1. Report the student names and ages of all students who have a "hotmail" email address. Sort the…

A: 1. Report the student names and ages of all students who have a "hotmail" email address. Sort the…

Q: Write a query to create client table schema in such a way that if we delete row from parent, its…

A: NOTE : AS PER GUIDELINES, WE ARE AUTHORIZED TO ANSWER 3 SUB PARTS. REPOST OTHER PARTS. 1. create…

Q: . Using the Henry Books database, list the book code and title of every book that has the type SFI…

A: In this question we have to write a query for using a Henry book database for the given queries…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Salary from highest to lowest  Sorting emp name alphabet

A: Please find the answer below

Q: What is the average distance and average maximum group size for each type of trip?

A: "SELECT" command: The "SELECT" command is used to retrieve data in a database. Syntax for selecting…

Q: 2. Use RELATIONAL ALGEBRA to write the following queries: a) Find names and surnames of professors,…

A: In this question we have to understand about the schema provided to write a RELATIONAL ALGEBRA for…

Q: Write syntax for DELETE and TURNCATE in SQL databases.

A: Question. Write syntax for DELETE and TRUNCATE in SQL databases. Answer. DELETE: This query is used…

Q: Explain the purpose of correlated subquery.

A: The purpose of the correlated subquery is given below.

Q: A) Find all loan numbers with amount greater than $50,000. B) Find the names of all depositors who…

A: A) Find all loan numbers with amount greater than $50,000. σ(amount > 50000) (loan)

Q: From the database scheme write the query(all tables are empty) 1) Insert your name and your phone…

A: The given diagram is a logical model for the rent of apartments where the apartment has a building…

Q: Create a table named "LIBRARY" with the specifications mentioned below. Display the details of the…

A: The CREATE TABLE statement is used to create a new table in a database. Syntax: CREATE TABLE…