Account Manager

Question 1

Create an entity-relationship (ER) diagram to represent a database that will help you manage the data. Your ER diagram should have the following characteristics:

•  At least 5 entities o All entities with a primary key
•  At least 3 relationships with foreign keys
•   Appropriate data types for all fields and at least 3 different data types

Paste a copy of your ER diagram into the same Word document along with a detailed explanation of the entities, relationships, and all design decisions. Create a database in Microsoft Access based on your ER diagram. Include the following:

•  Appropriate representative data for all tables and at least 5 rows per table
•  At least one form to get data into your database o At least one report to get data out of your database
•  In the same Word document, paste screenshots of your filled database tables, form, and report. 

Question 2

Background Information: You are to imagine that you are the recently appointed Account Manager and have been asked to present to your line manager a 30/60/90 day plan of how you will approach this new role in order to be successful. We are particularly interested to hear your thoughts on the following topics:

How you would grow revenue whilst maximising margin?

Who are our competitors and how do you plan to increase our market share from them?

What do customers expect from us both now and in the future?

How would you organise an Accounts base with various levels of spend into an initial visit plan

What are the current market trends /latest developments in technology that will have an impact on Premier Farnell?

-Describe your perfect/typical week in role.   Your Task You should prepare a short presentation outlining your approach to the outlined brief above. You will have a maximum of 20 mins in which to deliver your presentation, a Q & A session will follow after your presentation.