Database Design Concepts British Insurance Company Assignment

Database Design Concepts British Insurance Company - Assignment Example The second screenshot illustrates the working of the function "Add new customer". When the system admin will click on the "Add new customer", he will be redirected to this page. The page will inquire about the following details. System Admin can also upload the picture of a customer. Once all the details have been provided, the admin will click on the "save" button in order to record the details in the database. The third screenshot illustrates the working of the Product's Section. When the system administrator will click on the "Products" button located at the in the main panel, he will be redirected to the Product's Section. Here, the admin will be able to add new Products, view existing Products, make a web search to update the product's details and delete a Product. An admin will also be able to perform a Product related search in the search box provided at the bottom of the page. When the admin will click on any of the buttons, he will be redirected to the related page.  Ã‚   Screenshot 2: This Screenshot shows the working of the Product module. A manager or admin of the system can add the new product, view existing products, delete a product or make a web search to gather details for the product through the buttons on the page. A manager or admin can also make a search for any query regarding the product to make a quick search. Screenshot 3 When the admin clicks on the button "Add new customer", he will be redirected to the "Add new customer" page. The admin has to enter the mentioned details and click on the "Save" button in order to create a new customer account. Task 2A: Data Dictionary: Table Field Type Field Size Field Description Customer Text Up to 500 characters The details of the customers will be stored in the Customer table Product Memo Up To 64,000 characters The details of the customers will be stored in the Customer table Quotation Text Up to 1000 characters The quotations made by the advisors will be saved in the quotations table Advisor T ext Up to 255 characters Names of the advisors will be saved in the advisor table Task 2B: The tool used to create the ER diagram is Microsoft Visio. ER Diagram: 5 entities have been considered in the ER diagram. The product entity contains the following attributes; Description, Product No., and Name. The Database Admin entity contains the following attribute; ID Number. The Customer entity contains the following attributes; Name, reg no, age, address, contract number, date and advisor. The quotation entity contains the following attributes; reg no, client name, advisor name, estimate, and date. Similarly, the web search entity will make searches for a product from the internet in order to update the details of a product.  

Marketing managemnet Essay Example | Topics and Well Written Essays - 1500 words

Marketing managemnet - Essay Example Many companies seek success in various factors. These factors include: excellent information systems, qualified workforce, and modern technology all contribute to business success. Nevertheless, successful companies, such as Coca Cola Company, McDonald’s foods, Starbucks, and other renowned companies have had a similarity: they have a strong customer orientation programs and have heavily invested in marketing on their products and services. Marketing Management In essence, marketing consists of strategies and tactics that are used to identify, create and maintain satisfying relationships with customers that results in value increase for the companies and the customers. Successful companies dedicate efforts to sensing, serving and satisfying the needs of customers in the unique target markets. Companies like Apple have attained brand equity through constant innovation an excellent customer service. Moreover, Apple products are built on advanced communication technology and addi tional feature like email and messages capabilities, which have increased the level of customer satisfaction. Basically, the Apple Company has been able to implement technology, and innovation in all the marketing mix elements (Boone and Kurtz, 2010). Marketers should always understand that business revolves around the creation and delivery of value to customers. The customer value is said to be the variation between the customers’ value gained from owning and using the products and the cost of obtaining the products. Of importance to note is that successful marketing managements entails identifying the right market for the products and services and designing the appropriate marketing communication messages, which are tailored to the particular market and target customers (Green and Keegan, 2012). Elements of Marketing Strategy The marketing strategy of any company is composed of various elements, which interrelate. The main element is the market selection and the product pla nning, which basically involves the product line and the product offering of the target market. A company can either choose a single market strategy or multi market strategy. In single marketing strategy, the company will concentrate its efforts in servicing the single unique market segment while avoiding competition with the dominant players. In a multi marketing strategy, the company will serves several distinct markets hence the importance of carefully selecting the target markets which are viable. In a total marketing strategy, the company will offer differentiated products to different market segments; hence it should utilize the marketing variables such as price, promotion, products, as well as, the distribution strategies in competing effectively in the entire market (Haberberg and Rieple, 2008). The company should ensure that thorough scrutiny should be able to decide and take up on the best marketing strategy that ought to be used. For instance, the Apple Company has been a ble to anticipate and bear the market risks including the effective promotion of the Apple products such as iPods and phones. According to Hartline and Ferrell 2010, a company may also choose an early entry where it brings into the market a new segment after the market leaders hence the company should ensure that it uses superior marketing strategies and sufficient resources to compete with the market leader. A company could also choose a laggard entry strategy where it enters in the market through imitation of