Specificationl =Assignment-1The purpose of this assignment is to familiarize with Relational algebra and Relational calculus queries on Company database using WinRDBI+ For cach of the following...

Please see files for ALL instructions. The files will include the specifications of the assingment, the sample output (how everything should look after doing the work), and finally a zip file with the application you need to do the assingment


Specificationl = Assignment-1 The purpose of this assignment is to familiarize with Relational algebra and Relational calculus queries on Company database using WinRDBI + For cach of the following two queries. create a relational algebra query file © List the firstname and lastname of cach employee who has at least one work assignment with the project "ProductY". -- [filename: q1.alg] o List the firstname and lastname of employee(s) with the lowest salary value. -- [filename: q2.alg] + Create a domain relational caleulus query file for the following query: © List the last names of managers of departments that employ at least one employee with'SPOUSE' as a dependent. -- [filename: q3.drc] + Create a tuple relational caleulus query file for the following query: o List the firstname and lastname of employee(s) who has the highest hours on works_on. - [filenames: q4.trc] Use WinRDBI to test the queries. Upload all four files along with the following declaration through Canvas. Note that queries can include only the data values from the specification. Queries that include data values outside the specification will not receive any score. Name: Panther-ID: X X X -. (last 4 digits) Course: COP 4718 Assignments: 1 Due: Wed, Feb 8, 2623 Sample output for Asg1 queries = To receive the correct score for your relational algebra/calculus queries, - the query must run in winRDBI - the result of the query must be correct (as listed here) - importantly, the semantics of the query must satisfy the specification - the query must be readable with suitable comments - the query should NOT use any data values that is not listed in the specification. Each temporary table names must begin with a lowercase alphabet Each domain/tuple variable must begin with an uppercase alphabet [RE [ERIE 3 % List the firstname and lastname of each employee who has at least one work assignment with the project 3 LR ht 3 FE JUSS 3 3 LY “Smith” 3 catty ry 3 EES [Grae 3 q2.alg - 25 List the firstname and lastname of employee(s) with the lowest salary value. [Ent Fy JETS AEE ROTH RECS Coat es ELT RE g3.drc - 25 List the last names of managers of departments that employ at least one employee with 'SPOUSE’ as a dependent. [emis MgriName Ce 3 3 3 3 3 3 3 3 3 KR 3 FIR] List the firstname and lastname of employee(s) who has the highest hours on works_on. [emis fname EE EC