2. The following is an RDB schema discussed in the class: branch (branch-name, branch-city, assets) customer (customer-name, customer-street, customer-city) account (account-number, branch-name, balance) loan (loan-mumтber, branch-nате, атоиnt) depositor (customer-name, account-number) borrower (customer-name, loan-number) Consider the following English query: "Find the names and the residing cities of customers who have a deposit account at the Aksarban or Downtown branch." Write an RA expression for this query.

2. The following is an RDB schema discussed in the class: branch (branch-name, branch-city, assets) customer (customer-name, customer-street, customer-city) account (account-number, branch-name, balance) loan (loan-mumтber, branch-nате, атоиnt) depositor (customer-name, account-number) borrower (customer-name, loan-number) Consider the following English query: "Find the names and the residing cities of customers who have a deposit account at the Aksarban or Downtown branch." Write an RA expression for this query.

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

SUPLIER CUSTOMERS #id buy # id *name * tax number * product o email # name sell * address Find the mistakes in the ERD related to Entities, Attributes and Relationships. Explain reason for these mistakes. Make necessary changes on ERD and present only effected structures (entities, attributes and relationships) A- B I
I want this UML diagram to be mapped in C# code
Can you name the two tenets of aggregation?
Give a detailed explaination of the class diagram below
Change the Class Diagram to have (Generalization, Aggregation, Composition, Association and multiplicity) relations.
The following use case diagram represents an online food bank service that is ran by the university. It allows students to sign in with their university credentials, shop for items offered by the food bank free of cost, and pickup their order at the university when it is ready. Identify any gaps or redundancies in the use case diagram and offer any improvements. (Please note: the use of <> and <> may be incorrectly implemented)
When people talk about a "homogeneous structure," what do they mean by that?
12. Consider the following rules: IF a = 10 R1 AND b = 15 THEN c = 20 IF b = 15 R2 AND a = 10 THEN c = 20 Are these two rules redundant? Why? Which rule is made redundant by the other?
A company hires out tools and equipment to customers and requires a computerized system to record details of bookings. The customer appears at the reception desk and ask if there is an item available for immediate hire. When dealing with a booking or allocating an available item to a customer, the receptionist has to check whether the customer has previously hired equipment from the company or is a new customer. For a new customer, the receptionist has to enter the customer's details. Otherwise, the receptionist has to retrieve the existing customer's record and update any details if necessary. If the item is available then the customer can get it, otherwise, the receptionist might suggest other alternatives. If the alternative is accepted, then the receptionist allocates the tool and updated the customer record. Draw an activity diagram that models the data processing of hiring.
Draw a use case diagram for describing the functional requirements of the above system.