Write expressions of relational algebra to answer the following queries: We have the database consist of 4 relations:Table KHOA:MaKHHTTTMANGCNPMKTMTKHMTTenKHHệ thống thông tinMạng và truyền thôngCông nghệ phần mềmKỹ thuật máy tínhKhoa học máy tínhTable SINHVIEN:MASV HOSVSV01SV02SV03SV04SV05SV06SV07SV08Lê KimTrần MinhSV01SV01Lê AnTrần AnhTrần ThịLê Thị ThuNguyễn KimLê VănTable KETQUA:Masy MaMHSV01CSDLSV01CSDLTTNTTTNTSV01MMTSV02 CSDLSV02CSDLSV02 MMTSV02 CTDLSV03 CSDLCSDLSV03SV03 MMTSV03MMTSV04CSDLSV04CTDLSV05CSDLSV05MMTSV05 MMTSV06TTNTSV06DHMTLanThi12121121112121111TenSVLanChánhTuyếtTuấnMaiThuyThuLong211GioiTinhNữNamNữNamNữNữNữNamDiem365.5654.57109252.544.51072.55610TrượtDatTable MONHOC:MAMHCSDLTTNTMMTDatDatDHMTCTDL|NgaySinh23/02/199024/12/199221/02/199120/12/1993KetQuaTrượtDatDatDatDatTrượtDatDatDatTrượtDatTrượtTrượtTrượtDatDatΤΕΝΜΗCơ sở dữ liệuTrí tuệ nhân tạoMạng máy tinhĐồ họa máy tínhCấu trúc dữ liệuNoiSinhHà nộiBình ĐịnhHải phòngTpHCM12/08/1991 TpHCM02/01/1991An Giang02/02/1990Hà Nội08/12/1992 TpHCMMaKHHTTTMANGHTTTMANGCNPMHTTTCNPMHTTTSOTIET|45 45 456060Hoc Bong1300001500001700008000000180000190000Diem TB Exercise 1: Write expressions of relational algebra to answer the following queries:a. Find MaMH and TenMH of all courses having SOTIET greater than 45.b. Find MaSV, HoSV, TenSV of all students of the department Hệ thống thông tin.(denoted department name is TenMH)c. Find MaKH, TenKH of all departments having no students.(denotation of departments is MaKH,, student code is denoted by MaSV)d. Find MaMH, TenMH of all courses learned by both Lê Kim Lan and Trần Minh Chánh.(the symbol of the courses is MAKH)e. Find the MaSV, HoSV, TenSV of student having the highest scholarship.(the symbol for the scholarship is HOCBONG)f. Find the MaSV, HoSV, TenSV of all students participating in at least two differentcourses.g. Find the MaSV, HoSV, TenSV of all students participating in one course many times.

As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Exercise 1: Write expressions of relational algebra to answer the following queries: a. Find MaMH and TenMH of all courses having SOTIET greater than 45. b. Find MaSV, HoSV, TenSV of all students of the department Hệ thống thông tin. (denoted department name is TenMH) c. Find MaKH, TenKH of all departments having no students. (denotation of departments is MaKH,, student code is denoted by MaSV)

Exercise 1: Write expressions of relational algebra to answer the following queries: a. Find MaMH and TenMH of all courses having SOTIET greater than 45. b. Find MaSV, HoSV, TenSV of all students of the department Hệ thống thông tin. (denoted department name is TenMH) c. Find MaKH, TenKH of all departments having no students. (denotation of departments is MaKH,, student code is denoted by MaSV)

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

A. The relation R(a,b) may have duplicate tuples. Which of the following queries has a result that is guaranteed not to have duplicates, regardless of what tuples R contains? a) SELECT a, AVG(b) FROM R GROUP BY a b) SELECT b FROM R WHERE a = b c) SELECT a FROM R WHERE a >= ALL (SELECT a FROM R) d) SELECT a FROM R WHERE a = 1 B. Relation R(a,b) has no duplicate tuples, although neither a nor b is a key. Relation S(c,d) may have duplicates. Which of the following queries is guaranteed to produce no duplicates? a) SELECT c, d FROM S WHERE c IN (SELECT a FROM R) AND d IN (SELECT b FROM R) b) SELECT S.c, S.d FROM R, S WHERE R.a = S.d AND R.b = S.c c) SELECT c FROM S WHERE c = d d) SELECT c, d FROM S GROUP BY c, d
For the given schema, write relational algebra for the following queries. Student (id, name) EnrolledIn (id, code) Subject (code, lecturer) 1. What are the names of students enrolled in cs3020? 2. Who teaches cs1500 or cs3020? 3. What are the names of students in cs1500 or cs3010? 4. What are the names of students in both cs1500 and cs1200? 5. Which subjects is Hector taking?
Student ID | Student_name | Cource ID | Cource name | Grade 2 Noor 1 HIML B+ 7 C++ A 3 JAVA B 25 Al 2 C+ A 3 JAVA B 27 Sara 1 HIML A 3 JAVA A 28 Abmed 2 C++ B+ 1. What update anomalies may occur in the selation? 2. In which normal form (NF) the above relation? Provide an explanation to support your answer. 3. Decompose the relation so that the resut relations are in the third normal form (3NF).
convert it to relations that are normalization
Given the following relation that stores details of student registration: Stu_ID Name Town Province Course RegisteredDate S101 Malak Al Nadabi Al Khuwair Western ITDR2106 02-02-2020 S101 Malak Al Nadabi Al Khuwair Western ITDR1105 14-09-2019 S102 Nadar Al Hashli Daesit Southern ITDR1102 05-02-2020 S102 Nadar Al Hashli Daesit Southern ITDR1101 05-02-2020 S103 Basit Barkat Ruwi Central ITDR1105 06-02-2020 S104 Yeshan Al Khuwair Western ITDR2106 15-09-2019 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. Stu_ID à Name, Town Town à Province Course à RegisteredDate RegisteredDate à Course Stu_ID, Course à RegisteredDate Stu_ID à Course Stu_ID
Consider a database that consists of the following relations.SUPpLIER(Sno. Sname)PART(Pno, Pname)PROJECT(Jno, Jname)SUPPLY(Sno, Pno, Jno)The database records information about suppliers, parts, and projectsandincludes a ternary relationship between suppliers, parts, and projects.Thisrelationship is a many-many-many relationships. Specify and execute thefollowingqueries using the relational algebraRetrieve the part numbers that are supplied to exactly two projects.b. Retrieve the names of suppliers who supply more than two parts toproject J11c. Retrieve the part numbers that are supplied by every supplier.d. Retrieve the project names that are supplied by supplier S1' only.e. Retrieve the names of suppliers who supply at least two different partseach to at least two different projects.
Consider the following relations for a university: Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer)Department (did: integer, dname: string(30 chars), capacity: integer)Course (cid: integer, cname: string(50 chars), credit: integer)Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. 1) For each student with GPA between 2.5 (included) and 3.5 (included), display the student’s name, GPA,and his/her department ID. Sort the results by the students’ IDs in descending order. 2) For each student who joined the Computer Science department between 2018 (included) and 2020(included), display the…
Identify all the functional dependencies in the following relation with columns A, B, C, and D a.A→B b.A→C c.A→D d.B→A e.B→C f.B→D g.C→A h.C→B i.C→D j.D→A k.D→B l.D→C
DataBase Management System Determine the keys and superkeys of the relation R(ABCDEF) with FD's: (You MUST show the step-by-step of how you find superkeys and keys) ACE →D, AEF → B, CE → B, EF → D, and ABDF → E
a: Draw relational model b: Normalize upto 3NF
If a parallel data-store is used to store two relations r and s and we need to join r and s, it may be useful to maintain the join as a materialized view. What are the benefits and overheads in terms of overall throughput, use of space, and response time to user queries?
) Consider the relations r(A, B, D), and s(B, D, F), in which A, B, D and F are their attributes. Thefollowing SQL query based on these two relations has a nested subquery. Provide an equivalent SQL querywhich does not have any nested subquery.select A, Bfrom rwhere r.B < some (select Bfrom swhere s.D= r.D)