A relational database has the following schema: Customer (Cno, name, address, age, loan_type, loan_amount, year) Solve following queries in relational algebra: Select the records where loan_type is 'Personal'. Select the records where age is geater than 30 and loan_type is ‘soft’. Select records from Customer table where loan_type is ‘Personal' and loan_amount is Rs200000 or those customers who opened an account after 2017. Project the columns name and address from the Customer table.

Assumptions: The database stores information about houses, each with a house ID, address, and zip code. 2. The database stores information about person, including person ID, house ID where the person lives, person name, phone number, and status where 1 means currently tested positive (i.e., the most recent test result is positive), 0 means currently tested negative (i.e., the most recent test result is negative), and null (no test so far so status is unknown). 3.The database stores information about a person's all past tests, including person ID, test date, and result (1 means positive and 0 negative). 4.The database stores information about events (could be gathering, party, etc.). Each event has an event ID, event name, date, and address. 5. The database stores information about a person participated in an event. 6. The database stores information about flights, including flight ID, flight date, flight number (a varchar type e.g., 'DL 345' is a delta 345 flight). 7. The database…

A database includes information on people and clubs. Each person is identified by an integer and has their name, and phone number recorded. Each club is identified by a name and the city it is located in. The relationship between club and person is 1:N. A person must be a member of only one club. A club may include zero or more people. Question:Write SQL CREATE TABLE statements for the tables in the problem statement above. Justify your choices of primary and foreign keys.

Using the sample database, create the Relational Algebra expression to answer the following queries. The database schema is as follows: Cars (c_id:number, c_brand:string, color:string, c_condition:string) Dealers (d_id:number, d_name:string, d_location:string) Inventory (c_id:number, d_id:number, costpercar:number, instock:number) Note: Inventory represents cars sold by dealers.   How would I write a database queries for the following? 1. Find the names of Dealers who sell some Black Car 2. Find the d_id of Dealers who sell some Black or Silver Car 3. Find the d_ids of Dealers who sell some Black Car or are in Miami 4. Find the d_ids of Dealers who sell some Black Car and some Yellow Car 5. Find the d_ids of Dealers who sell every Black Car 6. Find the d_id of Dealers who sell used Cars that are Black