Help my Data BaseAssignment

Posted by Nuwan under Management on 11/30/2013 | Points: 10 | Views : 1595 | Status : [Member] | Replies : 5
Information Systems Assignment

Date of Submission: MondayDecember 2nd

An organisation, PlayOn Toys, has been in business for five years. It manufactures toys forthe European market, with plans to expand its customer base to America, Asia and Africa in the next three years. In the past year, it has grown very rapidly from a company of 16 employees to 60 employees. It is based in Dublin.

This year, it had a turnover of 5 million euro, with a pre-tax profit of 1.4m euro.

One of the difficulties it has experienced with such rapid growth is the inadequacy of its current IT infrastructure. At present, product, customer, sales and financial information is spread across a number of small databases, electronic files and paper files at the Dublin site.
They currently manage about 3000 sales orders per year, spread across approximately 200 customers. Their reporting and transaction requirements are highly dependent on manual processing. For example, customers can enter sales orders on the PlayOn Toys website. But at the backend, the sales information is simply emailed to one of the sales administrators who have to print it and log in a spreadsheet.

Their manufacturing operation, whilst still fairly simple, has expanded from 2 products to 20 different products over the past two years. These 20 products in turn, consist of 110 different product parts, sourced from 30 suppliers.

The Chief Executive of the company needs to assess the following:

1) Should PlayOns Toys invest in a Database Management System?
a. If not a DBMS, what is their alternative?
b. Should they consider open source?

2) Should PlayOns Toys invest in its own fully fledged Enterprise Resource Planning system (ERP)? As part of this, the CEO wants to see a high level Entity Relationship Diagram and description of one of the typical ERP functions, such as sales management or inventory control.

3) Should PlayOn Toys be looking to outsource some or all of their data management to “the cloud”?

The CEO has hired you to prepare the briefing document that the CEO will present to top management in response to the three questions above.

The document should address each of the three questions above, outlining the pros and cons of each option. When considering each option, include indicative costs and indicate possible suppliers. The document should be clearly laid out, with each of the three questions clearly considered.

As a summary, an overall recommendation should be made. The document should not exceed 6 pages (excluding appendices).

References should be included in the appendix.

The ERD plus ERD description requested for one of the ERP functions should also be included in the appendix.

This assignment contributes to 50% of the full (100%) module mark for Databases and Information Systems.

Marks will be awarded for the quality of the discussion for each of the three questions, and the extent to which the circumstances of PlayOns Toys organisation have been considered.

The marks will be separated as

Question (1) 20 marks
Question (2) 40 marks (includes ERD).
Question (3) 20 marks
Quality of overall document, references and summary recommendation: 20marks



Posted by: Mohits1 on: 6/24/2019 [Member] Starter | Points: 25

Hi nuwan you can approach third party service providers who can help you in your assignments and projects, some of them which are known to me are :

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jack38 on: 6/25/2019 [Member] Starter | Points: 25

[LINK ]characteristics of oligopoly is an important market type in which there are few firms that accounts for producing and selling a product. In simple words, it can be best described as a market situation which explains competition between the two.

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Amyralyall on: 6/26/2019 [Member] Starter | Points: 25

GotoAssignmentHelp Services is one among the best Australian Assignment Assistance which will help you out with all your academic related problems . They have a lot of professional experts who have expertise knowledge in giving you proper guidance and providing you with cheap assignment help services.

[url=]Assignment Help[/url]

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Marioc on: 7/9/2019 [Member] Starter | Points: 25

Thanks, guys, for all your answers. Works for my project

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Peachyessay on: 8/16/2019 [Member] Starter | Points: 25

I can see a lot of people are dropping link for some assignment writing companies. These people are mainly some cheap SEO link builders working for $8 a day and their job is to spam on forums and write comments. They normally provide no value. I am not unbiased as I work for an academic writing company, but not for a scammy one like above. They have mushroomed in the few last year especially in India and Pakistan.

I want to raise awareness about this industry.

Please spend a bit of time and watch a few education videos:

The Truth about Essay Writing Companies - Watch This Video Before Placing Order

Essay Writing Services Companies Honest Reviews - A MUST WATCH - Peachy Essay

As I said I work for an academic essay writing company called . Feel free to check and get in touch.

Writer, and blogger

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response