Consider the System Description of question no 2. All the student are advising to reply the followingqueries, keeping in view the above mention system description title as "Dream Home branch officescase study".(a) List the details of branches in a given city.(b) Identify the total number of branches in each city.(c) List the name, position, and salary of staff at a given branch, ordered by staff name.(d) Identify the total number of staff and the sum of their salaries.(e) Identify the total number of staff in each position at branches in Glasgow.(f) List the names of staff supervised by a named Supervisor.(g) List the property number, address, type, and rent of all properties in Glasgow, ordered by rentalamount.(h) Create a branch and staff relationship in view of joint perspective.(1) List the details of properties for rent managed by a named member of staff.G) Identify the total number of properties assigned to each member of staff at a given branch.(k) List the details of properties provided by business owners at a given branch.(1) Identify the total number of properties of each type at all branches.(m) Identify the details of private property owners that provide more than one property for rent.(n) Identify flats with at least three rooms and with a monthly rent no higher than £500 in Aberdeen.(0) List the details of leases due to expire next month at a given branch.(p) List the total number of leases with rental periods that are less than one year at branches in London.(9) List the total possible daily rental for property at each branch, ordered by branch number.

Answer: 1) select * from BRANCHES group by BRCT;2)select count(BRNUMBER) from BRANCHES group by…

(a) List the details of branches in a given city. (b) Identify the total number of branches in each city. (c) List the name, position, and salary of staff at a given branch, ordered by staff name. (d) Identify the total number of staff and the sum of their salaries. (e) Identify the total number of staff in each position at branches in Glasgow.

(a) List the details of branches in a given city. (b) Identify the total number of branches in each city. (c) List the name, position, and salary of staff at a given branch, ordered by staff name. (d) Identify the total number of staff and the sum of their salaries. (e) Identify the total number of staff in each position at branches in Glasgow.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Normalize the graph below in 3rd normal forml.
Distinguish between iterated and non-iterated queries.
4. Find all instructors in Finance department who have taught some course in 2008. 5. Find all students from Physics department who took course 'CS-319'.
A Company operates many factories. Each factory is located in a region. Each region can be “home” to many of the factories. Each factory employs many employees, but each of those employees is employed by only one factory.”
List out the steps for finding Use cases
How do you make a cell an absolute reference in Excel?
Design a struct personalinfo with components id, and name of type string. Design a class student with private data member's person (struct variable of type personalInfo), number Of Courses (of type integer), average (of type float), and marks[] an array of student's marks of type integer. The class also has the member functions ser( ), getPerson(), print(), findAverage(), getAverage(), and a parameterized constructor with default value 1 for the number of courses. Implement the member functions of the class student. The member function findAverage() is used to calculate the average mark for each student. I Write a driver that does the following: Declares the array section[ ] of objects of student type. Reads the number of students. Reads information for each student from the file student.txt. Calls the user-defined function int maxAverageIndex(int, student []) Prints the id and name of the student with the maximum average. Student.txt: 4 1463491 Ali 72 65 81 85 1370005 Yousef 5 91 82…
Design an entity relationship diagram (ERD) for the following Solomon's database:
Do Comparison between Disjoint rule, overlap rule
what is the notation in functions? Explain it.
4. Find all instructors in Finance department who have taught some course in 2008. 5. Find all students from Physics department who took course 'CS-319|* .
The KCA library orders books from one or more book suppliers. Each order contains quantity of books required, mode of delivery and the order date. The detail captured about a book includes the ISBN number, the title, author and publisher of the book. Books may be borrowed by registered members, who are identified by a borrower number. The library also keeps members’ name, email address and phone number. A member may borrow a maximum of two (2) books on each occasion. A supplier delivers one or more books orders to the library. The supplier’s name, address and telephone contact is kept by library. Draw an ERD to model the data stored in the KCA library system.