Assume the following relations, write the Relational Algebra equations: BOOKS(DocId, Title, Publisher, Year) STUDENTS(StId, StName, Major, Age) AUTHORS(AName, Address) borrows(DocId, Stld, Date) has-written(DocId, AName) describes(DocId, Keyword) 1. List the year and title of each book. 2. List all information about students whose major is CS. 3. List all students with the books they can borrow 4. List all books published by McGraw-Hill before 1990

Assume the following relations, write the Relational Algebra equations: BOOKS(DocId, Title, Publisher, Year) STUDENTS(StId, StName, Major, Age) AUTHORS(AName, Address) borrows(DocId, Stld, Date) has-written(DocId, AName) describes(DocId, Keyword) 1. List the year and title of each book. 2. List all information about students whose major is CS. 3. List all students with the books they can borrow 4. List all books published by McGraw-Hill before 1990

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

SQL Queries: Given the following schema. Primary keys are underlined and highlighted in yellow and foreign keys are bold. The meaning of the relations is straightforward. Medical_Staff(MS_Id, MS_First, MS_Last, MS_PhoneNumber, MS_Occupation, Salary) Blood_Bank(Bank_Id, Bank_Name, Bank_Street, Bank_City, Bank_St, Bank_PhoneNumber) Donor(Donor_Id, Donor_First, Donor_Last, Donor_BloodType, Donor_City, Donor_St, DOB, TotalNumberOfDonations) Donation_Record(Donor_Id, Donation_Date, Donation_Amount) Employee(MS_Id, Bank_Id) Storage(Donor_Id, Donation_Date, Bank_Id) Write SQL queries to answer the following questions: a.Find the average donation amount for Sue Thompson (Donor Id = 3329) for the year 2018. b.Sum all donations by Bank for each State (i.e. the State the blood bank is located in, not the Donor). c.Find the name of the youngest donor and all the donations made in by that donor in 2020.
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have not taken any courses. APPENDIX STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
Which of the following can be the output of an operation in relational algebra?(a) An attribute(b) A relation(c) An expression(d) All of the above
27. Which of the following is not a restriction for a table to be a relation? a. The cells of the table must contain a single value. b. All of the entries in any column must be of the same kind. c. The columns must be ordered. d. No two rows in a table may be identical.
Please convert this EERD to relation. Thanks
Consider the following relations: BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff no, Fname, Lname. address, position, salary, branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area '34 east 2. Find staff whose salary is greater than the salary of evcry member of staff at branch 71. 3. List all stalf who their last name ends with ith'. 4. Find all the staff that works in branch 345 and have salary between 15000 and 45000.
write following queries
INFO 2103 Database Programming Assignment #3 For this assignment, please use the SUPPLIER and COMPUTER table. The script is available in Google Classroom. Script name: computer.sql. Note: Use Subqueries 1. Display the supplier that supplied the most computers. 2. Display the building location that has the most computers.
1) List all the functional dependencies of the above table. (Note, this requires you to state all the functional dependencies, not just count the number). 2) What normal form(s) is the table currently in? Justify your answer.