Active Record Associations

 

1. Why Associations?

2. types of associations 

3.  how to make efficient use of Active Record associations in your Rails applications

https://guides.rubyonrails.org/association_basics.html

association box diagrams can be done using lucid chart. please include example of association box diagrams

please include examples of association codes in (models) and (routes)

Asymmetric and symmetric encryption

Analyze asymmetric and symmetric encryption.  Evaluate the differences between the two of them and which one that you would determine is the most secure.  You must use a minimum of three scholarly articles to complete the assignment.  The assignment must be properly APA formatted 

500 words needed

Graph Problem

I’m really struggling with this graph problem because the hard part is how to model the maze as a graph.

Please help me solve it in C++ or Python preferably with a known graph algorithm, the expected input and output of this graph problem will be explained below:

One of the attached images explains the graph problem and reads:

Our story so far: In Maze 7, Dastardly Dan had tried to sabotage Jumping Jim’s act by restringing all his trampolines. But Dan’s actions had the opposite effect. The audience was so delighted by Jim’s leaping about trying to reach the goal, that his act became the most popular of the circus. The circus owner decided to commission Dastardly Dan to create another, even harder maze for Jim to solve. Dan added more trampolines, restrung them, and painted large numbers on each to indicate how far Jim will move when he bounces off each trampoline. The painted numbers would allow the audience to study the maze and try to find a solution before Jim did. Dan also added a new rule that Jim had to follow. Certain of the numbers were painted in red and enclosed in circles. When Jim begins his act, he can move only vertically or horizontally through the maze of trampolines; he cannot move diagonally. However, if he lands on a red number in a circle, he must then start moving only diagonally, now he can’t move vertically or horizontally. Jim must continue moving diagonally until he again lands on a red number. He then switches back to moving only vertically or horizontally. And he switches each time he lands on a red number. Here’s an example to show how that works. Jim begins on the 4 at the northwest comer of the maze. From there he might move south four squares to the red 3. Now he must start moving diagonally. He might go three squares northeast to a 4. On the next move he would continue moving diagonally. He could move four squares southeast to a red I (i). That red number would cause him to switch back to moving only horizontally or vertically. Can you find a route that would let Jim land on the trampoline marked GOAL?

Please complete what the upload images request for the input and output of the program.

MATCH statements are the row_num and col_num arguments.

excel independent project 6-5

 

Classic Gardens and Landscapes counts responses to specialty promotions to determine effectiveness. You use SUMIFS and an IFS formula to complete the summary. You also calculate insurance statistics and display full names in one cell.

[Student Learning Outcomes 6.1, 6.2, 6.3, 6.6, 6.7]

File Needed: ClassicGardens-06.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-ClassicGardens-06.xlsx

Skills Covered in This Project

  • Nest MATCH and INDEX functions.
  • Create DSUM formulas.
  • Build an IFS function.
  • Build SUMIFS formulas.
  • Use TEXTJOIN to join labels.
  1. Open the ClassicGardens-06 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
  2. Create a nested INDEX and MATCH function to display the number of responses from a city.
    1. Click the Mailings sheet tab and select and name cells A3:D28 as Responses.
    2. Click the Mailing Stats sheet tab.
    3. Click cell B21 and type Carthage.
    4. Click cell C21, start an INDEX function, and select the first argument list option.
    5. Choose or type the Responses range name for the Array argument.
    6. Click the Row_num box and nest a MATCH function. Select cell B21 for the Lookup_value and cells A3:A28 on the Mailings sheet for the Lookup_array. Click the Match_type argument box and type 0.
    7. Click INDEX in the Formula bar. Click the Column_num box and nest a second MATCH function to look up cell D3 on the Mailings sheet in the lookup array A3:D3.
    8. Click the Match_type box and type 0 (Figure 6-106) and click OK. The result displays as 343.00.MATCH statements are the row_num and col_num arguments.Figure 6-106 Nested MATCH and INDEX functions
    9. Format the results to show zero decimal places.
    10. Type Smyrna in cell B21.
  3. Use DSUM to summarize mailing data.
    1. Select the Mailings sheet and note that number mailed is located in the third column and response data is in the fourth column.
    2. Click the Criteria sheet tab. Select cell B2 and type lan* to select data for the Landscape Design department.
    3. Type law* in cell B5 for the Lawn & Maintenance department.
    4. Type pat* in cell B8 for the Patio & Furniture department.
    5. Click the Mailing Stats sheet tab and select cell B7.
    6. Use DSUM with the range name Responses as the Database argument. Type 3 for the Field argument (# Mailed column), and enter an absolute reference to cells B1:B2 on the Criteria sheet as the Criteria argument.
    7. Copy the formula to cell C7 and edit the Field argument to use the fourth column (# Responses).
    8. Use DSUM in cells B8:C9 to calculate results for the two remaining departments.
  4. Use SUM in cells B10:C10.
  5. Format all values as Comma Style with no decimal places.
  6. Create an IFS function to display a response rating. Note: If your version of Excel does not include the IFS function, build the following nested IF function =IF(C7/B7>=20%,$C$15,IF(C7/B7>=15%,$C$16,IF(C7/B7>=11%,$C$17,$C$18))) to display the rating.
    1. Click cell D7. The response rate and ratings are shown in rows 14:18.
    2. Start an IFS function and select C7 for the Logical_test1 argument. Type / for division and select cell B7. Type >=20% to complete the test.
    3. Click the Value_if_true1 box, select C15, and press F4 (FN+F4) (Figure 6-107).Each logical_test argument has a corresponding value_if_true argument.Figure 6-107 First Logical_test and Value_if_true arguments
    4. Click the Logical_test2 box, select C7, type /, select cell B7, and type >=15%.
    5. Click the Value_if_true2 box, click cell C16, and press F4 (FN+F4).
    6. Complete the third and fourth logical tests and Value_if_true arguments (Figure 6-108).Several arguments are scrolled out of viewFigure 6-108 Completed IFS function arguments
    7. Copy the formula in cell D7 to cells D8:D10.
  7. Use SUMIFS to total insurance claims and dependents by city and department.
    1. Click the Employee Insurance sheet tab and select cell E25.
    2. Use SUMIFS with an absolute reference to cells F4:F23 as the Sum_range argument.
    3. The Criteria_range1 argument is an absolute reference to cells E4:E23. The Criteria1 argument is bre* to select the city of Brentwood.
    4. The Criteria_range2 argument is an absolute reference to cells D4:D23, the department column, with criteria of lan* to select the Landscape Design department.
    5. Click OK. The result for cell E25 is 10.
    6. Build SUMIFS formulas for cells E26:E28 based on the criteria displayed in cells C26:C28.
    7. Format borders to remove inconsistencies, if any, and adjust column widths to display data.
  8. Use TEXTJOIN to display names. Note: If your version of Excel does not include the TEXTJOIN function, use CONCAT or CONCATENATE to build the function.
    1. Click the Full Names sheet tab and select cell E4.
    2. Start a TEXTJOIN function and press Spacebar for the Delimiter argument.
    3. Click the Text1 box and select cell C4.
    4. Complete the Text2 and Text3 arguments to show middle and last names and click OK (Figure 6-109).The quotation marks display when you move to the next entry box in the list.Figure 6-109 Delimiter is a space
    5. Copy the formula to display full names in column E.
  9. Save and close the ClassicGardens-06 Excel workbook (Figure 6-110).Completed worksheets for Excel 6-5

The customer

  

The customer browses the aisle, selects his book(s), then stands in line at the check-out counter. The cashier takes the book(s) from the customer, reads the price from the cover, then key punches the price into the POS terminal. If the price is missing the cashier summons the clerk from the Warehouse Department to check the price. Invariably, the Warehouse clerk will check with the Accounting Department to verify the price of the book.
Once the price is verified the cashier proceeds to key punch the price. The customer tenders payment in cash, cheque or by credit card once he is told the total owed. After payment is made, the books are handed to the customer. If the customer had brought a bag into the Bookshop, he will collect it from the Baggage Storage Unit before leaving the building.
Draw the context diagram of the check-out process. Draw the diagram from the perspective of the cashier.

Computer Science Foundations II – Discussion 4

 Typically we think of the sum of two or more numbers. To make this problem work, let’s define sum for just one integer to be that integer. 

For your problem to turn in, you will write a proof. Use the proof technique of strong mathematical induction to prove this statement. 

For all integers, k  ≥ 1,  any sum of k multiples of five is also a multiple of 5. 

Computer Assessment

This project lets you look at the computer you are using to determine its’ capabilities and abilities, as there is a lot of variation available. Read this all through to the end once before you try it.

2. First, determine and write down the following hardware information about your computer:

  1. What type –  WIndows, Mac or Chromebook is it? Who was the manufacturer and what is the model?
  2. What is the type of processor (CPU) and what is the CPU speed and number of cores?
  3. How much RAM is on your computer?
  4. How large is the hard drive (or SSD, if you have one instead)?
  5. Does it have an optical storage device? What type?
  6. How large is the monitor screen? What is the maximum video resolution available? What graphics processor or card is used?
  7. Does it have a touchscreen? A webcam? Bluetooth?
  8. What sound/audio hardware does your computer have?
  9. How many external ports (where you can plug things in) does it have, and what types are they?
  10. What OS is it running?
 

3. Now, consider all of the above and write a detailed, several sentence answer to each of the following, stating a position and defending it with arguments/evidence. These are worth 10 points each, so be thorough!
  * You may have to do some research on the Internet to find useful information for these.
  * These questions refer to your hardware “right now, as is” – not if you get some extra parts or upgrades. You may need to add software but that’s NOT a part of the question.

  A. Can your computer be used for everyday average operations such as writing a paper, surfing the web and purchasing items and sending E-Mails?
  B. Can your computer be used for video conferencing with a group?
  C. Can your computer be used to play the latest, high performance, most powerful video game available?
  D. You’re in a band and you have fellow musicians and equipment and even cameras. Can your computer be used to create a professional music video track (“song”)  for sale?
     (More then just point a phone cam at a performance and post it on YouTube.)

4. Your project will be graded according to the following rubric:

Requirements
Max Points Possible
10 numbered questions each answered completely, reasonably and accurately, 2 point each
20
4 lettered questions, each answered completely, reasonably and accurately, 10 points each
40
Total
60