Friday, May 24, 2019

History of Carphone Warehouse plc Essay

The Carphone Ware domicile free radical plc also known as The Carphone Ware base (or The telephony House in the rest of Europe), is Europes largest independent mobile phone retailer, with 2144 retail ancestrys across Europe. They sell both contract mobile phones and pay as you go mobile phones and now tablets, such(prenominal)(prenominal) as the iPad and Samsung Galaxy Tab and also E-Readers. The head office of The Carphone Warehouse Group plc is based in London, United Kingdom.At the current moment in time, The Carphone Warehouse is doing an upgrade in most of the retail stores. They are changing the products they sell, to include Laptops and Game Consoles however these products are still available at separate stores but only with contract phones and non to pay outright. These in the altogether stores are called Wireless stores as they are meant to represent the future of the home with wireless applied science such as the Sonos music system.There are currently only 20 of the se stores in the UK and Milton Keynes is one of the 20 stores. In each Wireless store there is a 3rd party company called Geek Squad, which in the UK is half owned by CPW plc, which is technical support and insurance used by The Carphone Warehouse and Best Buy UK.Ethos, House Style and Existing PublicationsThe Philosophy of Carphone Warehouse isAs a new generation retailer, we aim to exceed our guests expectations by providing an innovative approach to service. To stay at the front of this dynamic and rapidly moving industry, we constantly develop new ideas and services for our clients. These do not always come from the top and we rely on people throughout the business to maintain our high standards. By incorporating new ideas in sell and new technologies, we incur created a stimulating and rewarding environment for all of our employees.The ethos of The Carphone Warehouse is to provide a friendly customer servicewhile meeting the technical needs of the customer in regards to mob ile phones, tablets and laptops. This is done through the employees of the company who are all friendly and have been on an extensive customer service training course for two days either in London, UK or Preston, UK.The Carphone Warehouse uses galore(postnominal) different ways to communicate to the general earth and their staff. The main way in regards with its customers is in the monthly magazines. The company also sends out a report to the shareholders every 6 months and an end of year fiscal report every year. Also everyone who full treatment in the company has a business mailing which is personalized to them while meeting the companys house dah.The monthly magazines are A4 sizing and consist of 36 foliates. In the magazines the logo is always at the top left corner of the page with the date in the opposite side. On the bottom of most of the pages have the phone number and website, so the customer locoweed find it easily and quickly and also the page number in the same si ze and text font.Most of the other documents, like letters and business cards have the Carphone Warehouse logo in the top right corner of the page. On the top left corner of the page is the Queens Coat of Arms. The rachisground of the logo is a ignominious Blue which the colour code red 11, green 40 and blue 80. The light blue underline is made from red 121, green 209 and blue 206. The exsanguinous text is made from red, green and blue at 255. The sizes of the business cards are the same size as a credit/debit card so that they fit into a person wallet easily. On the back of the business cards is writing saying the 5 fundamental rules of Carphone Warehouse Group plc. This is how things should be done at Carphone Warehouse and every employee MUST stick to the rules.However in the current informationbase, the house is nonexistent as the house style used in the database doesnt match the rest of the companys house style. exploiter RequirementsBackgroundThe current problem with Carp hone Warehouses database is that the functions the database can do has been changed so much that old functions are still on the database but do nothing. Another problem with the current database is that the system is often retard due to the fact that the computer has to load function that does not work anymore.Because the database was built over several years, not all parts of the system works together, so the user of the database has to copy data from one database to another which can take time.Expected Outcomes/ Aims and ObjectivesThe expected outcomes from the new database is to be able to keep a record of all the customers at Carphone Warehouse with the handsets bought and the member of staff who sold the product. This result modify managers to see which member of staff has been selling the most gist of phones on which network.The data can be entered manually with a noticeboard or a barcode watchner which will save time on entering the IMEI and ESN poem as these numbers t end to be 16 and 19 digits long. The keyboard will also need to be used to enter other key reading such as the customers details and the customer consultants name. This data input is necessary to be able to capture the information needed by The Carphone Warehouse, which is needed for manufactures warranty.Security is a big part for any database especially in retail and with dealing with such high personal information. To be able to access any part of the database the employee would need to log onto the system with their username and password. Every member of retail staff would be able view, add and amend each customer record to ensure that the company complies with the information Protection Act (DPA). Managers would have a higher aim of access as they would be able to add or re break down lost/ stolen products from each stores stock list.To help improve the companys performance, the data base will need to be able to print out internal reports about each store and each customer c onsultant. This will enable managers to see what phones they have been selling and which sales assistant has been selling the most phones. Also the database will need to make invoices for the customers to keep as their record of their purchase.User Interface RequirementsThe user interface of the current database has a dark blue background with a light blue for popup menus. All text shown on the database is shown in Calibri with key information in yellow and other text shown in the light blue.This user interface of the new database needs to be updated and kept with the house style of the company, as the current database (shown in the image to the right0 does not comply with this style. From just looking at the current datbase, it is not clear that the database is for The Carphone Warehouse as there is no logos shown anywhere. The new database would contain the company logo and colours in keeping with the house style of the company.Currently the way to move around the database is to u se the function keys on a special keyboard produced for the company where instead of the standard 12 funcations where is 24 function keys. Each function key will do a different task within the database, and as the name of the keys are rubbed away it become sdifficult to remember which key does what, therefore the new database will not have to use of the function keys but instead use buttogoogns on screen where the user will click the button which the reversal or for future developments, the buttons could also be clicked via a touch screen monitor.HardwareFor the database to run on the computers used by The Carphone Warehouse, the computers will need to have the minimum specification of the following Processor needs to run at 500 MHz or higherRAM 256MB or higher,Hard magnetic disk Drive ((HDD) Storage) 2GBs or higher. As the database is usedmore and more, the HDD will need to be increased to be able to store the growing in size database. Monitor display resolution of 1024 768Opera ting System (OS) Windows XP or higherAlso the computer monitor could be a touch screen this will increase the speed of which the user moves around the database. Also needed is a plotter printer, to print out customers invoices. The reason for this printer and not a laser printer is because a cheap black and white printer is used just for printing out invoices and nothing more. In the back office a colour printer could be used to print out reports for the managers of the store. Employees will also need a handheld scanner to scan product barcodes such as IMEIs from the phones.Entity family diagramThis is the most basic form of an Entity Relationship Diagram showing that some(prenominal) customers can sully many phones and the same phone model can be bought by many customers.This Entity Relationship Diagram shows that each customer can have many transactions and each phone model can be in many transactions. However this does not allow a transaction to have many phones.After some ti me of thing of changing tables, I believe this would be the best system to record all transactional data including the employee who has sold the product.This Entity Relationship Diagram shows what I want the new database to hold data about. This shows that many customers, employees, phone models and sim cards can be in many transactions. This Entity Relationship Diagram is in its simple form. The actual database will also include a temporary Customers table where customers details are enter in the temporary table first before being moved to the customers table. Phones will also be broken into two different tables the first table will be for the IMEIs of the phones andthe second will be for the Phone Model. This also applies to the Sim Card table, where there will be a table for the ESN and one for the Networks.DesignDesign of inputsData Dictionary and NormalisationsDatabase Keyis Primary Keyis Foreign KeyField NameData TypeFormatDescription of the FieldField LengthValidation CheckF ield Required Table Name tbl_Transaction / tbl_TransactiontempTransaction figure of speech Auto NumberIntegerNumber if the transactionN/APresence CheckY Lead Number NumberIntegerCustomer numberN/AYes against in Customer table, Presence CheckY Staff Username TextN/AEmployee who sold item8Yes against in Employee table, Presence CheckY Phone ID TextN/AMake and model of phone15Yes against in Phone table, Presence CheckY IMEI NumberIntegerSerial number of the phone16Yes against in Phone table, Presence CheckY ESN NumberIntegerSerial number of the sim card16Yes against in SimCard TableY Payment ReceivedCurrencyCurrencyAmount paidN/AFormat check, Presence CheckY Payment TypeTextLLLLPayment type Cash or Card4Format check, Presence CheckY DateDate/ TimeXX/XX/XXDate of purchase8Presence CheckY TimeDate/TimeXXXXTime of purchaseN/AYField NameData TypeFormat / Input maskDescription of the FieldField LengthValidation CheckField Required Table Name tbl_Customer / tbl_Customertemp( means continue until reach length of field)Lead Number Auto Number(Number tbl_Customer)IntegerCustomer numberN/APresence Check, Y TitleTextL

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.