Question: solve this question using the schema I provided EMPLOYEE begin{tabular}{|l|c|l|c|c|c|c|c|c|c|} hline Fname & Minit & Lname & Ssn & Bdate & Address & Sex &

solve this question using the schema I provided

$solve this question using the schema I provided EMPLOYEE \begin{tabular}{|l|c|l|c|c|c|c|c|c|c|} \hline Fname$

EMPLOYEE \begin{tabular}{|l|c|l|c|c|c|c|c|c|c|} \hline Fname & Minit & Lname & Ssn & Bdate & Address & Sex & Salary & Super_ssn & Dno \\ \hline John & B & Smith & 123456789 & 19650109 & 731 Fondren, Houston, TX & M & 30000 & 333445555 & 5 \\ \hline Franklin & T & Wong & 333445555 & 19551208 & 638 Voss, Houston, TX & M & 40000 & 888665555 & 5 \\ \hline Alicia & J & Zelaya & 999887777 & 19680119 & 3321 Castle, Spring, TX & F & 25000 & 987654321 & 4 \\ \hline Jennifer & S & Wallace & 987654321 & 19410620 & 291 Berry, Bellaire, TX & F & 43000 & 888665555 & 4 \\ \hline Ramesh & K & Narayan & 666884444 & 19620915 & 975 Fire Oak, Humble, TX & M & 38000 & 333445555 & 5 \\ \hline Joyce & A & English & 453453453 & 19720731 & 5631 Rice, Houston, TX & F & 25000 & 333445555 & 5 \\ \hline Ahmad & V & Jabbar & 987987987 & 19690329 & 980 Dallas, Houston, TX & M & 25000 & 987654321 & 4 \\ \hline James & E & Borg & 888665555 & 19371110 & 450 Stone, Houston, TX & M & 55000 & NULL & 1 \\ \hline \end{tabular} DEPARTMENT \begin{tabular}{|l|c|c|c|} \hline \multicolumn{1}{|c|}{ Dname } & Dnumber & Mgr_ssn & Mgr_start_date \\ \hline Research & 5 & 333445555 & 19880522 \\ \hline Administration & 4 & 987654321 & 19950101 \\ \hline Headquarters & 1 & 888665555 & 19810619 \\ \hline \end{tabular} DEPT_LOCATIONS \begin{tabular}{|c|l|} \hline Dnumber & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Stafford \\ \hline 5 & Bellaire \\ \hline 5 & Sugarland \\ \hline 5 & Houston \\ \hline \end{tabular} WORKS_ON \begin{tabular}{|c|c|c|} \hline Essn & Pno & Hours \\ \hline 123456789 & 1 & 32.5 \\ \hline 123456789 & 2 & 7.5 \\ \hline 666884444 & 3 & 40.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 453453453 & 2 & 20.0 \\ \hline 333445555 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 10.0 \\ \hline 999887777 & 30 & 30.0 \\ \hline 999887777 & 10 & 10.0 \\ \hline 987987987 & 10 & 35.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 987654321 & 20 & 15.0 \\ \hline 888665555 & 20 & NULL \\ \hline \end{tabular} PROJECT \begin{tabular}{|l|c|l|c|} \hline \multicolumn{1}{|c|}{ Pname } & Pnumber & Plocation & Dnum \\ \hline ProductX & 1 & Bellaire & 5 \\ \hline ProductY & 2 & Sugarland & 5 \\ \hline ProductZ & 3 & Houston & 5 \\ \hline Computerization & 10 & Stafford & 4 \\ \hline Reorganization & 20 & Houston & 1 \\ \hline Newbenefits & 30 & Stafford & 4 \\ \hline \end{tabular} DEPENDENT \begin{tabular}{|c|l|c|c|l|} \hline \multicolumn{1}{|c|}{ Essn } & Dependent name & Sex & Bdate & Relationship \\ \hline 333445555 & Alice & F & 19860405 & Daughter \\ \hline 333445555 & Theodore & M & 19831025 & Son \\ \hline 333445555 & Joy & F & 19580503 & Spouse \\ \hline 987654321 & Abner & M & 19420228 & Spouse \\ \hline 123456789 & Michael & M & 19880104 & Son \\ \hline 123456789 & Alice & F & 19881230 & Daughter \\ \hline 123456789 & Elizabeth & F & 19670505 & Spouse \\ \hline \end{tabular} 2) Consider the relational database state COMPANY attached to this exam. Suppose that all the relations were created by (and hence are owned by) user X, who wants to grant the following privileges to user accounts A, B, C, D, and E: 2.1 Account A can retrieve or modify DEPENDENT and can grant any of these privileges to other users. (1 points) 2.2 Account C can retrieve or modify PROJECT but can only retrieve the Fname, Minit, Lname, Salary attributes of female employees. ( 2 points) 2.3 Account D can retrieve any attribute of EMPLOYEE or DEPENDENT and can modify DEPENDENT. (1.5 points) 2.4 Account E can retrieve any attribute of EMPLOYEE but only for female employee whose salary is greater than 30000 . ( 2 points) Vrite SQL statements to grant these privileges. Use views where appropriate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

plz solve all of them or let someone else do them 1. Prove by example the following relational algebra property: (5 points) I((R))=(R) as long as contains the attributes in You may use the COMPANY...

7. Produce a relation showing the employee first name, name of his/her dependent, and relationship to the employee. (0.75 point) 8. Find the first and last name of all employees whose salary is above...

Check below all the correct statements about the COMPANY database (schema and state) insert into DEPENDENT values ('453453453', 'John', 'M', '12-DEC-60', 'Spouce') violates a foreign key constraint...

1. Prove by example the following relational algebra property: ( (R))= (R) as long as contains the attributes in You may use the COMPANY schema or another other schemas of your choice. Figure 5.6 One...

I have to build the attached relational database with SQL. Inorder to write the queries I need I need to figure out the primaryAND foreign and UNIQUE keys for each table which I am strugglingwith....

acording to the company schema pliz i want a solution coming from the (company scheme) please do not give a solution in the app already because I already seen them GEIT 3341: Database I 5\% Bonus...

Provide resulting relation (table with tuples) for each query. Using these tables. The table in a. is already completed as an example a. Retrieve first name, last name, and date of birth of all...

Database HW can you solve all questions if you can't, please leave it for someone else to solve them all draw if it's needed 1. Prove by example the following relational algebra property: (5 points)...

database draw if it's needed plz solve q 1 according to the company schema GEIT 3341: Database I 5\% Bonus Assignment Due date: Thursday December 22, 2022 1. Prove by example the following relational...

Figure 3.6 One possible database state for the COMPANY relational database schema. EMPLOYEE \begin{tabular}{|l|c|l|c|c|c|c|l|c|c|} \hline Fname & Minit & Lname & Ssn & Bdate & Address & Sex & Salary...

Provide the missing data in the following table: Division Consulting Fab IT Sales .. Operating income. Average operating assets.. $800,000 $ 72,000 $40,000 $130,000 4% 8% Margin... Turnover.. Return...

10. The balance of an investment fund at the beginning of the year and at the end of the year is $20,000 and $26,000, respectively. A withdrawal of $2,000 was madeat the end of 5 months. A deposit of...

Cullumber Company incurs a cost of $ 3 6 per unit, of which $ 2 1 is variable, to make a product that normally sells for $ 5 7 . A foreign wholesaler offers to buy 5 , 9 0 0 units at 5 3 1 each....

Zarsons Netballs is a manufacturer of high-quality basketballs and volleyballs. Zarson used the simple costing system with two direct costs and a single indirect cost pool with the machine hours as...

3 Which trade-offs must be made when setting up a global SCM network for the apparel industry? Also discuss the trade-offs regarding sourcing countries versus quality. The enormous success of...

List possible CSR concerns in the supply chain and the possible impact on the focal firm making and selling the end product if they go wrong and if they go right

2 Why is time-to-market so important in the apparel industry? How does it impact supply chain processes? The enormous success of vertical retailers like H&M, Zara, Gap and Next in the apparel...