Entries by Student

write my assignment 28308

Please see attached file for the table.

Use the following tables (with partial data shown) for a car rental database to answer questions 20-25:

CUSTOMER    In table CUSTOMER, CID is the primary key (Customer ID).    RENTALS   In the table RENTALS, RTN provides the rental number (the primary key), CID is the customer’s unique id, PICKUP is the city where the car was picked up, and Return is the city where the car was returned.    RENTCOST    RENTCOST shows the base cost of renting a given MAKE for one day.    

CITYADJ   If the return city of table RENTALS is the one listed in table CITYADJ, the cost of the rental is multiplied by FACTOR and by DAYS shown in table RENTLENGTH below.   RENTLENGTH    RENTLENGTH shows the number of days for the rental number (RTN) shown in table RENTALS. In a database used in reality, this table would be merged with the RENTALS table.

20. SELECT DISTINCT CID, CNAME FROM CUSTOMER WHERE CID IN (SELECT CID FROM RENTALS WHERE MAKE IN (‘FORD’, ‘TOYOTA’)) The CNAMEs shown by the execution of this query are: A. BLACK B. BLACK, JONES C. BLACK, JONES, MARTIN D. BLACK, JONES, MARTIN, VERNON

21. SELECT DISTINCT CUSTOMER.CID, CNAME FROM CUSTOMER, RENTALS, RENTCOST WHERE CUSTOMER.CID = RENTALS.CID AND RENTALS.MAKE = RENTCOST.MAKE AND NOT EXISTS (SELECT * FROM RENTALS R, RENTCOST C WHERE R.MAKE = C.MAKE AND RENTALS.CID = R.CID AND RENTCOST.COST <> C.COST) The meaning of this query is: A. List all customers with more than one car make rented B. List all customers with one or more rentals for which the cost of each car make rented is the same C. List all customers who have only rented one make D. None of the above

22. SELECT MAKE FROM RENTALS, CUSTOMER WHERE RENTALS.CID = CUSTOMER.CID AND RESID_CITY = ‘HEMET’ GROUP BY MAKE HAVING COUNT (DISTINCT RENTALS.CID) = (SELECT COUNT(*) FROM CUSTOMER WHERE RESID_CITY = ‘HEMET’) The execution of this query produces the following number of rows: A. 0 B. 1 C. 2 D. 3

23. SELECT MAKE FROM RENTALS, CUSTOMER WHERE RENTALS.CID = CUSTOMER.CID AND RESID_CITY = ‘HEMET’ GROUP BY MAKE HAVING COUNT (DISTINCT RENTALS.CID) = (SELECT COUNT(*) FROM CUSTOMER WHERE RESID_CITY = ‘HEMET’) The meaning of this query is the following: A. List all makes of cars rented to customers residing in Hemet B. List all makes of cars rented to at least one customer residing in Hemet C. List all makes of cars rented to all customers residing in Hemet D. None of the above

24. SELECT CID, CNAME FROM CUSTOMER WHERE 0 = (SELECT COUNT(*) FROM RENTALS WHERE CUSTOMER.CID = RENTALS.CID) What is the interpretation of this query? A. List the customers who do not have rentals B. List the customers who have one rental C. List the customers who have 0 or more rentals D. List the customers who have 1 or more rentals

25. SELECT CNAME, DATE_OUT, RTN FROM CUSTOMER, RENTALS WHERE CUSTOMER.CID = RENTALS.CID AND BIRTHPLACE IN (‘ERIE’, ‘CARY’) AND EXISTS (SELECT * FROM RENTCOST WHERE COST < 40 AND RENTALS.MAKE= RENTCOST.MAKE) The CNAMEs shown by the execution of this query are: A. SIMON B. GREEN, BLACK, SIMON C. GREEN D. GREEN, SIMON

 

"Not answered?"


Get the Answer

September 18, 2022by

write my assignment 25696

This exercise will demonstrate how the concepts we learned about internal controls in Chapter 4 play out in real life situations with sometimes devastating consequences.

Read the attached article and view this short news video clip on the $54 million fraud committed by former controller Rita Crunwell against the City of Dixon, IL. She spent the stolen money over 20 years on a lavish lifestyle which included horse farms, luxury homes, a $2.1 million RV, a $250,000 horse trailer, over $300,000 in jewelry, and more than 400 horses:

Unlikely Hero in Dixon IL $54m fraud.pdf

Write a paragraph (at least 5 sentences) and respond to two of your classmates’ postings with substantive comments. Note that only responding with merely a “yes” or “no” or “I agree/disagree” is insufficient unless you explain thoroughly WHY you feel that way. Your original post should contain original thoughts or address one or more of the following questions:

  • In considering the fraud triangle, what of the three elements were compromised and why?
  • In considering the concept of separation of duties that is covered in your textbook, what process could the city of Dixon implemented that would have prevented the fraud from occurring?
  • Why do you think Rita Crunwell committed this crime? Explain your answer in detail (e.g., don’t just say she was greedy and leave it at that. Discuss her possible thought processes or why she was greedy.)
  • How do you see Rita’s greed playing out in big or small ways in your world?
  • Just because there were weak controls at the City of Dixon, does that justify Rita’s actions? In other words, just because she had the ability to rip off the system, does that mean she had the right to do so? Does power equal right? Why or why not?
  • What actions would you take if due to a flaw in the accounting system you had the ability to steal a significant amount of money and would probably not get caught for a lengthy period of time?

Please note the due date on the link and turn in your response with plenty of time to spare, as system issues and other last-minute distractions are a way of life. No additional time will be granted if you miss the deadline.

 

"Not answered?"


Get the Answer

September 18, 2022by

write my assignment 3497

The readings and learning activities examined the nexus of civil-military relations and the “holy trinity” identified by Clausewitz; I have to write an in-depth analysis of this relationship in American politics.

According to Clausewitz, war is a “continuation of politics by other means” and victory on the battlefield is dependent upon a effective working relationship among the ‘holy trinity of the government, military and people. I am stuck with the following questions.

  • What factors would you identify as America’s greatest virtues regarding this trinity and the conduct of statecraft?
  • What elements of the relationship would you classify as being detrimental to ensuring national security?

 

"Not answered?"


Get the Answer

September 18, 2022by

write my assignment 26988

I am not able to complete the 3rd and 4th step. 3) Output an invoice for the services selected. Output the cost for each service and the total cost. (3 pts)

‘s auto shop invoice 1: Oil change, 2: Car wax, :

(4) Extend the program to allow the user to enter a dash (-), which indicates no service. (3 pts)

Ex:

Select first service: Tire rotationSelect second service: -Davy’s auto shop invoiceService 1: Tire rotation, $19Service 2: No serviceTotal: $19@@@@@@@ here is my [email protected]@@@services = {‘Oil changeTire rotationCar washCar wax-No service’}print(“Davy’ auto shop services”)print(‘Oil change — $35’)print(‘Tire rotation — $19’)print(‘Car wash — $7’)print(‘Car wax — $12’)total = 0firstService = str(input(‘nSelect first service: n’))secondService = str(input (‘nSelect second service: n’))print(“nnDavy’s auto shop invoicen”)if firstService == ‘Car wash’:    print(‘Service : %s, $7’% firstService)    total +=7elif firstService == ‘Car wax’:    print(‘Service : %s, $12’% firstService)    total +=12elif firstService == ‘Tire rotation’:     print(‘Service : %s, $19’% firstService)     total +=19elif firstService == ‘Oil change’:    print(‘Service : %s, $35’% firstService)    total =+35elif firstService == ‘No service’:    print(‘Service : No service’)    total if secondService == ‘Car wash’:    print(‘Service : %s, $7’% secondService)    total +=7elif secondService == ‘Car wax’:    print(‘Service : %s, $12’% secondService)    total +=12elif secondService == ‘Tire rotation’:     print(‘Service : %s, $19’% secondService)     total +=19elif secondService == ‘Oil change’:    print(‘Service : %s, $35’% secondService)    total =+35    elif secondService == ‘No service’:    print(‘Service : No service’)    total     print(”)    print(‘Total: $’+str(total))

The complete program.

1) Output a menu of automotive services and the corresponding cost of each service. (2 pts)

Ex:

Davy’s auto shop servicesOil Tire rotation Car wash Car wax

(2) Prompt the user for two services from the menu. (2 pts)

Ex:

service: Oil service: Car wax

(3) Output an invoice for the services selected. Output the cost for each service and the total cost. (3 pts)

‘s auto shop invoice 1: Oil change, 2: Car wax, :

(4) Extend the program to allow the user to enter a dash (-), which indicates no service. (3 pts)

Ex:

service: Tire rotation service: -Davy’s auto shop invoiceService 1: Tire rotation, $19Service 2: No serviceTotal: $19

 

"Not answered?"


Get the Answer

September 18, 2022by