Question: SQL This exercise is designed to help you think out of the box on the use of database programming for solving problems. You are given
This exercise is designed to help you think out of the box on the use of database programming for solving problems. You are given the crypt-arithmetic puzzle: SEND +MORE MONEY The goal of the puzzle is to substitute numbers (from zero to nine) for letters, so that the addition works out. There are some constraints your solution should respect: 1. The same number should be used for a given letter, throughout. For example, if you guess, "5" for the letter E, then E should get the value "5" at all the places it occurs. 2. Different letters should get different numbers, e.g., you cannot assign "4" to both 3. None of the numbers SEND, MORE, or MONEY have any leading zeroes, i.e. E and to M. they do not begin with a sequence of zeroes. Explain how you will solve this puzzle by creating database tables and writing a query. Q3.1. (5 points) The schema of the tables you use. Q3.2. (10 points) Your SQL query 5 points) The solution you get for the puzzle when you use an SQL interpreter and RDBMS to solve this puzzle. Copy pastthe output you get
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
