Consider the relations Courses1, Courses2,_Enrollmentand Students.Coursescid enameAl CalculusA2 AlgebraA5 EnglishLocationLIL2L3Student(sid, sname, age, level)Courses2cidASB1B2nameEnglishHistoryb) Courses 1-Courses2L3L4Computing L5c) Courses Courses2Classroom(1) Give the results of the following relational_algebra expressions:a) Teid ( name='History' OR 'Computing (Courses2))d) Courses1 Enrollmente) Enrollment / Teid (Courses1)Enrollmentsid cid101 Al102 A5103 Bl102 Al102A2CARENA(2) Write the following query in Relational Algebra.a) Find the sids of students who have enrolled incourse Calculus.b) Find the names of students who have enrolled incourse Calculus._c) Find the names of students who have enrolled atleast one course._d) Find the names of students who have enrolled in_Calculus or Algebra.e) Find the sids of students who have enrolled in allcourses (both Courses1 and Courses2).

Consider the relations Courses1, Courses2, Enrollment and Students. Courses cid ename Al Calculus LI A2 Algebra L2 A5 English 13 Courses2 Location cid Student(sid, sname, age, level) name Classroom AS English L3 B1 History L4 B2 Computing L5 Enrollment sid cid 101 A1 102 A5 103 BI 102 A1 102 A2 (1) Give the results of the following relational algebra expressions: a) Teid ( name='History' OR 'Computing (Courses2)) b) Courses1-Courses2

Consider the relations Courses1, Courses2, Enrollment and Students. Courses cid ename Al Calculus LI A2 Algebra L2 A5 English 13 Courses2 Location cid Student(sid, sname, age, level) name Classroom AS English L3 B1 History L4 B2 Computing L5 Enrollment sid cid 101 A1 102 A5 103 BI 102 A1 102 A2 (1) Give the results of the following relational algebra expressions: a) Teid ( name='History' OR 'Computing (Courses2)) b) Courses1-Courses2

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: Consider the following relational schema: Staff (staffNo, name, dept, skillCode) Skill (skillCode, description, chargeOutRate) Project (projectNo, startDate, endDate, budget, projectManagerStaffNo) Booking (staffNo, projectNo, dateWorkedOn, timeWorkedOn) where: Staff contains staff details and staffNo is the key. Skill contains descriptions of skill codes (e.g. Programmer, Analyst, Manager, etc.) and the charge out rate per hour for that skill; the key is skillCode. Project contains project details and projectNo is the key. Booking contains details of the date and the number of hours that a member of…
SELECT X.A FROM X,Y,Z WHERE X.A=Y.A OR X.A=Z.A Answer the next two questions (Questions 8 and 9) based on the user requirements. Question 8 Give the relational algebra term that this query would be compiled to.
Question 2 Draw the result after applying each of the relational algebra operations on the following table: a) Union DBCOURSES SECOURSES Code Code ITDB4101 Name Name ITSE1202 ITAD1100 MATH1102 | Pure Math ASP OS ITDB1102 Database IT Skills MATH1102 Pure Math IT Skills ITAD1100 ITSE1101 The result of DBCOURSES U SECOURSES is:
I1. In a Database Company, there are two tables given below : Table : SALES Table : LOCATION SALESMANID NAME SALES LOCATIONID LOCATIONID LOCATIONNAME ANITA SINGH ARORA 250000 102 101 Delhi S2 Y.P. SINGH 1300000 101 102 Mumbai S3 TINA JAISWAL 1400000 103 103 Kolkata S4 GURDEEP SINGH 1250000 102 104 Chennai S5 SIMI FAIZAL 1450000 103 Write SQL queries for the following : () To display SalesmanlID, names of salesmen, LocationID with corresponding location names. (1) To display names of salesmen, sales and corresponding location names who have achieved Sales more than 1300000. (m) To display names of those salesmen who have "SINGH in their names. ) Identify Primary key in the table SALES. Give reason for your choice. () Write SQL command to change the LocationID to 104 of the Salesman with ID as S3 in the table ICBSE OD 151 "SALES'.
USING RELATIONAL CALCULUS Customer(custNr, name, baseLoc,birthDt, gender) Property (propId, locDesc, state, propType, rating) Rental(custNr, propId, startDt, totalCost) use the following tuple variables: Customer – c, Property – p, and Rental – r. Please show appropriate relational calculus RANGE statements and a single GET statement (1)Find the customer number and names of customers who have rented all of the properties having a propType of "C".
SQL Help
FACULTY (Faculty Code, Faculty Name) DEPARTMENT (Dept_ID, Dept_Name, Faculty_Code*) LECTURER (Lect_ID, Lect_Name, Lect_Qualification, Dept_ID*) FULL TIME LECTURER (Lect ID*, Expertise, HireDate) PART TIME LECTURER (Lect ID*, HoursWork, RatePerHour) a) Based on the above relational schema you are required to draw the Entity Relationship Diagram (ERD). b) Do the relational schema above exhibits referential integrity? Answer yes or no and then explain your answer. TABLE REFERENTIAL INTEGRITY EXPLANATION FACULTY DEPARTMENT LECTURER FULL_TIME_LECTURER PART_TIME_LECTURER
Write a relational calculus based on the following relations: Professor (ProfID, ProfName, DeptNo) Course (CrsID, CrsName, Credits, DeptNo, ProfID) Department (DeptNo, DeptName) Use domain relational calculus; 1. List all course names provided by the department named "Information Technology". 2. List all professor information who work the department named "Information Technology".
Consider the relations Courses1, Courses2, _Enrollment and Students. Courses1 Location cid ename Al Calculus LI A2 Algebra L2 A5 English L3 Student(sid, sname, age, level) Courses2 cid A5 BI B2 name English History b) Courses 1-Courses2 L3 L4 Computing L5 c) Courses Courses2 Classroom d) Courses1 Enrollment (1) Give the results of the following relational algebra expressions: a) Teid ( name='History' OR 'Computing (Courses2)) e) Enrollment / Teid (Courses1) Enrollment cid Al A5 sid 101 102 103 102 102 B1 Al A2 (2) Write the following query in Relational Algebra. a) Find the sids of students who have enrolled in _course Calculus. b) Find the names of students who have enrolled in course Calculus. _c) Find the names of students who have enrolled at least one course. d) Find the names of students who have enrolled in _Calculus or Algebra. e) Find the sids of students who have enrolled in all courses (both Courses1 and Courses2).
Quiz 1 العودة 00: all cö Given the following database schema: Customer(cid., cname , rating, salary) Item(iid, iname , type ) Ooder(cid, iid , day , gty ) what is the relational algebra that retrieve the names of customers who have ordered item with id 100 .a .All choices are correct .b 1ramelo iid=100 'iid=100 (OrderCustomer)) .C iid=100 1-100Order)aCustomer) .d (Order) templ<-o temp2<-templdCustomer Ocname(temp2) iid=100
Q2: Design Database for the following scenario and Write SQL queries. Create an ERD for the following scenario. Suppose there is a grocery store near your house. Following can be considered for ERD: A grocery store may have more than one employee. A grocery store has exactly one manager. The manager has one or more sales men working under him. Grocery store has more than one portion for the products. • Each product has a barcode, name, expired date. Many customers can busy many products, but each product is bought by only one customer. Each customer will get an invoice for his /her purchase. The bill invoice has an id.
Consider the following expressions, which use the result of a relational algebra operation as the input to another operation. For each expression, explain in words what the expression does. a. year 2009 (takes) ▷ student b. year 2009 (takes ▷ student) C. ID.name, course_id (student takes)