Q.1.Consider the ER diagram shown below for part of a BANK database. Map the ER diagram into a RELATIONAL SCHEMA. Specify all primary keys and foreign keys.

Q.2.Use the relational schema shown below to answer following query. Use ONLY Relational Algebra Operations (RAO). For every project located in Houston and the controlling department also has a location in Houston. List the project name, the controlling department name and manager's last name.

Transcribed Image Text:

N. 1 BANK BANK-BRANCH BRANCHES Addr Code Name Addr BranchNo ACCTS LOANS N. AcctNo Balance LoanNo Amount Type ACCOUNT LOAN Type A-C L-C SSN Name CUSTOMER Phone Addr EMPLOYEE RIANE MNT LNAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO DEPARTMENT DNAME DNUMBER MGRSSN NGRSTARTDATE DEPT LOCATIONS DNUMBER DLOCATION PROJECT PNAME PNUMBER PLOCATION DNUM WORKS_ON ESSN PNO HOURS CEPENCENT ESSN DEPENDENT NAME SEX BDATE RELATIONSHIP