Assessment Description

This is an individual assignment. You must make a reasonable attempt at all parts to obtain a passing grade.

Objective: Construct a small commercial database and demonstrate its functionality

Identify and examine three different websites which offer an online purchasing facility. Look particularly at the interactive pages used for the purchasing function and from these lists all the fields that have to be completed by the purchaser for each site. (Note that you do not have to limit yourself to data-entry fields, for higher marks analyse the websites for other possible attributes.) From your three sets of attributes, produce one generic list.  (15%)

From this generic list, construct an Extended Entity Relationship (EER) diagram for a database that would support an on-line purchasing facility. Construct a supporting Table Schema. Explain your thinking, and any assumptions made in this process. (25%)

Using the software provided, build tables to represent the entities from the Table Schema. Invent data to represent stock for the tables created. Insert six records into each table. Provide screen dumps of all the CREATE TABLE statements and the completed tables. (10%)

Design five data retrieval queries for this database that demonstrate your skill with SQL and run them. Provide screen dumps to show each query and its output, explain for each query what it was intended to do, and how the data from the tables proves its successful operation. Demonstrate complex system queries for higher marks. (50%)

IMPORTANT: I don’t need a lot of words, I just need to complete the task

Write a Political Science Essay about the “Future of International Order” (More details about the track are given in the “Instruction” file) using the sources that I have uploaded (it’s not compulsory to use all of them, and it’s possible to use external sources relevant to the track).
Full details and guidelines are given in the “Instructions” file.

Thanks in advance that everyone who can help me.

P3 explain how focusing on the customer, by providing good customer service, is essential
to retailing

    demonstrate how retailers relate to their customers.

Note: Customer service is highly formalised and demanding in some organisations, while others have a lower standard of service.

    identify organisational customer service policies and how these are applied at an operational (store) level.

    show how different organisations require different levels of service by showing how you understand the industries  structure.

    identify the significant elements od some retail sectors After-sales service Identify aspects of aftersales sales service in some retail sectors

    Identify a range of service and quality standards through store visits.

Note: Selling skills and the sales process can be observed and experienced in a range of stores. A suitable assessment would involve a customer service survey in a sample of retailers.

Important: every care must be taken to ensure you are Covid 19 safe, e.g. wear a mask or face shield, keep a 2m distance etc. If you cannot complete the above in a safe way or in a environment, or because you are in lock down, or isolation etc. write your assignment from your own personal shopping experience and research knowledge   

M3 explain the ways in which sales techniques and customer service have developed in retail organisations.

    You  must demonstrate knowledge of the key elements of effective service and selling skills.

Note:  For example, customer expectations of luxury goods retailing are consistently high. The service dimensions can be compared with other clothing stores. Department stores provide a good opportunity to study differences in service, for example Harrods, John Lewis and Debenhams. These can be compared with multiple variety stores, typically Marks & Spencer and Bhs, and fashion specialists such as Topshop/Man. Customer service in the clothing sector can be compared with other sectors where product knowledge is valued, electrical goods,
and where convenience and efficiency is important, for example food.

You  must  define the types of changes taking place in the industry.

Note:  I.e whether they are short term or have longer-term implications.

    explain what causes these types of change by differentiating the key factors in the macro environment and the competitive environment.

Note:  Key factors and their significance are depending partly on the industry sector: planning restrictions impact more on food, DIY and electrical retailers than clothing and toiletries and cosmetics retailers. Economic trends will impact on consumer spending and have an industry-wide effect;

    explain that some retailers may be better able to withstand recessions and take advantage of growth opportunities.

    Competitive trends should be explained with reference to market concentration, power of multiple retailers, low barriers to entry, and innovative practices, including new types of store, refits and introduction of new products and services, including online provision.

D2 assess the impact of different sales techniques and customer service in a selected organisation.

    demonstrate an ability to make judgements about the most significant elements of service and selling skills in the industry, and the ways in which they are sustained.

    You should think creatively about new service solutions that can realistically evolve from current practices.

P4 identify the competitive factors in the retail environment a selected organisation faces.

Note: You will need to understand competitive factors in the retailing environment that drive change in the industry.
    identify aspects of government policy concerning planning guidance for new store locations, specifically the influence of Planning Policy Statements.

    Write what you know on how the Competition Commission engages with the industry and, more broadly, how retailers costs and ways of working may be determined by government policy.

    Also write about your studies of other competitive forces and include, market position, barriers to entry and new retailing concepts.

    Discuss  contrasting stores and their use of ICT to drive change and the application of ICT in marketing and stock management.

Note: Social and demographic trends can be evidenced through store-based customer surveys and/or observations. Broader economic trends can be tied into a study of the current performance of the industry as reported in the press.

    Study a shopping location and explain high street or shopping centre, in the context of the retail industry structure.

    Identify Innovative products and services in one retailer and further explain the role of these products and services in creating a dynamic industry.

    Bare in mind an innovative retailer and the ways in which it adapted to its environment and how it uses change factors to drive its business.

product: electric bicycle similar like the e-scooter

Individual project, each student will be assigned a different brand- product. you may consider their brand from a global perspective or from their own
countrys perspective.

Each question should be clearly identified as a headline and answered as a separate
section of the paper.

Questions:

You need to prepare a new launch for your brand (remember it has to be based on customer needs), Develop and explain the steps of New Product
Development.

Describe the strategic decisions that you will apply to the marketing mix.
o Product
o Distribution
o Price
o Communication (IMC)

the outcomes of this should include:
Demonstrate understanding of the principles of Marketing and their applicability.
Understand the processes of interaction between key stakeholders in the domain of Marketing.
Identify and analyze the major forces in the marketing that impact business operations.
Illustrate the impact of effective marketing programs and marketing plans

Your dissertation should be presented in a clearly legible font (such as Arial or Times New Roman) in 12pt and have 1.5 line spacing.
All pages need to be consecutively numbered.
Headings need to be clearly distinguished, you may wish to start each chapter on a new page, and you may want to consider numbering headings prefixed with the chapter number. Subheadings may also be numbered (e.g. 4.2, 4.2.1).
All figures and tables should be prefixed with the chapter number and the numbering should be restarted for each chapter.
Images may be used subject to appropriate permissions/acknowledgement of sources.

thesis/dissertation chapter

my school follows the Harvard referencing guide. attached below.

I have attached an example revenue management from a previous essay on another term.

my task is to write a section based on revenue management techniques. based on the interview and using secondary sources in example. do not copy or plagiarism.

Here is the interview we did on a restaurant named Lift located in Atyrau in Kazhastan.

1) Each food/dish offer in the menu is calculated  to a grammage of each ingredient. Then we get a net cost of a dish. The selling price in average is a net cost increased by 200% to 300%. This added value includes all expenses like cooker and waiter salary + depreciation of equipment.
3)  Part of everyday revenue goes for procurement of everyday used products of kitchen and bar and for other needed stuff.
4)  Since we are considered as a small-sized business the tax is 3%
5)  Since we just closed our first year of operation there is only 1 fixes annual expense info (63.000.000 KZT). Profit is a confidential info.
6) Difference in revenue for a restaurant and bar depends on a period of a month and number of holiday on each month. Usually revenue decreases in the end of  a month cause people run out of money and they wait for a salary.
7) Its occupied for 60% on weekdays and over-occupied on weekends.
8) Special offers are only personal discount cards for our regular guests.
9) Majority of guests are mainly locals. And around 20% are expats who work in Kazakhstan.

choose an MNE based in the UAE and investigate a problem the company is
facing that is connected with the list of topics covered in the lectures. you need to describe the problem, investigate its causes, and suggest recommendations for its solution based on appropriately identified academic literature.

topics that may help you in this essay

Ethics and Corporate Social Responsibility
Knowledge Transfer & Innovation
Parent and Subsidiary Management
International HRM
Emerging Market Institutions
Emerging Market MNEs
Impact of Political Environment on IB
Managing Resiliencein times of crisis

First, choose a car manufacturer that you want to analyse. Based on thorough research, present a critical analysis of the strategic public relations position of your chosen company, including the PR strategies/approaches it is employing. In your analysis you are likely to consider the companys mission, vision, corporate identity and image, its Corporate Social Responsibility activities and policies, its social media strategies, and any issues (or crisis) that the company has been facing, and any other communications activities the company has been engaged in and have had an impact on its reputation.  (This part should be about 80% of the entire essay.)
Next, based on the above analysis provide recommendations about how the companys management should address some of the issues identified in the first part. Recommendations should be specific, avoiding generalizations, and justified. You should devote to this part about 20% of the essay.

This is photographic essay meaning that up to 8 images will be used to discuss and link to the academic argument about social construction of childhood. 2000 words but the word count im paying for is fine.
Images can be from the internet or a website museum of childhood catalogue with images based on childhood.
Images must link to the argument that childhood is a social construction.
The layout I could like is the image copied into word and the writing next to it.
Also pictures used must be referenced. All references must be Harvard style.
There must be a good use of academic reading (concepts and theories)
The essay should be critically examining social construction of childhood.
Ive included the outcomes and marking critter is in the attachments below.
If you have any questions please feel free to ask me
*lecture 5 isnt there because it was study week*

    Learning Outcome 1 – Critique the range of family and childcare social work settings and roles in Northern Ireland, including child protection, looked after children, family support, fostering and adoption, this will include the statutory duties in social services.

    Learning Outcome 2 – Effectively apply legislation and policy related to social work and serious case reviews.

    Learning Outcome 3- Understand and synthesise the concept of child abuse, including  definitions, signs and indicators, and key research messages in respect of sexual abuse, neglect, emotional abuse and physical abuse.

    Learning Outcome 4 – Apply family and childcare safeguarding practice across practice settings.

    Learning Outcome 5- Adhere to social work ethics and values in line with professional standards