a. Which one of the following statements regarding a database index is true?

Group of answer choices

they help improve the security of databases

they reduce the number redundnt entries in a database

they are a way of changing the order of the records in a table

they are required for HIPAA compliance

All of the above

b. Which one of the following represent how Microsoft PowerPoint can be best used:

Group of answer choices

The best use of PowerPoint is to create slides containing the text of a presentation which the speaker can simply read from directly from the screen.

It is best to use sound effects and rapid animation as much as possible to stimulate the audience’s interest in the slides.

PowerPoint is an ideal way to present multimedia support for a presentation, such as audio, video, graphics, and photographs, which are not easily described verbally..

To be fully effective, the screen should be placed in the center of a dark room with the speaker preferably standing out of sight of the audience when speaking so as not to distract the audience from the slides.

A and D.

c. Which of the following database field types would be most appropriate for holding a lengthy written transcript of a telephone conversation?

Group of answer choices

Number (Value or numeric)

Text (Character)

Yes/No (Logical)

Date

Memo

Extracts of the Statement of Comprehensive Income for the year ended 31 December 2018 and
the Statement of Financial Position as at 31 December 2018 are given below for two companies
viz. Amazon Limited and Gibson

Extract of the Statement of Comprehensive Income for the year ended 31 December 2018:

Extract of the Statement of Financial Position as at 31 December 2018:

Additional Information:                                                                                                           

• Inventories as at 31 December 2017 are as follows:                                                

Amazon Limited          R800 000                                                                                           

Gibson Limited            R230 000                                                                               

• All sales and purchases of inventories are on credit.

Required:

Compare the performance of Amazon Limited and Gibson Limited (both in same industry) with regard to the following ratios and in each case state your observations:

4.1.      The ability of each company to repay its short term debts without relying on sale of its inventories.                                                                                                                                    (6)

4.2.      The return earned by shareholders on their investment.                                                       (6)

4.3.      The operational effectiveness of each company before considering interest income, interest expense and income tax.                                                                                                          (6)

4.4.      The effectiveness with which the goods for sale have been managed.                                (6)

4.5.      An evaluation of each company’s performance with regard to the management of its trade creditors.

1. A donor, Jill Brown, puts an entry into her last will and testament to leave Miss University in Mississippi $15,000,000 on October 10, 2018 to be used to pay for a new classroom building named after her late husband, Billy Brown. The university was immediately informed of this bequest by the donor's attorney on October 21, 2018. The donor dies on January 2, 2019. The university receives the check for the bequest on May 4, 2019. The classroom building planning and construction began December 3, 2019 and was placed into operation in January 2, 2021. When should the $15,000,000 bequest be recognized by Miss University?

A. October 21, 2018.

B. January 2, 2019.

C. May 4, 2019.

D. January 2, 2021.

2. A donor pledges $100,000 on December 15, 2018 to be paid in one amount to Columbia University. No donor restrictions were applied. The contribution is to be received four years from the pledge. If the present value of $1 at 3 percent is 0.8885, the journal entry to record the pledge would include: A. Debiting contributions receivable, $88,850. B. Crediting contributions—with donor restrictions, $100,000. C. Crediting discount of pledges, $11,150. D. Debiting net assets—without donor restrictions, $100,000 3. Cathleen Hallmark, president of the save-the-professor foundation, a non-for-profit, spends 80 percent of her time on presidential and board-related duties, which half of that time is also spent fundraising. She spends the remaining 20 percent of her time working on mission-oriented activities. On the statement of activities, Cathleen Hallmark's salary and benefits:

A. Should all be recognized as management and general expenses.

B. Should be subdivided as half in fundraising and half in management and general expenses.

C. Should be subdivided as 20 percent in program expenses, 40 percent in management and general, with the remainder in fundraising expenses.

D. Should never be allocated to program expenses.

3. Cathleen Hallmark, president of the save-the-professor foundation, a non-for-profit, spends 80 percent

of her time on presidential and board-related duties, which half of that time is also spent fundraising. She

spends the remaining 20 percent of her time working on mission-oriented activities. On the statement of

activities, Cathleen Hallmark's salary and benefits:

A. Should all be recognized as management and general expenses.

B. Should be subdivided as half in fundraising and half in management and general expenses.

C. Should be subdivided as 20 percent in program expenses, 40 percent in management and general, with

the remainder in fundraising expenses.

D. Should never be allocated to program expenses.

Your task in this exercise is to write a function called get_playlist_tracks(database_filename, which_playlist), which formulates a SELECT statement that returns track name, album title, genre name, artist name and track composer for all tracks in the database which are associated with a given playlist. This statement requires several nested INNER JOINs to pull together data from the "tracks", "albums", "genres", "artists", and "playlists" table. The default ordering of tracks should be used. The result of the function is a list of database records. The parameter which_playlist specifies a playlist in the database. You first have to check if the playlist is contained in the "playlists" table, if not an error message as indicated in the examples has to be printed and an empty list has to be returned.

Don't forget to close the database connection after you have finished accessing it!

For example:

database_filename = 'chinook.db'
which_playlist = 'On-The-Go 1'
query_result = get_playlist(database_filename, which_playlist)

print(f"Playlist '{which_playlist}'")
for count, database_record in enumerate(query_result):
   print(f"{count:<2} Track Name: {database_record[0]}")
   print(f"   Album Title: {database_record[1]}")
   print(f"   Genre: {database_record[2]}")
   print(f"   Artist: {database_record[3]}")
   print(f"   Composer: {database_record[4]}")

Playlist 'On-The-Go 1'
0  Track Name: Now's The Time
   Album Title: The Essential Miles Davis [Disc 1]
   Genre: Jazz
   Artist: Miles Davis
   Composer: Miles Davis

database_filename = 'chinook.db'
which_playlist = 'Independent'
query_result = get_playlist(database_filename, which_playlist )

for database_record in query_result:
   print(database_record)

ERROR: Could not find playlist 'Independent' in database!

------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is my code so far but dones't work. the output shows that there is no such table as track;

import sqlite3

def get_playlist(database_filename, which_playlist):
  
file_in = sqlite3.connect(database_filename)
curser_object = file_in.cursor()
curser_object.execute("""Select T.name, A.Title, G.name, A1.name, T.composer
From track T
Join Album A On A.AlbumId = T.AlbumId
Join Genre G On G.GenreId = T.GenreId
Join Artist A1
On A1.ArtistId = A.ArtistId
Join PlaylistTrack P2
On P2.TrackId = T.TrackId
Join Playlist P
On P.PlaylistId = p2.PlaylistId
Where P.name =?""",(which_playlist,))
  
ViewData = curser_object.fetchall()
DataTableCompAndClient([ViewData])
  
file_in.close()
return ViewData

Case Study
(Hundreds of millions of Instagram, TikTok, YouTuube accounts compromised by data breach) Published on August 18, 2020.
Security researchers have discovered an exposed database online which contains scraped data from the social media profiles of nearly 235m Instagram, TikTok and YouTuube users.
For those unfamiliar with the practice, web scraping is an automated technique used to gather data from websites that is often employed by analytics firms who use it to create large databases of user information. Although the practice is legal, it is strictly prohibited by social media companies as it puts the privacy of their users and their data at risk.
Comparitech's lead researcher Bob Diachenko discovered three identical copies of the exposed database online at the beginning of August. After examining the database, Diachenko and his team learned that it belonged to a company called Deep Social which has shut down its operations.
When the team reached out to the now-defunct company, its request was forwarded to a Hong Kong-based firm called Social Data. While Social Data denied having any connection to Deep Social, the firm did acknowledge the breach and was able to secure the exposed database with a password.

Answer the following question based on case study

Q6. Illustrate the cybersecurity concerns that may affect the businesses in the $1.5 million Click for Vic campaign that was launched on 23 August 2020. Write a thorough description of the descriptive and predictive data analysis importance in cybersecurity field. Cite your sources.
[6 marks + 8 marks + 1 mark for Referencing Style = 15 marks]
Read the Case Studies given carefully to answer the questions corresponding to the case studies.
Q7. While scraping user data from social media sites is not illegal, failing to secure this data after it has been collected poses a serious risk to the affected users as cybercriminals could use the information from the database to target them online. What are your recommendations to the online risk policy makers as you think it is a breach of PII (Personal Identifiable Information). Justify your answer. Explain the need for cybersecurity experts in such a case scenario.

Nomenclatures undergo periodic evaluation and update. Investigate how the Diagnostic and Statistical Manual of Mental Disorders, 5th Edition (DSM-5) impacted coding for hoarding in 2017. As part of your investigation, determine if the DSM-5 and the code set are fully aligned with this code and support your opinion.

In December 2012, the FASB issued a proposed Accounting Standai·ds Update (i.e., an Exposure Draft), Financial Instruments-Credit Losses (Subtopic 825-15) and solicited constituent feedback. Locate this proposed standard.

1. Read the summary section of this proposed standard. What change in accounting does this exposure draft propose?

2. Look for comment letters related to this exposure draft. From fasb.org, navigate to Projects, then Comment Letters. Under "Accounting for Financial Instrnments," locate this topic, then click on the link to view comment letters. Next:

a. Locate a comment letter that looks interesting to you. What company or individual wrote the letter, and what is their perspective in writing this letter (i.e., are they writing from the perspective of a financial statement user, preparer, etc.)?

b. What aspects of the proposed standard does the commenter support?

c. What concerns does the commenter raise regai·ding the proposed standard?

. How would you expect a company (preparer) might react to this proposed standard compared to how a banker (investor) might react? Explain.

Q2. Update the given code 2 to implement the following problem:

• Create a class triangle
• Use dynamic memory allocation to create 10 objects of the class triangle
• Set default height and base of all created objects (triangle) to 5 and 10 respectively using a constructor
• Ask user to change only the height of the 5^th triangle
• Print height and base of all (10) triangles to demonstrate that you did the task correctly
• Deallocate the 5^th object
• Print height and base of all (10) objects of the class triangle to demonstrate that you deallocated the 5^th object correctly

Code 2:

class triangle {

int base;

int height;

/* Write your code here

*/

};

int main(){

/*write your code here

}

A C PROGRAM

*Edit/Update I do not need the file loading script, but I am not against it being included in the answer*

I must read off of an excel file (comma separated) to input five different things for a book, all comma separated, there are 360 books in the file. The book title, author, ISBN number, number of pages, and finally the year it was published. Now some of the ISBN or Pg numbers may be missing and will be read as N/A in the file.

a structure named book is with the following inputs to be used

a. char title[255];

b. char author_name[50];

c. char ISBN[10];

d. int pages;

e. int year_published;

Create a function called print_book ( ) that takes a book as a parameter. The function should neatly print the contents of that book’s structure to the terminal window. Remember: some records might have null parameters, make sure to handle that in your output.

Finally

Create a function called search_title ( ) that takes a book array, the number of books in that book array, and a character string title as parameters. This search function should loop through all of the books in the array in search of a title that matches with the passed character string, printing to the terminal any books that fulfill this (there could be more than 1 match).

A company produces circuit boards used to update outdated computer equipment. The fixed cost is RM 39,000 per month, and variable cost is RM 55 per circuit board. The selling price per unit is p = RM160 – 0.03D.   a) Determine the demand of circuit boards/month. b) Determine the profit or loss   c) Find the volume at which breakeven occurs and the range (domain) of profitable demand.   d) What the range (domain) of profitable demand if the fixed cost are reduced to 10%