[Solved]1 Explain Statement Respect Database Transaction Imp 2 Give Definition Business Rule Conte Q37253521
1) what does ‘explain’ statement do with respect to databasetransaction? why is it imp?
2) give definition of ‘BUSINESS RULE’ in context of relationaldatabase systems and give an example of how a database triggercould be used to enforce a buisness rule.
Expert Answer
Answer to 1) what does ‘explain’ statement do with respect to database transaction? why is it imp? 2) give definition of ‘BUSINESS… . . .
[Solved]1 Explain Math Behind Big O Give Three 3 Examples O 1 O Logn O N O Nlogn O N 2 O 2 N O N O Q37163933
1. Explain the math behind each Big O
Give three(3) examples of each
O(1)
O(logn)
O(n)
O(nlogn)
O(n^2)
O(2^n)
O(n!)
O(|E|+|V|) – Graph
O(|E|*|V|) – Graph
O(n+m)
2. Given an algorithm, how do you determine its BigO
Find two algorithms and explain how you determined theirBig O.
Expert Answer
Answer to 1. Explain the math behind each Big O Give three(3) examples of each O(1) O(logn) O(n) O(nlogn) O(n^2) O(2^n) O(n!) O(|E… . . .
[Solved]1 Exploratory Data Analysis Eda 30 Points Must Think Least 8 Relevant Questions Explore R Q37222440
1. Exploratory Data Analysis (EDA) 30 Points a. You must thinkof at least 8 relevant questions that explore the relationshipbetween loan_default and the other variables in the data set i. Anexample would be “Do loan default rates differ by customer age?” b.You must answer each question and provide supporting data summarieswith either a summary data frame (using dplyr) or a plot (usingggplot2) or both c. In total, you must have at least 5 plots and 5summary data frames for your EDA section d. You must use at least 3different plot types (ex. bar chart, histogram, heat map)
Below is loan data set info:
loan_data (R data frame) The loan_data data frame containsinformation on 3-year loans that were originated in 2013 by a localbank for customers residing in the United States. The company islooking to see if it can determine the factors that lead to loandefault and whether it can predict if a customer will eventuallydefault on their loan at time of loan origination. The goal is tobecome better at identifying customers at risk of defaulting ontheir loans to minimize the bank’s financial losses. The datasetcontains a mixture of applicant demographics (gender, age,residence, etc..), financial information (income, debt ratios, FICOscores, etc..), and applicant behavior (number of open accounts,historical engagement with the bank’s products, number of missedpayments, etc…) Variable Description loan_default Did the loanresult in default (Yes/No) residence_property Applicant residencestatus – Rent vs Ownership gender Applicant gender (Female/Male)age_category Applicant Age highest_ed_level Applicant highesteducation level – Less than High School through PhD/Doctoratedegree us_region_residence Applicant US region of residenceloan_amnt The loan amount in USD adjusted_annual_inc Applicantadjusted annual salary (for local cost of living) in USDpct_loan_income The loan amount as a proportion of adjusted incomefico_score Applicant FICO score (ranges between 300 and 850) dtiApplicant debt to income ratio inq_last_6mths Number of creditinquires in the last 6 months open_acc Applicant total openaccounts at bank bc_util Applicant bank utility score – a measureof applicant engagement with the bank’s productsnum_accts_ever_120_pd Number of loan accounts that were ever 120days past due for this applicant pub_rec_bankruptcies Applicantpublic bankruptcies
Expert Answer
Answer to 1. Exploratory Data Analysis (EDA) 30 Points a. You must think of at least 8 relevant questions that explore the relatio… . . .
[Solved]1 Fibonacci Sequence Series Integers 0 1 1 2 3 5 8 13 21 34 55 89 See Pattern Element Seri Q37282289
I need help with these two questions. Language is C++. thank youfor your time.
1. The Fibonacci sequence is the series of integers 0,1,1, 2, 3, 5, 8, 13, 21, 34, 55, 89, See the pattern? Each element in the series is the sum of the preceding two items. There isa recursive formula for calculating the n-th number of the sequence (the O-th number if Eibonacci(0)-0) Fibonacci(n) = n, if n = 0 or 1, and Fibonacci(n)-Fibonacci(n-2)+Fibonacci(n-1), ifn>1 Write a recursive version of the C++ function Fibonacci. 3. Mark the following statements as true or false. (a) A binary tree must be nonempty. (b) The level of the root node is 0. (c) If a tree has only one node, the height of this tree is 0 because the number of levels is 0 (d) The inorder traversal of a binary tree always outputs the data in ascending order. Show transcribed image text 1. The Fibonacci sequence is the series of integers 0,1,1, 2, 3, 5, 8, 13, 21, 34, 55, 89, See the pattern? Each element in the series is the sum of the preceding two items. There isa recursive formula for calculating the n-th number of the sequence (the O-th number if Eibonacci(0)-0) Fibonacci(n) = n, if n = 0 or 1, and Fibonacci(n)-Fibonacci(n-2)+Fibonacci(n-1), ifn>1 Write a recursive version of the C++ function Fibonacci.
3. Mark the following statements as true or false. (a) A binary tree must be nonempty. (b) The level of the root node is 0. (c) If a tree has only one node, the height of this tree is 0 because the number of levels is 0 (d) The inorder traversal of a binary tree always outputs the data in ascending order.
Expert Answer
Answer to 1. The Fibonacci sequence is the series of integers 0,1,1, 2, 3, 5, 8, 13, 21, 34, 55, 89, See the pattern? Each element… . . .
[Solved]1 Fill Blanks Following Questions Specifying Execution Order Statements Computer Called B Q37290006
These questions for C programming1) Fill in the blanks in each of the following questions. a) Specifying the execution order of statements by the computer is called b) All programs can be written in terms of three types of control statements: c) T d) The一 repetition statement specifies that a statement or group of e) Repetition of a set of instructions a specific number of times is called f) A procedure for solving a problem in terms of the actions to be executed and g) When it’s not known in advance how many times a set of statements will be and selection statement is used to execute one action when a The condition is true and another action when that condition is false. statements is to be executed repeatedly while some condition remains true. repetition. the order in which the actions should be executed is called a(n) repeated, a(n)value can be used to terminate the repetition. Show transcribed image text 1) Fill in the blanks in each of the following questions. a) Specifying the execution order of statements by the computer is called b) All programs can be written in terms of three types of control statements: c) T d) The一 repetition statement specifies that a statement or group of e) Repetition of a set of instructions a specific number of times is called f) A procedure for solving a problem in terms of the actions to be executed and g) When it’s not known in advance how many times a set of statements will be and selection statement is used to execute one action when a The condition is true and another action when that condition is false. statements is to be executed repeatedly while some condition remains true. repetition. the order in which the actions should be executed is called a(n) repeated, a(n)value can be used to terminate the repetition.
Expert Answer
Answer to 1) Fill in the blanks in each of the following questions. a) Specifying the execution order of statements by the compute… . . .
[Solved]1 Fill Following Blanks Instructions Turing Machine Would Move Input String Fa B Right One Q37285090
1. Fill out the following blanks for the instructions of a Turing machine that would move an input string over fa, b} to the right one cell position. The tape head initially is at the left end of the input string. The rest of the tape cells are blank. The machine will move the entire string to the right one cell position and leave all remaining tape cells blank. The tape head ends at the right end of the output string. (18 points) A, R, found an a (О, а, Л, , (0, b, A, R, (О, Л, Л, S, , a, a, found a b Done found an a & to write an a I D found a b & to write an a (1, Л, a, S. ) Done (2, a, b, F, (2, b, b, R, found a b & to write a b (2, Л, b, S, L.) Done found an a & to write a b Show transcribed image text 1. Fill out the following blanks for the instructions of a Turing machine that would move an input string over fa, b} to the right one cell position. The tape head initially is at the left end of the input string. The rest of the tape cells are blank. The machine will move the entire string to the right one cell position and leave all remaining tape cells blank. The tape head ends at the right end of the output string. (18 points) A, R, found an a (О, а, Л, , (0, b, A, R, (О, Л, Л, S, , a, a, found a b Done found an a & to write an a I D found a b & to write an a (1, Л, a, S. ) Done (2, a, b, F, (2, b, b, R, found a b & to write a b (2, Л, b, S, L.) Done found an a & to write a b
Expert Answer
Answer to 1. Fill out the following blanks for the instructions of a Turing machine that would move an input string over fa, b} to… . . .
[Solved]1 Find Inductive Definition Set S Question N Set Natural Numbers Includes 0 S Ambn M N Ele Q37172426
1. Find an inductive definition for each set S. In thisquestion, N is the set of Natural numbers
and includes 0.
a) S: {ambn| m,n is an element of N, wherem,n > 0} * S is a set of strings
b) S = {am(bc)n | m, n is an element ofN}
Expert Answer
Answer to 1. Find an inductive definition for each set S. In this question, N is the set of Natural numbers and includes 0. a) S: … . . .
[Solved]1 Finally Groups Required Develop Sequence Control Words Implement Following Algorithms 1 Q37261995
1- Finally, groups are required to develop sequence of control words to implement the following algorithms: 1- Multiply 2 registers using concept of repeated additions (With demo). 2- Divide 2 registers using concept of repeated subtraction (With demo). 3- Implement next pseudo code (With demo) for R1-8 down to o R4-R4 + R2 R3; R2 -R2-1; endif 2 Load the ROM in the simulator with this code sequence. Show transcribed image text 1- Finally, groups are required to develop sequence of control words to implement the following algorithms: 1- Multiply 2 registers using concept of repeated additions (With demo). 2- Divide 2 registers using concept of repeated subtraction (With demo). 3- Implement next pseudo code (With demo) for R1-8 down to o R4-R4 + R2 R3; R2 -R2-1; endif 2 Load the ROM in the simulator with this code sequence.
Expert Answer
Answer to 1- Finally, groups are required to develop sequence of control words to implement the following algorithms: 1- Multiply … . . .
[Solved]1 Find Integers S T 172s 151t 1 Full Credit Find Smallest Magnitude Integers Hint First F Q37296295
1. Find integers s, t such that 172s + 151t == 1. For fullcredit, find the smallest magnitude integers you can. Hint: Firstfind gcd(151, 172) = 1.
Expert Answer
Answer to 1. Find integers s, t such that 172s + 151t == 1. For full credit, find the smallest magnitude integers you can. Hint: F… . . .
[Solved]1 Find Names Customers Depositors Accounts Bank Branches Located Salisbury Queries Part Qu Q37256582
My SQL A,B,C
1) Find the names of customers who are depositors and have accounts in all the bank branches located in Salisbury. (For each of the queries that are part of this question, label the query and then refer to the label in later queries, e.g. if one query is labeled Q1 and it is a subquery for another query, you can write the other query as SELECT*FROM X WHERE Y IN (Ql): a) Find all custnames who are depositors. b) Find all actual custname bankname pairs for depositors for bank branches in Salisbury c) Find all the banknames for bank branches in Salisbury Depositor Customer Loan custname custstreet custcity custname acctnum linenum amt bankname Willow North Willow North ntico G-101 G-215 G-102 G-305 G-201 G-217 Johnson C-17 C-23 1000 2000 1500 1500 Smith Downtown Brentwood Nanticoke Downtown Wicomico Somerset Nanticoke Wicomico Wicomico ntico Turner Johnson Jones Lindsay T umet Villiams Wharf Secret Crisfield C-93 Marion 900 1300 C-16 er Jackson Martin Rockfish Salisbury enn er EasternShore Sali 1200 C-8o Johnson Johnson Johnson Sbody Haves G-400 G-402 G-103 G-217 G-105 Secret Baker Branch North Salisbury Account bankname bankcity county assets bankname acctnum balance Downtown Salisbury Brentwood Fruitl and Vienna Wicomico Nithdale Somerset PrincessAn custname linenum Downtown Wicomico Nanticoke G215 G-102 G-305 G-201 G-222 G-217 Jones e SO Somerset Dorchester Brentwood Dorchester Worcester Worcester Downtown EastSide NorthSide C-15 Talbot Worcester Dorchester Cambridge EastSide Salisbury Narth SideSali aston C-93 Williams Adams G-302 G-400 G-402 G-103 Northside G-305 C-23 C-18 C-SO 600 nav 200 Show transcribed image text 1) Find the names of customers who are depositors and have accounts in all the bank branches located in Salisbury. (For each of the queries that are part of this question, label the query and then refer to the label in later queries, e.g. if one query is labeled Q1 and it is a subquery for another query, you can write the other query as SELECT*FROM X WHERE Y IN (Ql): a) Find all custnames who are depositors. b) Find all actual custname bankname pairs for depositors for bank branches in Salisbury c) Find all the banknames for bank branches in Salisbury
Depositor Customer Loan custname custstreet custcity custname acctnum linenum amt bankname Willow North Willow North ntico G-101 G-215 G-102 G-305 G-201 G-217 Johnson C-17 C-23 1000 2000 1500 1500 Smith Downtown Brentwood Nanticoke Downtown Wicomico Somerset Nanticoke Wicomico Wicomico ntico Turner Johnson Jones Lindsay T umet Villiams Wharf Secret Crisfield C-93 Marion 900 1300 C-16 er Jackson Martin Rockfish Salisbury enn er EasternShore Sali 1200 C-8o Johnson Johnson Johnson Sbody Haves G-400 G-402 G-103 G-217 G-105 Secret Baker Branch North Salisbury Account bankname bankcity county assets bankname acctnum balance Downtown Salisbury Brentwood Fruitl and Vienna Wicomico Nithdale Somerset PrincessAn custname linenum Downtown Wicomico Nanticoke G215 G-102 G-305 G-201 G-222 G-217 Jones e SO Somerset Dorchester Brentwood Dorchester Worcester Worcester Downtown EastSide NorthSide C-15 Talbot Worcester Dorchester Cambridge EastSide Salisbury Narth SideSali aston C-93 Williams Adams G-302 G-400 G-402 G-103 Northside G-305 C-23 C-18 C-SO 600 nav 200
Expert Answer
Answer to 1) Find the names of customers who are depositors and have accounts in all the bank branches located in Salisbury. (For … . . .
