
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
please write your answer under question.
thanks

Transcribed Image Text:Encode and Decode a message
Using Modular 26. Encode and Decode the message using the key "LONG PASSWORD":
USE MULTIPLE ALPHABETS
P:
K: LONG PASSWORD
Use ALL the key characters: LONGPASSWORD
ENCODE
DECODE
P: U S E M U L T T P L E A L P
P:
K:
P+
K:
EBOOXOXEA
m
od
26
C:
C:
K
C-
K:
od
26
P:
Modular Note (Excel Function):
=mod(value.divisor)
H A BET S
=mod(17,26) = 17 => R: corresponds to 17/26= 0 remainder 17 => 17 = 17 mod 26
=mod(43,26) = 17 => R: corresponds to 43/26 = 1 remainder 17 => 17 = 43 mod 26 => 43 = 17 (mod26)
=mod(-9,26) = 17 => R: corresponds to 26-9 = 17
Python Function:
17%26 = 17
43%26 = 17
-9%26 = 17
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
ABCDEFGHIJ K L M N OP Q R 8 I U V W X Y Z

Transcribed Image Text:1
2
3
4
5
S21
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
A B
4
▶
C
D
01
A B C
OA A B C
1B B C D E
2C C D E F
F FG H I
18 S
19 T
J
K
2 3
D
D E
F
G
3D D E F G
H
I
4E E F G
H
I
J
5F F G H
I J
K
6 G
G
H
I
J
K L
7H H I J
K L M
81 I J K L
M N
9J
10 K
11 L
12 M
X✓ fx
=IF(R21="Z","A",CHAR(CODE(R21)+1))
J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL A
Vigenére Cipher
L M N O
M N
4 5 6
E
F
G
G H
I
J
P
O P Q
13 N N O P Q R
140 O P Q
15 P
P Q R
16 Q
17 R
Q R S
R S T
F
G H
H
I
K L M N O P Q R
L M N O
P Q
R S
S
R S T
S
T
20 U
21 V V W X Y
22 W W X Y Z
23 X X Y Z A
Q R
R S
S T
T U V W X Y
7
H
T
U V W X Y
U V W X Y
U V W X Y Z
Z A
J
K
L
K L
L M
24 Y
Y Z A
B C
25 Z Z A B C D
L M N
M
N O
N O P
O P Q
T
U V
U
V W
U V W X
U V W X Y
Z
8
I
I
J
K
S T
T
U
Z
Z A
A B
B C
A B C D
B C D
A
B
C
D
E
E F
D E F
G
E F G H
Vigenére Example
9
10 11 12 13 14
J
K
L
M N
O
J K L
M N O
K L
M
N
O
P
L M
N O
P Q
M N O
N O
P
O P
Q
P Q R
Q R
S
R S
T
S T
T U
W X
X Y
Y Z
Z A
A
B
U V W X Y
V W
X
Y
Z
B C
C
D
D
E
F
G
E
F
G
H
H I
I J
U
V W
V W X
Y
Z
A
B
C
D
E
F
G
P Q
Q
R
H
I
R
S
S
T
T
U
U V
+
Z
A
B
C
D
E
F
G
H
I
J
J
K
K L
A
B
C
D
E
F
G
H
I
J
K
R
S
Z
A
15 16 17 18
P
Q R
S
X Y
Y
Z
P
Q
R
G
H
S
T
I
J
B
C
C D
D
E
K
L
E F
F G
T
U
V
U V W X Y
V W X
Y
Z
W X
Y
Z
A
A
B
H
I
Q R
R
S
S
T
J
K
T
U
Z
A
B
C
D
E
F
G
H
U
V
I
J
A
B
C
D
E
F
G
W X Y
Z
A
B
H
I
J
K
S
T
K
L
L M
U
L
M
M N O
B
C
V W X
W X
Y
D
E
F
G
H
19
T
T
U
V
M
N
N O
C
D
I
J
J K
L M
N O
P Q
M N O P Q R
E
F
K
L
L M
G
H
I
20
U
P Q
U
V
W X
:
Z
A
B
C
D
E
F
G
H
I
J
N O
O
M
N
P Q
R
21 22 23 24 25
V W X
Y Z
V W X
W X
Y
Y
Z
R S
S
T
Y
Z
◄
A
B
C
D
E
F
G
H
I
J
K
Z
A
B
C
D
E
R
S
F
G
T
U
H
I
A
B
G
H
S
T
Y
Z
A
C
D
D
E
E F
F
G
I
J
U
V
B
C
K
L M N O P
L M N O P Q
N O P Q R
O
P Q R S
P Q R S T
H
I
Z
A
B
C
D
E
F
G
H
J
K L M
K
L M N
L M N O
P Q R S T
U
I
J
J
K
K L
T U
V
U V W
V W X
W X Y
1
2
3
G7
4
5
6
7
8
9
10
A
B
с D
E
P:
S
F
N
D
P:
18 4
13
3
K:
Z E
V 0
K:
25 4
P+K: 43 8
mod26 17
C: R
C:
K:
C-K:
11 mod26
12 P:
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
4
0
A
0
▶
8
I
17 8
25 4
-8
4
18
4
S
E
21 14
34
8
I
8
F
L
11
N
0
Z
13 25
17 24 25
17 24 25
R Y Z
17 24 25
13
25
11
0
X
21
14
-13 3
13 3
N
D
fx
=@INDEX($A$15:$Z$15,1,G$6+1)
G H I J K L MNOP QRST U V W X Y Z
A W Y ER SGUNSAND MON E Y
22 24 4 17 18 6 20 13 18 0 13 3 12 14 13 4 24
E V ONZE VON ZEV ONZE V
4 21 14 13 25 4 21 14 13 25 4 21 14 13 25 4 21
26 45 18 30 43 10 41 27 31 25 17 24 26 27 38 8 45
25 17 24 0 1 12 8 19
ZRYA B MI T
25 17 24 0 1 12 8 19
13 25 4 21
19 18 4 17 10 15 1
0
A
T
19
5
SERK PB F
18 4 17 10 15 1 5
0
4
21
14 13 25
4
21 14 13
25 4 21 14
-4 -2
4 -9 -8
-6 -13 -8
13 3 -14 -12 -13 4 -2
0
0 13 3 12 14 13 4 24
4
17
18
20 13 18
R
S
U
N S
A ND M 0 N E Y
11
L
0 22 24
A
W
Y
E
Vigenére Example
6
6
G
1
2
3
4
5
6
7
8
9
10
11 12 13 14
15
16 17 18 19
F G H | J K L M N O P Q R S
B
с D E
T
-25 -24 -23 -22 -21 -20 -19 -18 -17 -16 -15 -14 -13 -12 -11 -10 -9 -8 -7
20
U
-6
21
V
-5
22 23 24 25
W X Y Z
-4 -3 -2 -1
AA
ENCODE
DECODE
AB
Expert Solution

arrow_forward
Step 1
Given that,
Plain text is: USE MULTIPLE ALPHABETS
Key is: LONG PASSWORD
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

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
- MYSQL 3-Display the last name, job, department number, and department name for all employees work inToronto. (Employees,Departments,Locations)4-Display employees' last name and employee number along with their manager's last name and manager number.Label the columns Employee, Emp#, Manager Mgr#, respectively.5-Display the last name, department number,department name and region name for all employees who work inEurope.6-What is the name of the manager for employee WINSTON (first name).arrow_forwardOutline the box model.arrow_forwardPlease provide a name and a brief explanation for each of the four page replacement methods. What differences and similarities can you find between them?arrow_forward
- To test weather a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. Or, when you're using mySQL Workbench, you can right-click on a table name in the navigator window and select the Select Rows - Limit 1000 command to display the data for the table in a Result tab. To refresh the data in this tab after modifying the table data, click the Refresh button in the toolbar at the top of the tab.1. Write an INSERT statement that adds this row to the Terms table: terms_id: 6 terms_description: Net due 120 days terms_due_days: 120 Use MySQL Workbench to review the column definitions for the Terms table, an dinclude a column list with the required columns in the insert statement. 2. Write an UPDATE statement that modifies the row you just added to the Terms table. This statement should change the terms_description column to "Net due…arrow_forwardWhat does an asterisk (*) in the SELECT clause of a SELECT statement represent?arrow_forwardIn the following table, insert the proper chmod value or resulting permission. chmod Value Resulting Permission 700 rwx --- --- r-- --- --- 200 rw- --- --- --x --- --- 000 500arrow_forward
- 5. In Customers, display cust_state followed by cust_state in lowercase, with the alias shown below. Display in alphabetical order by cust_state. CUST_STATE AZ IL IN MI OH 5 rows returned in 0.00 seconds Download mi Lowercasearrow_forwardOn the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate. Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.arrow_forwardcreate a form with two input field name and password use onfocus to focus to tell which should be entered to that field you can use alertarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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