
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Open Excel and Copy the Worksheet
Open MS Excel and copy the spreadsheet shown in Figure 1.
Figure 1 Template for the XOR Spreadsheet

Transcribed Image Text:Figure 1
A
1 given character
2
ASCII equivalent
3
4
5
6
7
XOR result
8
XOR binary
9 cipher character
10
given key
ASCII equivalent
BHN
72
N
Template for the XOR Spreadsheet
C D E F
G
H
122
0 1 0
0
1 1
0
1
1
1
I
0
0
J K L
0
1
0
0
The above worksheet displays a given character to be encoded the ASCII
![In cell D7, type and enter the following formula, which performs an XOR
operation on the binary digits located within cells D2 and D5.
=NOT(OR(AND(D2,
D5), NOT(OR(D2,D5))))
If available, you can use the MS Excel intrinsic (built-in) XOR() function that
performs the same operation as the above formula.
Perform a " drag-and-fill " worksheet row seven and similarly formulate the
cells across the cell range E7:K7.
Notice that the formula either returns TRUE or FALSE for the cells in the range
D7:K7. You can double-click between the column labels, at the top of your
worksheet, to increase the column width to properly display the result.
You will now convert a TRUE to a "1" and a FALSE to a "0".
To accomplish this, type and enter the following formula in cell D8.
=IF(D7=TRUE,1,0)
Perform a " drag-and-fill" worksheet row eight and similarly formulate the cells
across the cell range E8:K8.
Use the Window's Calculator program, in the [ Programmer ] view, to convert
the 8-bit number in row eight to a decimal number.
Then, click cell B9 and type the following formula in this cell, replacing the word
"decimal" with the number that you just computed.
=CHAR(decimal)
You have just encoded the given character, using the given key, of the lower
case letter "z", with XOR encryption.](https://content.bartleby.com/qna-images/question/17f646ba-b993-4044-9bb2-45d012c56776/1701ba29-e456-47ed-97f2-8037a00eabce/fpfcfjd_thumbnail.png)
Transcribed Image Text:In cell D7, type and enter the following formula, which performs an XOR
operation on the binary digits located within cells D2 and D5.
=NOT(OR(AND(D2,
D5), NOT(OR(D2,D5))))
If available, you can use the MS Excel intrinsic (built-in) XOR() function that
performs the same operation as the above formula.
Perform a " drag-and-fill " worksheet row seven and similarly formulate the
cells across the cell range E7:K7.
Notice that the formula either returns TRUE or FALSE for the cells in the range
D7:K7. You can double-click between the column labels, at the top of your
worksheet, to increase the column width to properly display the result.
You will now convert a TRUE to a "1" and a FALSE to a "0".
To accomplish this, type and enter the following formula in cell D8.
=IF(D7=TRUE,1,0)
Perform a " drag-and-fill" worksheet row eight and similarly formulate the cells
across the cell range E8:K8.
Use the Window's Calculator program, in the [ Programmer ] view, to convert
the 8-bit number in row eight to a decimal number.
Then, click cell B9 and type the following formula in this cell, replacing the word
"decimal" with the number that you just computed.
=CHAR(decimal)
You have just encoded the given character, using the given key, of the lower
case letter "z", with XOR encryption.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps with 2 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- 12.25 The following binary counter increments on each rising clock edge unless the exter- nal clear (CIrN) control input is low. (a) Implement a modulo 12 counter using this binary counter assuming the Clr con- trol input is a synchronous control input. (b) Repeat part (a) assuming Clr is an asynchronous control input. CIrN dCir 4-Bit Counter CLK 03020100arrow_forwardDesign databases only contain data about the spatial data of the design. True Falsearrow_forwardExplain the concept of data binding frameworks and libraries in modern web development, and provide examples of popular ones.arrow_forward
- Explain the concept of data binding in the context of cross-platform mobile app development and its role in code reusability.arrow_forwardHistograms are used for what kind of data? Group of answer choices Categorical data Numeric data Paired data Relational dataarrow_forwardT. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.arrow_forward
- 3. What is a data element? 4. What is the purpose of a decision table?arrow_forwardWhat is the purpose of leaving a data item out of a data model?arrow_forwardWhen formulating a linear programming problem on a spreadsheet, data cells will show the levels of activities for the decisions being made.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education