Major Funds

Lenox County provides the following information on its governmental and enterprise funds:

In the governmental funds financial statements, which of these funds are reported separately as major funds?

Calculate the thresholds:

please unique answer, no handwriting, for safeAssign Pilgirism submission.API style

You have been hired to design a database for prescriptions for RX pharmacies and your first job now is to design an ER model for this database using the following description of that world.

i. patients are identified by their SSN and have other attributes as names, addresses, and ages.

ii. Doctors are identified by their SSN and have other attributes as names, specialty, and years of experience.

iii. Each pharmaceutical company is identified by name and has a phone number.

iv. For each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company is deleted, you need not keep track of its products any longer.

v. Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.

vi. Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity associated with it. You can assume that if a doctor prescribes the same drug for the same patient more than once, only the last such prescriptions needs to be stored.

vii. Pharmaceutical companies have contracts with pharmacies. A pharmaceutical company can have contracts with several pharmacies and a pharmacy can have contracts with several pharmaceutical companies. For each contract, you need to store a start date, an end date and the contract text.

viii. Pharmacies appoint a supervisor for each contract. There must always be a supervisor for each contract.

Hint: Present the conceptual design first, showing (1) all the entities and their attributes, (2) all the relationships and their attributes, (3) all the constraints before drawing your ER.

v

Write a program that calculates and displays different suggested tip amounts, much like you see at the bottom of restaurant bills. Here is a sample execution:

Sample Execution:

Enter the total bill amount: $50

Suggested Tip Amounts:
10%: $5.00(for okay service)
15%: $7.50(for good service)
20%: $10.00(for great service)
Total with tip: $57.50

Requirements:

• 2 pts - When you name your file use your last name – for example: LastNameHW04.py

• 3 pts - Place a comment at the top of your code with your name and the purpose of the program.

• 10 pts - The program should start by asking the user for input exactly in the form

  below. Their response (input) should be stored in a variable. The amount they enter should be converted to a float in order to allow for decimals to be entered and to do math using it.

            Enter the total bill amount: $
  

• 15 pts - Use three lines of code to store the 10%, 15% and 20% tip values into three different variables.

• 10 pts - Variables names must follow Python standard naming conventions.

• 5 pts – For output, the program should first display the statement below on one line:

            Suggested Tip Amounts:
  

• 30 pts – Next, use three lines of code to print the calculated tip amounts exactly as shown below. There should not be a space after the $, and to output the % symbol, enter %%. The values in red below will vary based on the user input:

  10%: $5.00(for okay service) 15%: $7.50(for good service) 20%: $10.00(for great service)

• 5 pts - Include additional comments throughout your code explaining what your code does. Remember comments start with #.

• 20 pts - Extend the program to output an addendum to the receipt that adds a mandatory 15% tip to the total bill amount. You will need an additional variable to store the final cost after adding the tip to the toal bill amount. Output the final total.

Prompt for input

Example of Input: 50

Total with tip: $57.50

Given the following 7 relations:

MIScompany (name, address, phone, email, FedTaxId, StaTaxId)

branch (branchId, name, address, phone, email, FedTaxId, StaTaxId)

employee (empId, driverId, ssno, name, branchId)

customer (custId, name, address, driverId, ssno, FedTaxId, StaTaxId)

equipment (equipId, name, type, upc, purchaseDate, year, manufacturId, cost, rentFee, branchId )

manufacturer (manufacturId, name, FedTaxId, StaTaxId, phone, email)

rental (rentalId, equipId, custId, rentDate&time, returnDate&time, empId)

1. Use relational algebra to retrieve every customer that has not rented any equipment in September 2020. The report should contain custId and customer name.
2. Use relational algebra to list every manufacturer that only makes an electric cleaning tool (a type of equipment). The report should contain manufacturId and manufacturer name
3. Use relational algebra to list the number of rentals that is handled by each employee yesterday. The report should contain empId, employee name, and the number of rentals handled by the employee (rented yesterday).
4. Use relational algebra to list all equipment in detail, including the name of the customer if the equipment is rented out yesterday.
5. Use relational algebra to list every to list each equipment name with more than three quantities and the name of customers who has rented them. The report should contain the equipment name and customer name.

Write a program that prompts the user to enter a file name, then opens the file in text mode and reads names. The file contains one name on each line. The program then compares each name with the name that is at the end of the file in a symmetrical position. For example if the file contains 10 names, the name #1 is compared with name #10, name #2 is compared with name #9, and so on. If you find matches you should print the name and the line numbers where the match was found.

While entering the file name, the program should allow the user to type quit to exit the program.

If the file with a given name does not exist, then display a message and allow the user to re-enter the file name.

The file may contain up to 100 names.

You can use an array or ArrayList object of your choosing, however you can only have one array or ArrayList.

Input validation:

a) If the file does not exist, then you should display a message "File 'somefile.txt' is not found." and allow the user to re-enter the file name.

b) If the file is empty, then display a message "File 'somefile.txt' is empty." and exit the program.

Hints:

a) Perform file name input validation immediately after the user entry and use a while loop .

b) Use one integer variable to count names in the file and another one for counting matches.

d) You can use either a while loop or a for loop to find the matches.

Please write the correct query for the following questions:

1. Select the name of each manufacturer along with the name and price of its most expensive product.

2. Computer products are expensive. Find the maximum priced product. Which products are within $30 of the maximum priced product.

3. Find the maker of the most expensive ‘drive’. Note, there are variety of drives in the data. Regular expressions help.

Using the following table:

CREATE TABLE manufacturers (
code number PRIMARY KEY NOT NULL,
name varchar(50) NOT NULL
);

CREATE TABLE products (
code NUMBER PRIMARY KEY NOT NULL,
name varchar(50) NOT NULL ,
price real NOT NULL ,
manufacturer number NOT NULL
CONSTRAINT fk_manufacturers_code REFERENCES manufacturers(code)
);

INSERT INTO manufacturers(code,name) VALUES(1,'Sony');
INSERT INTO manufacturers(code,name) VALUES(2,'Creative Labs');
INSERT INTO manufacturers(code,name) VALUES(3,'Hewlett-Packard');
INSERT INTO manufacturers(code,name) VALUES(4,'Iomega');
INSERT INTO manufacturers(code,name) VALUES(5,'Fujitsu');
INSERT INTO manufacturers(code,name) VALUES(6,'Winchester');

INSERT INTO products(code,name,price,manufacturer) VALUES(1,'Hard drive',240,5);
INSERT INTO products(code,name,price,manufacturer) VALUES(2,'Memory',120,6);
INSERT INTO products(code,name,price,manufacturer) VALUES(3,'ZIP drive',150,4);
INSERT INTO products(code,name,price,manufacturer) VALUES(4,'Floppy disk',5,6);
INSERT INTO products(code,name,price,manufacturer) VALUES(5,'Monitor',240,1);
INSERT INTO products(code,name,price,manufacturer) VALUES(6,'DVD drive',180,2);
INSERT INTO products(code,name,price,manufacturer) VALUES(7,'CD drive',90,2);
INSERT INTO products(code,name,price,manufacturer) VALUES(8,'Printer',270,3);
INSERT INTO products(code,name,price,manufacturer) VALUES(9,'Toner cartridge',66,3);
INSERT INTO products(code,name,price,manufacturer) VALUES(10,'DVD burner',180,2);

46   In a perfectly competitive market, the type of decision a firm has to make is different in the short run than in the long run. Which of the following is an example of a short-run decision a perfectly competitive firm makes?

a. the profit-maximizing level of output

b. how much to spend on advertising and sales promotion

c. what price to charge buyers for the product

d. whether or not to enter or exit an industry

47 Which barrier to entry is an exclusive right granted to the author or composer of a literary, musical, dramatic or artistic work?

a. patent

b. copyright

c. public franchise

d. government license

This format should allow you more time to think about your answer. You can also use the readings to support your answer. Be sure to cite the author and page number for all quotes or ideas taken from one of the authors (e.g. Chang, p. 81). The length of your answers should range from 1-3 paragraphs, depending on the complexity of the question.

Interest in Heterodox economics is increasing. What events have taken place to bring more attention to heterodox perspectives? Explain, in particular, the alleged shortcomings of neoclassical economics in relation to these recent economic events.