Answer:
Below is the required code:
Explanation:
SELECT Product_Finish AS "Desk Finish",
avg(Standard_Price) AS "Average Price"
FROM Product_T
WHERE "Average Price">200
ORDER BY "Average Price" DESC;
Bookstore and BookSearch are the two entities for the given scenario.
Explanation:
- For the given Book.com virtual store, there can be two entities like Bookstore and BookSearch.
- Bookstore can have all the details of the books in the virtual store. hence the attributes can be
- Bookstore attributes: bookname, Authorname, Publisher, Publishedyear, Agegroup, category.
- BookSearch entity can be used to search the books in the virtual store.
- Booksearch attributes: bookname, category, bookid, authorname.
Answer:
C. Rulers indicate the margins, tabs, and indents in a presentation slide.
Explanation:
The status bar appears at the bottom of the page, and it never displays options the options to style the slides. And the toolbar never displays the thumbnails of the slides, as well as the document area never provides a list of the commands for creating, formatting or editing the presentations. However, the rules do indicates the margins, tabs, and indents in a presentation slide. Hence C. is the right option.
Answer:
- def getCharacterForward(char, key):
- charList = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
-
- if(len(char) > 1):
- return None
- elif(not isinstance(key, int)):
- return -1
- else:
- index = charList.find(char)
- if(index + key <= 25):
- return charList[index + key]
- else:
- return charList[(index + key)% 26]
-
- print(getCharacterForward("C", 4))
- print(getCharacterForward("X", 4))
Explanation:
Firstly, define a charList that includes all uppercase alphabets (Line 2). We presume this program will only handle uppercase characters.
Follow the question requirement and define necessary input validation such as checking if the char is a single character (Line 4). We can do the validation by checking if the length of the char is more than 1, if so, this is not a single character and should return None (Line 5). Next, validate the key by using isinstance function to see if this is an integer. If this is not an integer return -1 (Line 6 - 7).
Otherwise, the program will proceed to find the index of char in the charList using find method (Line 9). Next, we can add the key to index and use the result value to get forwarded character from the charList and return it as output (Line 11).
However, we need to deal a situation that the char is found at close end of the charList and the forward key steps will be out of range of alphabet list. For example the char is X and the key is 4, the four steps forward will result in out of range error. To handle this situation, we can move the last two forward steps from the starting point of the charList. So X move forward 4 will become B. We can implement this logic by having index + key modulus by 26 (Line 13).
We can test the function will passing two sample set of arguments (Line 15 - 16) and we shall get the output as follows:
G
B
