FireFold is a one-stop-shop for EcoFlow Solar Panels and all kinds of genuine networking accessories such as sleek socket ultra-thin electrical outlet cover, ethernet cables, Chargers, IOT Installations, and much more. Shop now!
500 Words Assignment
- Briefly respond to all the following questions. Make sure to explain and backup your responses with facts and examples. This assignment should be in APA format and have to include at least two references. Minimum of 400 wordsSince it is so dangerous, why would designers install software into the kernel at all (or make use of kernel software)? If you were an antivirus designer or maker, what other methods do you utilize to prevent virus?
Databases
Watch the Introduction to Databases video (https://www.youtube.com/watch?v=D-k-h0GuFmE ) by Dr. Jennifer Widom of Stanford University and respond to the items in Part 1. Feel free to pause the video to respond to the items and re-watch segments as necessary. Alternatively, you may prefer to view the presentation once through and then again to complete the assignment. The presentation is 13 minutes long.
Part 2 of the assignment is not specifically related to the video, but will require some additional investigation and research.
Note that this presentation is part of a database course for computer science students at Stanford University. When Dr. Widom states ‘in this course we will cover’ or that ‘we will cover’ a given topic in greater detail later in the course, she is referring to her course, not ours.
Exp19_Excel_Ch07_ML2_Finances
Exp19_Excel_Ch07_ML2_Finances
Project Description:
Your family is considering purchasing a house and investing in a business venture. You started the structure for a loan amortization table and the investment table. You will complete the first five years of the 20-year loan amortization table. To complete the table, you will enter formulas to calculate the beginning balance, monthly payment, and ending balance. You will use financial functions to calculate the interest and principal paid for each monthly payment. In addition, you want to calculate cumulative interest after the first year, total interest over the life of the loan, and the amount of principal paid after the first year. You also want to see how many months half or more of the payment is for interest. You will then focus your attention on completing an investment table using date functions, formulas, and a financial function to calculate the future value of the investment.
Start Excel. Download and open the file named Exp19_Excel_Ch07_ML2_Finances.xlsx. Grader has automatically added your last name to the beginning of the filename.
The first step is to enter a formula to reference the loan amount for the beginning balance for the first payment.
In cell B9, enter a formula that references cell D2.
A loan amortization table usually contains a column that displays the monthly payment for each row.
In cell C9, enter a formula to reference the monthly payment in cell D3. Use a mixed reference and copy the formula to the range C10:C68.
The monthly payment indicates the total amount of the payment, which includes principal and interest. Interest is calculated based on the loan amount, the rate, the payment number, and the number of payments.
In cell D9, enter the IPMT function to calculate the interest paid for the first month using mixed cell references to the input area for the Rate, Nper, and PV arguments and using cell A9 for the Per argument. Make sure the result is a positive value and copy the function to the range D10:D68.
After calculating the interest paid, the rest of the monthly payment repays the principal.
In cell E9, enter the PPMT function to calculate the principal paid for the first month using mixed cell references to the input rea for the Rage, Nper, and PV argument and using cell A9 for the Per argument. Make sure the result is a positive value and copy the function to the range E10:E68.
The last column of the loan amortization table calculates the ending balance.
In cell F9, calculate the ending balance by subtracting the Principal Repayment from the Beginning Balance in row 9. Copy the formula to the range F10:F68.
The beginning balance for each payment is calculated and entered in column B.
In cell B10, enter a formula that references the first month’s ending balance in cell F9. Copy the formula to the range B11:B68.
Ensure that Accounting Number Format is applied to the range B9:F68.
You want to calculate the total interest paid for the first year.
In cell F2, insert the CUMIPMT function to calculate the cumulative interest paid for the first year. Use A9 for the Start_period argument and B6 for the End_period argument. Use 0 as the Type argument. Make sure the result is a positive value.
Now you want to calculate the total interest paid for the entire loan.
In cell F3, insert the CUMIPMT function to calculate the total cumulative interest paid for the entire loan. Use A9 for the Start_period and D6 for the End_period arguments. Make sure the result is a positive value.
You want to calculate the cumulative principal paid for the first year.
In cell F4, insert the CUMPRINC function to calculate the cumulative principal paid for the first year. Use A9 for the Start_period and B6 for the End_period arguments. Make sure the result is a positive value.
In cell F5, insert the COUNTIF function to count the number of payment periods in which the interest in the loan amortization table is higher than one-half of the monthly payment (cell D4).
Apply General number format to cell F5.
You want to extract the year and use it to determine the payoff year.
Display the Investment sheet. In cell D4, insert the YEAR function to extract the year from cell D3 and add the number of years (cell B3). You will change the format of the result in the next step.
You need to format the result in cell D4 as a number.
Ensure that General number format is applied to cell D4.
At the end of each period, you will add $125 to the investment.
In cell D7, enter a formula that references cell D2. Use a mixed reference to ensure the row number does not change. Copy the formula to the range D8:D54.
You want to calculate the interest earned per period.
In cell C7, multiply the beginning balance in cell B7 to the result of dividing the APR by the No. of Pmts per Year. Use mixed and relative cell references. Copy the formula to the range C8:C54.
You are ready to calculate the ending balance for each payment period.
In cell E7, add the Beginning Balance, Interest Earned, and End-of-Period Investment for row 7. Copy the formula to the range E8:E54.
You will use a nested function to calculate the dates in column A.
In cell A8, create a DATE function with a nested YEAR function, a nested MONTH function and then add 1 to increment the month, and a nested DAY function. The function arguments should reference the date on the previous row.
Copy the function from cell A8 to the range A9:A54 but preserve the fill formatting.
In cell E56, insert the FV function to calculate the future value of the investment use references to the respective cells in the input area for the arguments. Make sure the result is positive. Leave the Type argument empty.
Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of both sheets.
Save and close Exp19_Excel_Ch07_ML2_Finances.xlsx. Exit Excel. Submit the file as directed.
Cakes By Monica Excel Assignment
Cakes By Monica Excel Assignment
For this assignment you will perform calculations in an Excel file. You can find the file in Week 2. Please note, it is your responsibility to have the correct software!
Instructions:
Cakes by Monica (a bakery under the umbrella of the Café Brulé restaurant) in Vermillion, SD makes cupcakes for customers to purchase both in the store and in bulk orders for birthday parties and weddings.
Suppose in the short-run, a bakery like Cakes by Monica has a fixed amount of capital but can hire college students from a local college easily to increase production as needed. A production schedule is provided for you where Q is dozens of cupcakes.
a) Using the schedule provided, calculate the marginal product of labor when K = 3.
b) Using your calculations, for which workers are there increasing, decreasing, and negative marginal returns to labor?
c) Suppose this bakery decides to add another unit of capital in the long-run. Find the marginal product of the 4th unit of capital and the marginal product of labor when K = 4.
d) Create a graph of the marginal product of labor for K=3 and K=4.
e) Using your graph and the data, how does the addition of another unit of capital affect the productivity of labor?
Please provide all answers (calculations and written explanations) in the provided Excel File. Save your file with your Firstname_Lastname and submit it in the designated area.
Assignment W8 (E-commerce)
Write an HTML code to produce the following text:
TECH581, Electronic Business Systems, Spring 2021 Online
Hint: You can download and use Toniarts Easy HTML Editor
Risk Management Project Part 5
Project Part 5: Final Risk Management Plan
Compile all project parts into a single risk management plan document. Reduce redundant text, if any. Incorporate instructor feedback on the previous submissions in the final risk management plan.
Submission Requirements
- Format: Microsoft Word (or compatible)
- Font: Arial, size 12, double-space
- Citation style: Your school’s preferred style guide
- Estimated length: 14–20 pages
List The Following Briefly Each Question. With At-Least Six Sentences For Each
- 4.1 List ways in which secret keys can be distributed to two communicating parties.
- 4.2 What is the difference between a session key and a master key?
- 4.3 What is a key distribution center?
- 4.4 What entities constitute a full-service Kerberos environment?
- 4.5 In the context of Kerberos, what is a realm?
- 4.6 What are the principal differences between version 4 and version 5 of Kerberos?
- 4.7 What is a nonce?
- 4.8 What are two different uses of public-key cryptography related to key distribution?
- 4.9 What are the essential ingredients of a public-key directory?
- 4.10 What is a public-key certificate?
- 4.11 What are the requirements for the use of a public-key certificate scheme?
- 4.12 What is the purpose of the X.509 standard?
- 4.13 What is a chain of certificates?
- 4.14 How is an X.509 certificate revoked?
GUI
write a paper of 3–4 pages not including the reference page to address the following question shown below. Use the library, the Internet, and your text materials to research the history of GUI in Java, and discuss at least 2 different technologies that can be used to create a GUI. Be sure to cite all of your sources using APA format.
Homework assignment
Homework assignment
The following table records the results for would-be actors who are undergoing a preliminary screening audition for a particular role in a play. Any actor who is turned down for a role, in the preliminary screening, is not allowed to re-audition for that role again. (Everyone who passes will be re-auditioned later along with others who passed the preliminary screening, and that data will be put in a separate table.)
Actor
Role
AuditionDate
Result
AaryanChaudary
Julius Caesar
2018-09-13
reject
AaryanChaudary
Brutus
2018-09-14
pass
Barry Evans
Julius Caesar
2018-09-13
pass
Isaac Biko
Cassius
2018-09-13
pass
Isaac Biko
Julius Caesar
2018-09-13
pass
The primary key of this table is Actor + Role.
Question 1
What bad consequences could follow if, in creating the table – before we added the data – we defined the primary key of the table as:
(a) Actor alone?
(b) Role alone?
(c) AuditionDate Alone?
(d) Actor + Role + AuditionDate?
(e) Actor + Role + AuditionDate + Result?
Question 2
Suppose it is decided to allow actors to re-audition for roles for which they were initially rejected, at a later date. Would we need to change the definition of the primary key? If we didn’t change it, what problem might arise? If we changed it, what would the new key be? Explain your answer.
********************************************************************************************************
Normalizing an Unnormalized Relation
The following table holds information about the annually-recorded weight of particular prize sheep, and about the veterinarians (vets) who weigh them. Each sheep belongs to a particular owner. No sheep is owned by more than one owner. Each sheep’s birthdate and current owner is recorded. Every year, a veterinarian weighs each prize sheep and records its weight. The date of the weighing, and the ID number of the vet, plus the mobile phone number of the vet, is recorded. Vets have only one mobile phone number. The Primary Key of the table recording this information is SheepID+WeighingDate. The table has not been normalized beyond First Normal Form. That is, there are no ‘repeating groups’, but there may be Partial and Transitive Dependencies.
SheepID
Owner
Birthdate
WeighingDate
Vet
Weight
VetPhoneNum
K3922
McNab013
2013-05-12
2013-08-14
M330
22
7633088852
K3922
McNab013
2013-05-12
2014-06-02
S929
34
7609865463
K3922
McNab013
2013-05-12
2015-08-02
M330
43
7633088852
K3922
McNab013
2013-05-12
2016-07-30
P301
53
7682907965
K3922
McNab013
2013-05-12
2017-08-12
P301
52
7682907965
K3922
McNab013
2013-05-12
2018-07-22
S929
51
7609865463
T8832
McNab013
2012-03-26
2012-08-14
K339
19
7602907550
T8832
McNab013
2012-03-26
2013-09-01
S929
26
7609865463
T8832
McNab013
2012-03-26
2014-08-15
K339
32
7602907550
T8832
McNab013
2012-03-26
2015-07-28
K339
40
7602907550
T8832
McNab013
2012-03-26
2016-08-11
T975
42
7646746741
P9742
Smith002
2014-05-10
2014-09-11
K339
14
7602907550
P9742
Smith002
2014-05-10
2015-08-10
S300
25
7629920821
P9742
Smith002
2014-05-10
2016-08-29
K339
35
7602907550
P9742
Smith002
2014-05-10
2017-09-01
S929
44
7609865463
P9742
Smith002
2014-05-10
2018-08-22
S929
51
7609865463
M3110
Smith002
2015-05-12
2015-09-12
S300
15
7629920821
M3110
Smith002
2015-05-12
2016-09-10
S300
26
7629920821
M3110
Smith002
2015-05-12
2017-08-17
K339
34
760290755
Question 3
Identify the Functional Dependencies in this table. Your answer should conform to the following format: If, taken together, attributes A and B determine C, show it this way:
A + B → C
Question 4
The above table in question 3 is susceptible to update, deletion, and insertion anomalies. Examine the ten possible problems. (Some of these problems are examples of normalization anomalies, and some are not.) For each of the 10 problems (a to j) below state whether there are
Update
Anomaly
Deletion
Anomaly
Insertion
Anomaly
None of these.
Problem
a. Instead of entering ‘2014-08-15’ for one of the weighing dates, ‘2104-08-15’ could be entered instead.
b. We cannot insert information about a new vet (such as their mobile phone number) until they have weighed a sheep.
c. If we delete all the tuples about a particular sheep, we lose all the information about that sheep.
d. If we delete all the tuples for sheep K3922, we lose information about Vet M330’s mobile phone number.
e. We cannot enter ownership and birthdate information about a sheep until it has been weighed.
f. A Vet could record a sheep’s weight incorrectly.
g. If a Vet changes their mobile phone number, we could record the change in some of the tuples with thier ID, and not in others.
h. If a Vet changes their mobile phone number, we could record the new number incorrectly.
i. If we delete information about a Vet, we lose their mobile phone number.
j. If sheep is sold to a new owner, we could change some of its Owner values but not others.
Question 5
Split the above table from question 3 above into tables in BCNF, specifying the Primary Key of each table, and showing the first and last tuples for each table (following the order of tuples in the original table).