Preview

Relational Algebra and Bank Corporation

Good Essays
Open Document
Open Document
1070 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Relational Algebra and Bank Corporation
Exercises 3
(RA - TRC -DRC )

Consider the following relational database: employee(employee-name, street, city) works(employee-name, company-name, salary) company(company-name, city) manages(employee-name, manager-name)
For each of the following queries, give an expression in relational algebra, tuple relational calculus, and domain relational calculus: a. Find the names of all employees who work for First Bank Corporation. b. Find the names and cities of residence of all employees who work for First Bank Corporation. c. Find the names, street address, and cities of residence of all employees who work for First Bank Corporation and earn more than $10,000 per annum d. Find the names of all employees in this database who live in the same city as the company for which they work. e. Find the names of all employees who live in the same city and on the same street as do their managers. f. Find the names of all employees in this database who do not work for First Bank Corporation. g. Find the names of all employees who earn more than every employee of Small Bank Corporation. h. Assume the companies may be located in several cities. Find all companies located in every city in which Small Bank Corporation is located.
Answer:
NOTE: If t is a tuple in a relation, we use the notation t[A] to indicate the value t has for attribute A. So t[A] is the same as t.A that we used in the lectures. a. Find the names of all employees who work for First Bank Corporation:
i. employee-name(company-name = "First Bank Corporation"(works)) ii. { t | s works (t[employee-name] = s[employee-name] s[company-name] = "First Bank Corporation")} iii. { <p> | c, s (<p, c, s> works c = "First Bank Corporation") } b. Find the names and cities of residence of all employees who work for First Bank Corporation:
i. employee-name, city(employee (company-name = "First Bank Corporation"(works))) ii. { t | r employee s works

You May Also Find These Documents Helpful

  • Satisfactory Essays

    a. What is the total balance of Jessie Robinson 's real estate account? (0.5 points)…

    • 1780 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Murrell Denney, Joyce Buis, Rebecca McCollum, and Jewel Snyder are employees are the First State Bank of Eubank, Kentucky…

    • 438 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Chapter 05 Taxes

    • 3308 Words
    • 14 Pages

    Which of the following people is currently engaged in a trade or business? b. Only statement II is correct.…

    • 3308 Words
    • 14 Pages
    Powerful Essays
  • Satisfactory Essays

    i. List the customer number, last name, first name, and balance of every customer, sort by balance in descending order, and last name in ascending order.…

    • 2322 Words
    • 10 Pages
    Satisfactory Essays
  • Good Essays

    It206 Wk4 Scenarios

    • 918 Words
    • 4 Pages

    3. Have the user to complete all required fields on the spreadsheet pertaining to the company.…

    • 918 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    BE 1-7: Indicate which statement you would examine to find each of the following items: income statement (I), balance sheet (B), retained earnings statement (R), or statement of cash flows (C).…

    • 610 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    | | | |Complete one paragraph profiling each company's business including information such as a brief history, where they are located, number of employees, the products they sell, etc. Please reference any websites you used | | | | | | | | |used for the Profiles on the Bibliography tab. | | | | | | | | | | | | | |…

    • 649 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Inmate Gonzalez Meeting

    • 566 Words
    • 3 Pages

    On 10/25/2015 at approximately 1609 hours at the address listed above. I was assigned as the Tower 34 floor officer. As I was conducting a security walk in Tower 34 A-Pod, cell 8 Inmate Quintero, Cesar T221902 was standing at the back wall facing the wall with his cellmate Inmate Gonzalez, Yadhir T217188. I asked Inmate Quintero and Inmate Gonzalez what they were doing; Inmate Quintero stated “Nothing.” Inmate Quintero and Inmate Gonzalez then walked out of the cell. At that time I searched cell 8 and discovered a sharpened toothbrush in a drink bottle on the cell desk.…

    • 566 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Given the balance sheets and selected data from the income statement of SMG Industries that follow, answer parts (a)-(c).…

    • 579 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Article 11

    • 260 Words
    • 2 Pages

    7. In what form is the employee contact information listed? Can you give a brief description?…

    • 260 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Economics Quiz

    • 1415 Words
    • 6 Pages

    6) Which of the following entities is not a bank regulator? Office of Currency Regulation. C…

    • 1415 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Common Stock

    • 436 Words
    • 2 Pages

    Question 1.1. (TCO D) Which of the following statements concerning common stock and the investment banking process is NOT CORRECT?…

    • 436 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    There are essentially two ways spelled out in the Constitution for how to propose an amendment. The first method is for a bill to pass both houses of the legislature, by a two-thirds majority in each. Once the bill has passed both houses, it goes on to the states. This is the route taken by all current amendments. Because of some long outstanding amendments, such as the 27th, Congress will normally put a time limit (typically seven years) for the bill to be approved as an amendment (for example, see the 21st and 22nd). The second method prescribed is for a Constitutional Convention to be called by two-thirds of the legislatures of the States, and for that Convention to propose one or more amendments. These amendments are then sent to the states to be approved by three-fourths of the legislatures or conventions.There has been many attempts to change the information. There have been many failed attempts to change the process.…

    • 3653 Words
    • 12 Pages
    Good Essays
  • Satisfactory Essays

    G22 health and safety

    • 266 Words
    • 2 Pages

    c. Detail the lists and reports available within the workplace, and state the information they give…

    • 266 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Boeing Essay

    • 731 Words
    • 3 Pages

    Boeing Company is the largest manufacturer of commercial aircraft in the United States and is a major employer in Seattle, Washington. Explain why each of the following individuals or organizations would be interested in financial information about the company.…

    • 731 Words
    • 3 Pages
    Powerful Essays

Related Topics