Question

HW3 SQL-embedd Python for Authorization Consider a database Company where at least the following two tables are defined. Their table schemas are: Employee (eID INT, name TEXT, salary DOUBLE, dID TEXT, role TEXT) Manager (eID INT, dID TEXT) Q1) Create the database with at least 10 employees and 2 managers are populated. Important: your name should be in the employee table. If not, you do not earn the credit! Submission: screenshot showing the output of the following SQLS Select * from employee; Select * from manager; If your name is not in the table(s), no credit! Q2) Write a Python code that can do the following: 1) Take an employee ID from user 2) Display the output of the SQL, select * from employee; Submission: screenshot Q3 - hard but essential!) Improve the Python code above that can do the following: 1) Take an employee ID from the user. Let it be idEntered. 2) Get the departmentID for the given employeeID, idEntered. Let it be deptFound. 3) Check if idEntered is in the table manager 4) If yes, then execute: query = ("select * from employee where dID = %s;"). Note that since a variable deptFound is included in SQL, if it should be included, then use %s in SQL. And then declare a variable, data_tuple = (deptFound,) in a separate line. Finally, execute the query cursor.execute(query, data_tuple). 5) if No, simply execute the SQL: select * from employee where eid = %s; do the similarly way for idEntered as above Note that the exemplified SQLs above are subject to be fixed if any syntax error occurs.

          HW3 SQL-embedd Python for Authorization
Consider a database Company where at least the following two tables are defined. Their table schemas
are:
Employee (eID INT, name TEXT, salary DOUBLE, dID TEXT, role TEXT)
Manager (eID INT, dID TEXT)
Q1) Create the database with at least 10 employees and 2 managers are populated. Important: your name
should be in the employee table. If not, you do not earn the credit!
Submission: screenshot showing the output of the following SQLS
Select * from employee;
Select * from manager;
If your name is not in the table(s), no credit!
Q2) Write a Python code that can do the following:
1) Take an employee ID from user
2) Display the output of the SQL, select * from employee;
Submission: screenshot
Q3 - hard but essential!) Improve the Python code above that can do the following:
1) Take an employee ID from the user. Let it be idEntered.
2) Get the departmentID for the given employeeID, idEntered. Let it be deptFound.
3) Check if idEntered is in the table manager
4) If yes, then execute: query = ("select * from employee where dID = %s;"). Note that since a
variable deptFound is included in SQL, if it should be included, then use %s in SQL. And then declare a
variable, data_tuple = (deptFound,) in a separate line. Finally, execute the query
cursor.execute(query, data_tuple).
5) if No, simply execute the SQL: select * from employee where eid = %s; do the similarly way for
idEntered as above
Note that the exemplified SQLs above are subject to be fixed if any syntax error occurs.

HW3 SQL-embedd Python for Authorization
Consider a database Company where at least the following two tables are defined. Their table schemas
are:
Employee (eID INT, name TEXT, salary DOUBLE, dID TEXT, role TEXT)
Manager (eID INT, dID TEXT)
Q1) Create the database with at least 10 employees and 2 managers are populated. Important: your name
should be in the employee table. If not, you do not earn the credit!
Submission: screenshot showing the output of the following SQLS
Select * from employee;
Select * from manager;
If your name is not in the table(s), no credit!
Q2) Write a Python code that can do the following:
1) Take an employee ID from user
2) Display the output of the SQL, select * from employee;
Submission: screenshot
Q3 - hard but essential!) Improve the Python code above that can do the following:
1) Take an employee ID from the user. Let it be idEntered.
2) Get the departmentID for the given employeeID, idEntered. Let it be deptFound.
3) Check if idEntered is in the table manager
4) If yes, then execute: query = ("select * from employee where dID = %s;"). Note that since a
variable deptFound is included in SQL, if it should be included, then use %s in SQL. And then declare a
variable, datatuple = (deptFound,) in a separate line. Finally, execute the query
cursor.execute(query, datatuple).
5) if No, simply execute the SQL: select * from employee where eid = %s; do the similarly way for
idEntered as above
Note that the exemplified SQLs above are subject to be fixed if any syntax error occurs.

Added by Rosa H.

Question

Please give Ace some feedback