Consider a database that consists of the following relations. SUPpLIER(Sno. Sname) PART(Pno, Pname) PROJECT(Jno, Jname) SUPPLY(Sno, Pno, Jno) The database records information about suppliers, parts, and projects andincludes a ternary relationship between suppliers, parts, and projects. Thisrelationship is a many-many-many relationships. Specify and execute the followingqueries using the relational algebra Retrieve the part numbers that are supplied to exactly two projects. b. Retrieve the names of suppliers who supply more than two parts to project J11 c. Retrieve the part numbers that are supplied by every supplier. d. Retrieve the project names that are supplied by supplier S1' only. e. Retrieve the names of suppliers who supply at least two different parts each to at least two different projects.

Motor Vehicle Dealership Database: Consider Aaron's dealership, a multi-brand vehicle dealership whose database consists of four relations as described below. Using this database, answer questions Vehicle(make, model, manfYear, color, vinNum, type, purchaseld) Stock(stockNum, unitPrice, deliveryDate, vehiclesRemaining) Manufacturer(name, manfCode, plantLocation) Purchase(purchaseld, mCode, numVehicles, orderDate, deliveryStatus) • A vehicle can be one of the following types: Car, Truck, SUV • vinNum →Vehicle Identification Number • manfCode/mCode → a 4 character alphanumeric code for the manufacturer • manfYear → year of vehicle manufacture • purchaseld and stockNum refer to the same item • The delivery status is true if the order has been delivered to the dealership and false otherwise • Manufacturer name may not contain the same data as the make of the Vehicle. For example, • name of the manufacturer: Ford Motor Company • make of the vehicle: Ford Q1. Using SQL, list the names of all…

Given the database schema below, write a relational algebra expression to get the count of records in the DEPENDENT relation group by Essn. Also, show the result of your query.

Q3) consider you have the Library database with the following relations, where the primary keys are underlined: Book (bookID, name, auther, No.-of-pages, section-name, category) Section(section-name, section-admin, no-of-books, library-code) Library(library-name, address, no-of-sections, manager-name, library-code, country)

EMPLOYEE Frame Minit Lname Sen Bdate Address Sex Salary Super sen Dno +444 DEPARTMENT Dname Dnumber Mor an Mgr start date DEPT LOCATIONS Dnumber Dlocation PROJECT Prame Prumber Plocation Dnum WORKS ON Ennn Pno Hoir Hours DEPENDENT Esen Dependent name Se Bdate Relationship Reforential integrity constraints displayed on the COMFWNY relational database schema. One possible database state for the COMPANY relational database schema. EMPLOYEE Fname Minit Lname John Frankin T Sex Salary 30000 333445555 5 M 40000 Jo00665555 F 25000 Joe7e54321 43000 J88Ge5556 San Bdate Address Super en Dno 123456789 1965-01-09 731 Fondren, Hounton, TX M 333445555 1955-12-08 638 Voas, Houston, TX Go0087777 1960-01-19 3321 Castle, Spring. TX 987654321 1941-06-20 291 Berry, Bellaire, TX Narayan 666884444 1962-09-15 975 Fire Oak, Humibile, TX M B Smith Wong Zelaya Wallace 5 Alicia 4 Jennifer F 38000 333445655 25000 333445555 M 25000 007654321 M 55000 NULL Ramesh English 453453453 1972-07-31 5631 Rice, Houston, TX F…

The following relations are part of a general store database: customer(custnum, custname, city, creditlimit) orders(ordernum, orderdate, filled, custnum) orderline(ordernum, productnum, quantity, salesprice) product(productnum, descr, producttype, msrp, onhand) Here is a sample data (assume there are more records)Using PROJECT, SELECT and JOIN, write the sequence of operations to answer each of the following questions: 1a. What are the names and customer numbers of customers who are from Mississauga? 1b.What are the names of products (descry) and product types of products purchased by customers from brapton?

Don't copy again and again that is wrong.  Please help me with this question.

Relational Algebra Questions:Using the instance of the Airport database, formulate the following queries in the relationalalgebra: 1. List full details of all airports located outside the United States.Note: You should use the not equal sign  in this query. 2. List the name and the state of all United States airports. 3. List the name and the fleet size of all carriers employing more than 50000 workers. 4. List the carrier name, the carrierID, the flightNo and the date of all flights. 5. Display the number of airports. 6. Display the number of flights with distances longer than 3000 miles. 7. Display the number of all carriers and the average of their revenues. 8. Display the number of flights leaving from JFK and the total of their distances. 9. Display the minimum, the average, and the maximum distances of the flights that arescheduled on October 17th, 2017?