Please, I need resturant like authentic food, anything suitable with this is fine.

Your data models must consist of entity lists and entity-relationship diagrams for:

1. Food items (meals/dishes) the restaurants serve o 3 to 5 food types

2. Facilities and equipment

3. Employee work hours and salaries

4. Tracking day-to-day cash flow o Income and spending

5. Competitive o Renovation cost and extra earned income o Promotion cost and extra earned income.

Data modelling

1. Create a list of entities and their attributes from your business statement o You will lose points if you do not create the list of entities and their attributes

2. Create (draw) the entity-relationship diagrams (ERDs and EERDs) for your database using: a. lists of entities from (a) and b. business rules from your business statement

Airline Company Case Study This document describes the data requirements for a fictional airline company, Anchor Air. In this case study, the company's key information requirements are identified. This information primarily deals with the assets the airline must use and manage to operate: airports, maintenance flight routes, and scheduled flights onto which customers book seats along with information about the passengers themselves. Employees The company needs to keep the following information regarding its employee. In the US, all employees have a unique social security number. Other information on employees that the airline might need include facts such as the employee's name; the employee's home street address and the employees city, statement and zipcode; the employee's hone phone number; the employee's salary; and the employee's brithdate. Additionally, some employees are pilot crew, while others are attendant crew. For pilots, the company need to keep the following information:the pilot's rank (probationary, junior, regular, senior); a list of the aircraft the pilot is rated to fly; should reference only aircraft the company owns; the number of flight hours the pilots has flown; the pilots home airport (this should be an airport that the airline is allowed to use); and an additional contact number for the pilot. For attendants, the company needs to keep the following information: the attendant's rank (probationary, crew, chief); the attendant's home airport (again it should be one the airline is allowed to use); and an additional contact number for the attendant Airports An airline is only allowed to fly to specific airports. This airline is a US company and is allowed to fly between US domestic airports only. The company needs to maintain information about the airports it is allowed to use. Airports are identified in the US with a three letter code (upper case)m which are unique. Other facts about airports include which city and state they are in, and how many gates are available for boarding and debarking the aircraft customers. The number of gates must be a positive integer. All of this information is required. Airline Flight Routes The airline has many aircraft flying every day to provide transport for its customers. By regulation, the airline is assigned certain routes between a origin airport and a destination airport. Each route (which is identified by a unique code), is schedule for the same time on the same day every week. While the origin and destination airports are the same every time the route is flown, the gates at the origin and destination airports may change from week to week. The origin and destination airports must each refer to one of the airports to which the airline flies. All of this information is required. Scheduled Flights The airline needs to keep track of the flight routes as they are schedule each day. The schedule simply needs to track which route is being flown (see the previous section on Airline Flight Routes) on which date and what are the departure and arrival gates at the origin and destiation airport, respectively. Flight Prices The seats available on each flight can have varying prices, depending on the class of the seat and these prices can vary from day to day. The database must track the ticket price for the following seat categories: first-class; business class; coach class; and economy class. The ticket price is for a specific seat category for a specific flight route id of the airline on a specific date. Ticket prices must be positive monetary amounts (two decimal places). All of this information is required. Passengers The airline is required to keep certain information about passengers who have booked flights with the airline. The database includes the last name, first name, middle initial, the street address, the city, the state, the zip code, and the phone numbers of the of the passenger and the passengers' email. The required information for the database is the first name, the last name, the street address, the city, the state, the zip code. The the other passenger information is optional. A passenger may give a number of phone numbers or none at all. Flight Bookings The airline must keep information that represents a passenger's booking for one of the airline's flights. The information must show which passenger is booked on a which route on which date and for what price. All of this information is required. Flight Crews The company has to assign crew members (pilots and flight attendants) for each date that one of its routes is flown. For each occurrence of a route being flown on a particular date, the company needs to know which pilots and flight attendants are assigned for that flight on that date. There can be different numbers of crew members assigned, but assume that all flights have cetween two and four pilot crew and four and eight attendant crew.

Relational Database Implementation

In this step, you will implement the table schema developed in step 2, using the Postgres SQL DDL language. Your

deliverable will be a Postgres SQL DDL script which when run in Postgres creates the tables for your case study.

Table Population

In this step, you'll create a data set for your database. Your deliverable will be a Postgres SQL DML script which

when run, inserts your data set into the database tables and also a text document with the data presented in a tabular

format.

Database Operational testing

In this final step, you'll create a Postgres SQL DML script which performs a set of queries on your populated database.

Each case study has a set of sample queries. Choose any ten of these queries and implement them. Your deliverable

will be a Postgres SQL DML script, which when run, performs the queries on your database as well as a text

document with the query results presented in a tabular form. Note, you can capture the query results from the result

window of pgAdminIII.

Wood Maker Ltd. incurred the following selected transactions during the month of April:

For each transaction, indicate (1) the basic type of account debited or credited (asset, liability, shareholders’ equity); (2) the specific account debited or credited; and (3) whether the specific account is increased or decreased to record this transaction. Use the following format.

Concision Exercises

In addition, see “Editing for Concision." at the bottom for more explanation

Concision is the act of reducing the length of a passage, yet still conveying the important information from the passage. For example, instead of using a whole paragraph to introduce yourself, you might use only two sentences. Being concise also depends on being precise, which depends on clear thinking.

Watch out for the following:

The passive voice (Replace “The rules were amended by the secretary” with “The secretary amended the rules.”) This is an example of active voice.

Redundancies (Avoid phrases such as “future prospects.”)

Double Words/repetition (Example: He was tired and exhausted after his run.)

Needless phrases (Avoid using several words when one will work.)

Replace “at the present time” with “now.”

                             Replace “in spite of the fact that” with “although.”

                    Replace “a large proportion of” with “many” or “most.”

Clutter words (Cut empty modifiers such as “very” and “certainly” and “actually”)

Relevance (Include only the information essential to the purpose and meaning of each paragraph.)

Here is a short example—the underlined words are the “clutter words.” Many of these words are already implied, and therefore should be cut!

Lots of words... Decreasing the amount of background noise would be an important thing to do because the coffee house is used for a place of study as well as an eating establishment.

Fewer words... Decreasing background noise is important because the coffee house is used for study as well as for eating.

ASSIGNMENT INSTRUCTIONS: Using the guidelines above and in the textbook, condense the following examples. Write the best version possible, but try and avoid any substantial changes to the content. Keep the essential facts.

SKILLS: Make deletions, condense or join sentences, remove any confusing jargon, improve logic, add transitions, cut repetitions, redundancies, and wordiness.

Type your revision beneath each passage.

BEGIN YOUR ASSIGNMENT BELOW à

1. If an unexpected natural crisis such as a hurricane or earthquake would happen to occur, there is a definite possibility that even large hospitals could be overwhelmed. For example, in 2005, floodwaters from Hurricane Katrina inundated the urban city of New Orleans. Most of its various hospitals experienced power outages. Those power outages left the medical staff scrambling to care for the various patients who required life support. In fact, time wise, the particular situation at Memorial Medical Center was so desperate that they informed the National Guard and then requested their assistance to help with the problem. Fortunately, the National Guard responded and went ahead and delivered back-up generators to ensure that the Memorial Medical Center could stay in operation.

2. As a point of historical fact, NASA’s space exploration projects in the 1960s had a number of very specific goals. To determine whether or not humans could survive and endure the climate of deep outer space, for example, the Mercury Project was designed by scientists. In addition, the Mercury Project proceeded to test the capsule’s ablative heat shield and its potential ability to withstand the extreme temperatures that would be most certainly get generated when the capsule made the attempt to reenter the Earth’s atmosphere.

3. In the end, the consultant finally came to the conclusion that we should divide and break down our company into three main sections or categories to successfully develop a marketing philosophy. The first designated category of our company, Dalton and Henry LLC, will be the Residential Service side, while the second category of the company will be New Construction. Last but not least, the third section of the company will be Service Contracts.

4. The investigation of the office break-in was conducted by Detective Chandler. In the process of the investigation he discovered that the only missing item from the office was a file cabinet. The cabinet contained employee documents. But as a result of the fact that the windows were intact and the locks undamaged, he immediately suspected it was in fact an inside job. After his thorough and meticulous examination of the existing crime scene, Detective Chandler revealed that the likely culprit was in fact a former ex-secretary who had left the company after being fired for incompetence.

5. I am taking time to write this letter because I wish to apply to the U.S. Oceanic Institute and please be considered for the internship position. As it presently stands I am currently a marine biology major at the University of Miami. It’s at the university that my studies focus on marine microbes and their interactions with mollusks (but I also spent many hot summers months working as a waiter for a busy seafood restaurant). After I earn my bachelor’s degree, I plan to earn a master’s degree in statistics and then pick up “so-called” real world experience by seeking out and working as a marine field researcher for one of the multiple non-profit environmental agencies.

an organization uses a job-order costing system. The company uses direct labor hour as the allocation base for applying manufacturing overhead cost to individual jobs. At the beginning of the year, the company’s estimated manufacturing overhead cost is $1,000,000 and the estimated number of labor hours is 200,000. At the end of the year, the company found that the actual manufacturing overhead cost is $1,200,000 and the actual number of labor hours is 250,000.

1. What is the predetermined overhead rate (POHR)?

2. Did the company underapply or overapply the manufacturing overhead? What is the amount of overapplied or underapplied overhead?

• Speak to an elderly individual you know (over the age of 70). Schedule to spend at least 20 minutes with them. Ask them the following questions:
  • What is their favorite memory from childhood?
  • What is their favorite memory from middle adulthood?
  • Ask them the last song they heard on the radio, the last book they read, or what they need from the grocery store.
• Ask them if any of the questions were difficult to answer. Ask if they would share the ways their memory has changed over time and the most frustrating aspect of that change.
• Write a paper describing your conversation, relaying context for the individual you interviewed, the location and time of day of the interview, and how forward they were sharing their answers.
• Relate their answers back to Section 14.3 on Cognitive Processes and memories.
• 2 pages answer please

After finishing university, Mariette is looking for a job. She checks for job advertisements on several large, well‐known, and reputable online sources, and pursues a few lesser‐known sources on the recommendation of several of her former professors. After submitting what seemed like endless resumes, Mariette received several interview offers, one of which was particularly appealing to her, since it was for an entry‐level position in a company she had always wanted to work for. The interview process went well, and she received several job offers, including one from the company she wanted to work for. During that interview, Mariette was promised that the job would involve a lot of independent work and responsibility for projects after an initial training period of three months. This statement, combined with the fact that she had wanted to work for the company for a long time, led Mariette to accept the job offer. Once she had signed the employment contract and had begun work, she went through the initial training period, but her responsibilities didn’t change, and she began to find her work limiting. She also began to notice that some of the employees at her level who had started around the same time she had started were being promoted ahead of her. Several were not as qualified as Mariette. She noticed that all of the employees receiving promotions were men. While this was occurring, the office support staff, all of whom were unionized, were trying to renegotiate their contract. The bargaining went badly, and there was a short strike lasting three days. The situation was resolved, but things were tense for a little while, especially since the support staff had been picketing directly outside of the entrance to the office. By this time, Mariette had worked for her company for a little over two years. One day, she was called into her supervisor’s office and was told she was being let go. She was also told that this was effective as of the end of the work day on that day. No cause was given. Mariette was very surprised, and angry. After discovering that she would get no further pay after the day of her termination, Mariette decided to take legal action.

Analyze the situation and advise Mariette on how she should proceed?

Explain and (diagrammatically) illustrate the key aspects of “Complete v. Incomplete Contracts” in terms of US healthcare patients/consumers and US health insurance companies.

Use these adaptations of Bowles, Foley and Hollidays section headings to organize your progress:

An Ideal (and Unreal) World of Complete Health Insurance Contracts

A benchmark: The patient-payer case

Risk subject to an enforceable contract

The Real World of Incomplete Health Insurance Contracts

The insurer’s expected profit maximization

Why Wealth Matters: Equity and ??? (describe this)

A monopolistic insurer and a wealthy patient-consumer who ??? (describe this)

Competitive markets, wealth constraints and insurance market exclusion

Competitive insuring market and wealthy ???-investing insure

Wealth and the size and quality of healthcare services

Policy Application: Why subsidizing health insurance to the poor may enhance efficiency

What would be observable evidence of health insurance market exclusion if such a subsidy plan was enacted?

For any Hypothesis Test make sure to state Ho, Ha, Test statistic, p-value, whether you reject Ho, and your conclusion in the words of the claim.

For any confidence interval make sure that you interpret the interval in context, in addition to using it for inference.

Round to the thousandths place

The USDA is concerned that most farmers are older Americans. In 2000, it was reported that 25% of all US farmers were over the age of 65. In 2020, a random sample of 350 US farmers was taken and it was found that 98 were over the age of 65. The USDA claims that the proportion of all farmers who are over the age of 65 is now greater than 25%. Does this provide evidence to support the USDA’s claim at the 5% significance level? Run a hypothesis test. Be sure state Ho and Ha, the test statistic and p-value, whether you reject Ho or not and your conclusion in terms of the claim.

1. The US central bank, the Federal Reserve, has two goals in mind when it makes monetary policy, keep inflation and unemployment as low as possible. Why is there tension between these goals? What three tools does the Fed (not the Feds- that is the FBI) use to meet these two goals?
2. If the Fed received data which insinuated that the unemployment rate was lower than the natural rate of unemployment, what might the Fed do in response to this information?
3. Compare the goals of the Federal Reserve when it conducts monetary policy to those of the executive branch of the US government when it conducts fiscal policy.
4. What fiscal policy decisions has the current administration made since taking office in 2016? What do various pundits have to say about the administration’s decisions?

5) Discuss the trade-offs that are evident in the Denmark’s decision to provide job re-training for workers who have lost their jobs.