SUBJECT: DATABASE SYSTEMS

!!! Please answer the question as early as possible !!!

Question 1
You are required to draw a complete Crow’s Foot ERD that includes the following entity
relationship components based on the below descriptions:
i) Identify all of the entities and its attributes.
ii) Identify all possible relationships and its connectivity.
iii) Identify the primary key and foreign key for each entity.
iv) Identify the participation constraint and cardinality for each relationship.
A Super5 company contains many departments. Each department has name and is identified
by department code. Each department employs many employees. An employee can work only
in one department. Each employee has ID number, name, job specialization, and email as the
attribute. Not all employees such as president and vice presidents will be assigned a
department.
Manager within the employee may supervises at least fifteen employees under his/her
supervision. An employee can be supervised by only one manage but president and vice
presidents no need manager to supervise them.
Every year Super5 company will organized a fund-raising events to aid an orphanage home.
During the event, a department needs to set up at most three committees and each committee
handled by one and only one department. The committee has committee id and committee
name. But not all departments need to set up a committee.
Each committee will be assigned to do many tasks. A task will be completed by one and only
one committee. The maximum number of tasks per committee is five. Special task will not be
handled by committee. The task will have the task number, task name, assign date, and task
duration to be completed.
There are many employees’ becoming a member of the committee. Each employee can work
in a committee based on the fund-rising event. This event will be held from time to time basis.
Whenever an employee is participating as committee member in fund-raising event,
participation date, event name, and position must be stored. Each event will have a unique
code.

Karen and Dave King are a two-income couple in their early thirties. They have two children, ages 6 and 3. Dave’s monthly take-home pay is $1,800, and Karen’s is $2,100. The Kings feel that because they are a two-income family, they both should have adequate life insurance coverage. Accordingly, they are presently trying to decide how much life insurance each one of them needs.

To begin with, they would like to set up an education fund for their children in the amount of $80,000 to provide college funds of $10,000 a year – in today’s dollars – for four years for each child. Moreover, in the event of either one of their deaths, they want the surviving spouse to have the funds to pay off all outstanding debts, including the $140,000 mortgage on their house. They estimate that they have $15,000 in consumer installment loans and credit cards. They also project that if either of them dies, the other probably will be left with about $10,000 in final estate and burial expenses.

As far as their annual income needs are concerned, Dave and Karen both feel very strongly that each should have enough insurance to replace their respective current income levels until the youngest child turns 18 (a period of 15 years). Though neither Dave nor Karen would be eligible for social security survivor’s benefits because they both intend to continue working, both children would qualify, in the (combined) amount of around $1,400 a month. The Kings have amassed about $75,000 in investments, and they have a decreasing-term life policy on each other in the amount of $85,000, which would be used to partially pay off the mortgage. Further, Dave has a $60,000 group policy at work and Karen a $90,000 group policy.

Complete Life Insurance Needs Worksheet for Karen & Dave King.

Use separate worksheets for Dave (where Karen is the survivor) and Karen (Dave is the survivor).

Please Number Your Answers 1. McDonalds in the early Kroc years. a. What was the value proposition offered by McDonalds? What brought customers (repeatedly) in the door? b. What did the SWOT analysis look like at this time? 2. McDonalds in the Skinner years (c, 2003) a. Had the value proposition changed? b. How does a SWOT analysis look different? c. What do those changes suggest about the need to adapt? 3. McDonalds (2017) a. How does a SWOT analysis look different? b. What do those changes suggest about the needing to constantly challenge your value propositions for your targeted markets?

The coronavirus intervened Australia in early 2020.

On 12 May, the Morrison government issued an unprecedented progress report on the delayed budget, outlining the coronavirus pounding to the national economy and the huge outlay to deal with the pandemic.

What were the main issues presented? How do you think they would affect the economy, social and employment situation in the near future?

1. What type of information you would be seeking from a new employer or client, early in the relationship, to establish your understanding of the baseline energy use and management, and business and financial, strengths and weaknesses of the company or organization?
2. What would be your approach to acquiring the information you identified for “item a”, including if an employer or prospective client was reticent or simply unfamiliar with energy management issues.

In contrast to what we were taught about the use of technology and early childhood, your teen seems to find encouragement to use technology from all sides. What are the pros/advantages and cons/risks of allowing your teen access to technology and the internet? How will you monitor or limit your teen's use

McDonalds in the early Kroc years. What was the value proposition offered by McDonalds? What brought customers (repeatedly) in the door? What did the SWOT analysis look like at this time? McDonalds in the Skinner years (c, 2003) Had the value proposition changed? How does a SWOT analysis look different? What do those changes suggest about the need to adapt? McDonalds (2017) How does a SWOT analysis look different? What do those changes suggest about the needing to constantly challenge your value propositions for your targeted markets?

In the early months of 2020, many sectors in Hong Kong have been hit hard by the COVID19 outbreak. Investigate how the COVID19 affects the various aspects of the economy, such as Gross Domestic Product (GDP), import and export, economic growth/economic recession, unemployment, and cost of living (inflation/deflation)?

Have the government remedial policies been able to revitalize the economy?

What appropriate policies should be taken to revitalize the economy of Hong Kong if your group were one of the policy-makers in the government leadership?

Early industrial societies used whale oil in oil lamps and for lubricating machines. The composition of oil varied across whale species. For example, sperm whales were targeted because their oil commanded a higher price in the market. Whaling boomed in the 1800s. You can assume that the primary focus of commercial whaling was to recover oil.

a. Develop a simple graphical model to describe the growth and decline of whaling in the US over the period 1800 through 1900.

b. Describe the factors that led to the growth and decline of commercial whaling over the period 1800-1900. Provide evidence that supports the model provided in (a) above. Your research should consider the impact of technology, markets, prices, rules governing access, attributes of the resource, and other factors you might uncover.

c. Using (a) and (b) test the veracity of the “Demsetz hypothesis”: In a situation of unrestricted access to a resource, private property rights in that resource will emerge if the net benefits are positive. In other words, did private property rights emerge? If not, why not? Justify your answer.