Question: Database task Q1: Consider the following SELECT-FROM-WHERE statement. SELECT movie Title FROM Starsin, Movie Star WHERE starName = name AND birthdate = 1960; It can
Q1: Consider the following SELECT-FROM-WHERE statement. SELECT movie Title FROM Starsin, Movie Star WHERE starName = name AND birthdate = 1960; It can be translated into Relational Algebra as follows: Q2: Consider the following relations and answer the given questions: branch (branch name branch_city, assets) customer customer name, customer_street, customer_city) account (account number, branch_name, balance) loan (loan number, branch_name, amount) depositor (customer name, account number) borrower customer name, loan number) Write a relational algebra expression to find the loan number for each loan of an amount greater than 1000 JD
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
