Answer:
Thank you! can i have brainliest please?
Explanation:
3.4 lesson practice quiz edhesive
:
Write a program to check if user inputs "yellow"
Answer:
In Python:
col = input("Enter Color: ")
if col == "yellow":
print("True")
else:
print("False")
Explanation:
This prompts the user for color
col = input("Enter Color: ")
This checks if color is yellow
if col == "yellow":
If true, this prints true
print("True")
If otherwise, this prints false
else:
print("False")
For the view of Exercise 4.18, explain why the database system would not allow a tuple to be inserted into the database through this view.
For reference
For the database of Figure 4.12, write a query to find the ID of each employee with no manager. Note that an employee may simply have no manager listed or may have a null manager. Write your query using an outer join and then write it again using no outer join at all.
OUTER JOIN
select e.ID from employee e left outer join manages m on e.ID = m.ID
where m.manager_id is null;
NO OUTER
select e.ID from employee e where e.ID not in (select m.ID from manages m) or e.ID in (select m.ID from manages m where m.manager_id is null);
