questions, you should for the fingerie b relallers according to relational schemas hat are depleted be Cater (cotid integer, namestring) Bestcotid integer, item integer, rating char(2) (minteger, description: string, seller string) Produce the cuids and names of customers who buy the item with description "Memento movie from seller "Hollywood Video 15 Product rating of items and names of customers who buy the item with rating "A". Employer (empNo, Name, IName, address, DOB, sex, position, deptNo) Department (deptNo, deptName,mgrEmpNo) Project (proyNo, projName, deptNo) Wirkson (empNo, projNo date Worked, hours Worked) A 15) Produce a list of names and position of all employees who work for the HR department. b. 151 Produce a list of names of all employees who work on SCCS project.
2. Relational Algebra 120 points For following questions, you should for the fingerie b relallers according to relational schemas hat are depleted be Cater (cotid integer, namestring) Bestcotid integer, item integer, rating char(2) (minteger, description: string, seller string) Produce the cuids and names of customers who buy the item with description "Memento movie from seller "Hollywood Video 15 Product rating of items and names of customers who buy the item with rating "A". Employer (empNo, Name, IName, address, DOB, sex, position, deptNo) Department (deptNo, deptName,mgrEmpNo) Project (proyNo, projName, deptNo) Wirkson (empNo, projNo date Worked, hours Worked) A 15) Produce a list of names and position of all employees who work for the HR department. b. 151 Produce a list of names of all employees who work on SCCS project.
2. Relational Algebra 120 points For following 2. Relational Algebra 120 points For following questions, you should for the fingerie b relallers according to relationa
-
- Posts: 43759
- Joined: Sat Aug 07, 2021 7:38 am