Due: See class webpage
Formulate the following queries in Relational Algebra on the Company Relational Data Model:
The output relation has the following format:
Dname Sex Sum -------------------------------------- Research F .... Research M .... Payroll F .... (There is no row for departments with out employees of certain sex)
You request will be successful if you have not exceeded the maximum number of "free" (no-questions-asked) requests allowed
Consider the following relational database:
lives(person_name, street, city)
works(person_name, company_name, salary)
The meaning of the relations are as follows:
The underline attribute(s) in each relation is the primary key. The foreign keys are:
Formulate a Relational Algebra Query on the Location database for the following:
Students will be graded partially on the basis of their homework assignments. These homework assignments are to be treated as examinations, and are expected to be your individual work. While discussions with other students in the course may be permitted or encouraged by your instructor, you should write your program yourself. Your instructor (and any teaching assistants assigned to the course) will be glad to help you to the extent that he or she feels reasonable.
Submissions based on other students solutions in prior offerings of the course specifically violate these guidelines, as do submissions prepared with the help of an outside "tutor".
You should take precautions to protect the confidentiality of your work, do not collaborate on questions that you turn in for a grade, do not show your solution to a fellow student, not even after the due date for some students may have receive extension.
All submissions should include a comment statement near the top of the program of the form:
THIS CODE IS MY OWN WORK, IT WAS WRITTEN WITHOUT CONSULTING A TUTOR OR CODE WRITTEN BY OTHER STUDENTS - your name
Cases of apparent plagiarism or collusion will be referred to the Honor Council.