Global Logistics

From the word "MANAGEMENT", develop 15 Nouns (name of a person, place or thing). Avoid plurals, acronyms, abbreviations)

Makeup words that is a NOUN from the term 'Management'. A now is the name of a person, place or thing. Verbs, abbreviations, plurals are NOT allowed.

Example: Man is coined from Management

Accounting for Bonds Payable On January 1, 2015, Crabb & Co. issued 10-year bonds with a total face value of $500,000. The bond requires annual interest payments on December 31 at a stated rate of 6%. Bonds with similar features are discounted in the market at 8%

.1. DATE ACCOUNT NAME DEBIT CREDIT BALANCE SHEET INCOME STMT A = L + E R - E 01/01/15

2.Prepare the entry at 12/31/15 to record interest expense, cash paid, and discount amortization. DATE ACCOUNT NAME DEBIT CREDIT BALANCE SHEET INCOME STMT A = L + E R - E 12/31/15

Short Answer. Be thorough and clear in your answers. There are two parts A and B, so please identify your answers with an A and B.

Suppose that during this current coronavirus-caused recession with high unemployment rates and lower incomes, consumers choose to buy more generic food products and fewer brand name food products. (Assume the prices of the generic and brand name products did not change during this time).

A. Explain which good (generic or brand-name) is inferior and which good is normal.  Be sure to fully explain how you determined this answer (hint: definitions of these are in Ch. 4).

B.  Identify which elasticity measurement would be used to determine inferior and normal goods. Explain the formula and state what result you would expect for the brand name and the generic good, given your answer to part A. (i.e. positive number or negative number). [Hint: the more detailed (and correct) the answer, the better.]

Q) Find the instructor earning the second highest salary. (Don’t use ORDER BY and LIMIT in your solution.) in MySQL

here is the table I am using named Instructor with the following 4 attributes:
Instructor(ID, name, dept_name, salary)

ID is the primary key

I am supposed to report the answer with the name, ID and salary of the second highest salaried instructor.

I know how to do it if I only needed to report the second highest salary, but I am having trouble getting it with the corresponding name and id as well. This is what I am trying:

Select ID, name, max(salary) as salary
From instructor
Where salary < (select max(salary)
               From instructor);


but it is saying "Error Code: 1140. In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'database.instructor.ID'; this is incompatible with sql_mode=only_full_group_by"


Any help is appreciated!

Write the following questions as queries in SQL. Use only the operators discussed in class (no outer joins)

Consider the following database schema:

INGREDIENT(ingredient-id,name,price-ounce)

RECIPE(recipe-id,name,country,time)

USES(rid,iid,quantity)

where INGREDIENT lists ingredient information (id, name, and the price per ounce); RECIPE lists recipe information (id, name, country of origin, and time it takes to cook it); and USES tells us which ingredients (and how much of each) a recipe uses. The primary key of each table is underlined; rid is a foreign key to RECIPE and iid is a foreign key to INGREDIENT

Write the following queries in SQL.

1. Find the names of French recipes that use butter and take longer than 45 minutes to cook.

2. Find the names of recipes that use butter or lard.

3. Find the names of recipes that use butter and lard.

So currently I am working on some SQL with python which is linked to my database and I am stuck on a split problem. So in the program it connects to the database and then next you input either list, add, update, remove or allocate. So lets say I want to add a new data into the database you just need to write: update -name='Ava - #2' -class=2.

After you type this there is a variable called val which does the strip and split.

So as of right now what I have done is:

val = input('> ').strip().lower()
parts = val.split(' ')
print(parts)

So if I input the following: update -name="Nile Adam" -class=2

I expect the following output: ['update', '-name="Nile Adam"', '-class=2']

However the output I get is: ['update', '-name="Nile', 'Adam"', '-class=2']

There will be three grades for each student in "grades.txt" (see example file bellow). In "student.txt" there are two students first and last names. In "grades.txt" the grades for each student will be on the same line number as the students name was on in "students.txt".

So if line 1 of "students.txt" contains:

Joe Blow

then line 1 of "grades.txt" would contain Joe Blow's grades:

85 54.3 56

Into an output file called "report.txt" output the student's last name then a comma the their first name. Following this, calculate their average and assign a letter grade using the following scale:

'A': grade >= 90

'B': 90 > grade >= 80

'C': 80 > grade >= 70

'D': 70 > grade >= 60

'F': grade < 60

If the final grade of a student is greater than 100 instead of printing their letter grade output the statement "Teacher was far too easy". The "report.txt" should have a heading on each of the columns the first saying "Student's Name" and the second saying "Student's Grade".

i'm working on this assignment where we must simulate a bank account. I am having a few issues. The first issue is that for menu option 1 i am struggling to make the program so that I can add the name and balance of the account all at once. For example I would type "mike 350" and it would update the dictionary with a new account and balance, right now i have to open the account then deposit a balance separately using two different menu functions. The second issue i am having is that every account name in the dictionary has the same balance, I need to have each person have a separate balance. The third and last issue I am having is with menu option #6, i am not sure how to list the account names and balances with a number of each account to the left, the professor wants the output to look like this for option 6

No Customer Name   Balance

== =============   =======

1 joe 10

2 jim 20

3 eric 30

I have made it this far.

def main():
  
print("1. Open an account")
print("2. Close an Account")
print("3. Deposit money")
print("4. Withdrawal money")
print("5. Enquire about balance")
print("6. Print a list of customers and balances")
print("7. Quit")

accounts = {}
balance = 0
main()

while True:
menu_choice = int(input("Type in a menu choice: "))

#menu choice 1
if menu_choice == 1:
number = input("Enter name of the new customer and \nthe amount of money to be deposited \n into the new account (Ex. 'Mike 350'):")
if number in accounts:
print('This customer already exists!')
  
else:
accounts[number]=balance
print ("Account name", number, "opened.")

#menu choice 2
elif menu_choice == 2:
number = input("Account name:")
  
if number not in accounts:
print('Enter the customer/account name to be deleted: ')
if number in accounts:
if balance>0:
print('Can not close an account with balance greater than zero')
else:
del accounts[number]
print ("Account number", number, "is closed.")

#menu choice 3
elif menu_choice == 3:
print ("Enter the customer name for deposit: ")
number = input("Account name: ")
if number in accounts:
deposit = float(input("Enter the amount to be deposited: "))
  
balance += deposit
print ("your balance is:", balance-deposit, "before deposit")
print ("Your balance is:", balance, "after deposit")
else:
print ("This customer doesn't exist!")

#menu choice 4   
elif menu_choice == 4:
number = input("Enter the customer name for withdrawl: ")
if number not in accounts:
print('This customer doesnt exist!')
  
if number in accounts:
withdraw = float(input("Enter the amount to be withdrawn: "))
if withdraw <=balance:
balance -=withdraw
print ('your balance is:', balance+withdraw, 'before withdrawal')
print ("Your balance is:", balance, 'after withdrawal')
if withdraw >balance:
print ('your balance is:', balance, 'before withdrawal')
print ('You dont have enough balance to cover the withdrawal')

#menu choice 5
elif menu_choice == 5:
number = input('Enter the customer name for balance enquiry: ')
if number not in accounts:
print('This customer doesnt exist!')

if number in accounts:
print('your balance is:', balance)
  
#menu choice 6
elif menu_choice == 6:
print ("Accounts")
for x in accounts.keys():
print ('No Customer Name Balance')
print ('============================')
print (x , balance\n)

#menu choice 7
elif menu_choice == 7:
print ("Quit.")
break
else:
print ("Please enter a menu choice between 1 and 6.")

main()