Turn-In Instructions Using the spreadsheet software of your choice (Excel, Googl

Turn-In Instructions
Using the spreadsheet software of your choice (Excel, Googl

Turn-In Instructions
Using the spreadsheet software of your choice (Excel, Google Sheets, etc) please write all inputs and outputs with column labels. When you are ready to submit, please upload your tables to Canvas.
Due Date
The submission deadline for this homework
HW 3 – Boolean algebra
Option 1
Homework Set 3: 3.1-3.12
Option 2
HW 3 – Truth Tables
Suppose a city council has three members, Adams, Baker, and Cook. Whenever they vote on an ordinance, the ordinance passes if a simple majority is in favor. Design a digital system to model the votes where 0 = No, 1 = Yes. Let output P denote whether the ordinance passes or fails; 0 = Fail, 1 = Pass. Construct the truth table with inputs A, B, C, and output P.
2. A bank vault is secured by a lock that bank officials can open according to the following protocol:
A. During business hours: the bank president (P) or both of the vice presidents (VP1, VP2).
B. Off hours: the president and vice president.
Design a digital system that will UNLOCK the lock when the appropriate combination of officials enter ID codes. Assume that logic 1 indicates that the respective officer has entered the proper code and that logic 0 means that the proper code was not entered. The variable OPEN=1 indicates that the bank is open for business. Write the truth table for the lock. Let the inputs be O = bank is open, P = president, VP1 = first vice president, VP2 = second vice president. Let the output be U = unlock.