A) Find the total number of copies of the book titled Harry Potter and the Deathly Hallows B) List the names of all the books which have been borrowed by the person named John Smith C) Find the Branch names of all the library branches located in Dhaka City [Note Address does not mean City only] D) Retrieve the names of all borrowers who do not have any books checked out. II) Using Relational Algebra- A) Find the total number of books published by Macmillan Publishers B) List the names of the publishers of all the books authored by Dan Brown C) Find all the phone numbers of people who have not borrowed out a book currently. D) List the names of all the authors and the total number of books each of them authored

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: Write an SQL query to list the position and the number of employees in that position for those…

A: 1)select position,count(empNo) from employee where empNo IN (select empNo from Dependent where…

Q: Write the relational algebra to show hotel, roomNum and the price that costs the most

A: Given name of the table is Room. The attributes of the Room table are hotel, roomNum and price.

Q: Calculate the number of days that have passed between your birthday and the current date using an…

A: Given:   Calculate the number of days that have passed between your birthday and the current date…

Q: Compute the average number of hours for the courses offered by each college

A: Below i have written query:

Q: onsider the following schema: Product(pid, name, type, manufacturer, price), Buys(cid, pid),…

A: a) relational algebra:  π cname σ manufacturer = 'sears' Customer ⨝ Customer.cid = Buys.cid Buys ⨝…

Q: a) Write SQL queries for the following. 1) Display details of those patients whose age is either…

A: The Patient table consists of 4 columns and 8 records.  The SELECT clause is used to retrieve the…

Q: The following figure is part of a university database. LNAME and FNAME stands for last name and…

A: Project operation (denoted by pi (∏) symbol) is used to select desired columns (or attributes) from…

Q: 5. Cars must be ordered from a supplier when the stock for that particular car drops below 8. Find…

A: We have to write Relational Algebra to find the name of all the manufacturers of the cars whose…

Q: Write SQL Queries for following set of tables: EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary,…

A: As per our guidelines, only 3 subparts will be answered. So, please repost the remaining questions…

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: 4. b. C. Create the following queries: List the names of places from which the company sells. Show…

A: The database contents are not mentionedThe generalized query can be written asSelect * from…

Q: Adoption(AnimalID, SIN, AdoptDate, chipNo) Formulate the following queries in SQL; 1. Create the…

A: “Since you have posted a question with multiple sub parts, we will provide the solution only to 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: Write the following queries in relational algebra, using the university schema. a. Find the ID and…

A: Relational algebra is a procedural query language used to retrieve and manipulate data stored in…

Q: Write a SQL query. List names of all employees who have sold to customer Rachel Patterson (Note: You…

A: In this database problem, we are tasked with creating an SQL query that lists the names of all…

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :

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: 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: It's best to utilize an Oracle function to determine how many days have passed since your birthday.

A: Step 1 A server-less platform called Oracle Functions allows developers to design, execute and grow…

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.