Premium Essay

Retail Store Database

In: Computers and Technology

Submitted By bMoore906
Words 1683
Pages 7
Fundamentals of Database Systems
Individual Project: Retail Store Database

Table of Contents Section 1: Project Outline 3 Project Overview 3 Section 2: Description of the Database Design Life Cycle 4 Database Design Life Cycle 4 Database Creation 7 Section 3: The Entity Relationship Diagram 9 TBD 9 Section 4: The Logical Model and Normalization 10 TBD 10 Section 5: The Microsoft Access Database 11 TBD 11 Section 6: The Microsoft Access Database Application 12 TBD 12 References 13

Section 1: Project Outline
Project Overview
This project will go over the process of designing a database. The database that will be designed will be a database for a typical retail store. The purpose of this database will be to manage and store the data produced or collected during normal day to day operations. Throughout the rest of this project the information and processes will be aimed toward the creation of this retail store database. This is to help provide an example of what is needed to create a database and how each process or step corresponds to each other.

Section 2: Description of the Database Design Life Cycle
Database Design Life Cycle
In order to create a database you must understand that there are certain steps that are contained within the Database Design Life Cycle (DBLC). These seven steps help you design the database and they give a step by step process to guide you through the phases of development. These steps are listed as follows: 1. Defining a mission statement and mission objectives 2. Analyzing the current database 3. Creating the data structures 4. Determining and establishing table relationships 5. Determining and defining business rules 6. Determining and defining views 7. Reviewing data integrity
The first step in the DBLC is to define a mission statement and the mission objectives. The…...

Similar Documents

Premium Essay


...1. Title of the paper “Impact of Multi Brand Foreign Direct Investment in Retail Sector in India (Before the approval)” 2. Author Name – Prof. Nikhil Polke 3. Theme – Retail 4. Institute Name & Address Tirpude Institute of Management Education 1, Balasaheb Tirpude Marg, Civil Lines, Sadar, NAGPUR – 440 001 5. Email – 6. Contact number - +91 99233 80707 Abstract India has been placed at first position in the category of countries with the best opportunity for investment in the Retail Sector by a survey of A.T. Kearney’s 2005 on Global Retail Development. The increasing disposable incomes among the Indian middle class and increasing young population have been cited as the main reasons for such attractive optimism. This positive opinion of the experts has also encouraged the intense lobbying by certain sections for opening Foreign Direct Investment in this sector. Foreign investors are also very enthusiastic to invest in India’s Retail Sector. At present India does not allow FDI in multi-brand retail but permits upto 51 percent in single brand retail and 100 percent in cash and carry wholesale trading. There is a ban on FDI in big multi-brand retail stores but there is no restriction on companies accessing the foreign equity market through the American and Global Depository Receipts. The Government of India opened up FDI in ‘Single Brand Retailing’ in the year 2006. This was done with a primary motive of giving a boost...

Words: 4792 - Pages: 20

Premium Essay

How to Smaller Store Should Compete with Bigger Retail Stores

...How to compete with a retail box store A competetor analyis would have to be done first. There is almost no way a small hardware store could ever compete with big retail selling the same items. Most big retail stores buy bulk so that that may sell at a lower price. Small hardware stores can not keep that much inventory alone in their stores. So seeing what your competetor and you share as far as price point on the items the small store carries would be essential. He would be wise to avoid as much direct competetion as possible. I would recommend is to carry better brands than whats at the big retail chanis. Lowe’s and Home Depot do not carry what most people think of as a “quality tool“. By stocking your shelfs with items such as speciality tools that the retail chains may not have in stock often and tools of better quaility than the box chains cheaper, but easily more disposable product you can earn a name as being a more reliable hardware store where you can buy tools that last.   He may have to restructre his business but this could be his new target market. Opening up a online store could prove beneficial. He can now house inventory through a distributer but not store it in his buildings. People will still associate his good name with the online store. Just as important he should be marketing his standing in his own community. The store should be marketing its years in the business community, If it donates to charity work or helps the local sports team it......

Words: 510 - Pages: 3

Premium Essay

Dixons Stores Retail Group

...DSGi (formerly called Dixons Stores Retail Group plc) is one of Europe’s leading electrical retailing groups with 1,200 stores and online stores. It is represented in 28 counties and has over 40,000 staff (DSGi n.d.). The company has brands such as PC World, Currys and to name a few. In year 2009/10 the company had-pre tax profits of £133.2m (DSGi 2010). Strategic decisions are made by directors in the company with the support of shareholders. Strategic decisions are a long term plan that determines what the business will do as a whole. An example for DSGi would be their “five-year plan to transform the business” (Baker 2010). This plan involves a concentration on brand identify rather than just price promotions, in relation to marketing. The idea with this plan is to set them apart from rivals such as Comet who use price promotions as their main marketing focus. Tactical decisions are used in order to achieve the overall strategic decision and focus on how it will be done. These will be made by department directors and heads of departments. One way DSGi have done this is to try increase customer service. Another example for DSGi which Niall O’Keeffe, DSGi marketing director made, is the recent advertising campaign which featured Star Wars characters, R2-D2 and C-3PO, which was focused to highlight the dual branded Currys and PC World megastores, which have recently undergone a reformatting part of the strategic plan to raise the brands identity (Baker 2010)...

Words: 1767 - Pages: 8

Premium Essay

Your Retail Store and Business Cards

...Your Retail Store and Business cards, Perfect Together! When should you hand out your business card? When every opportunity presents itself! Your business cards....they're neat, cool looking and trendy...but if they are packed away in a will customers or future visitors to your store ever know about your business? Don't just plunk down a bunch of business cards in a holder on your sales counter and expect them to magically jump into your customers wallet! You know what, business cards aren't trained to do back flips and high dives into wallets and purses! For every person who may walk into your business, greet them and present them with your business card. Don't ask them if they would like your card, GIVE it to them! Whether they make a purchase or not that day..your business card presented to them personally will remind them of the nice individual that gave them that card and serve as a powerful reminder of the pleasant experience in your store. Business cards are your most powerful marketing and advertising tool,yet it often goes unnoticed in favor of high price marketing and advertising campaigns, such as The Yellow Pages and Internet Advertising. View your business cards as gigantic advertising Billboards. The more people that see your card, the more the odds are in your favor of people coming to your store. Aside from personally handing out your business card to every visitor that walks into your your business card into all your......

Words: 335 - Pages: 2

Premium Essay


...The current issue and full text archive of this journal is available at IJLM 22,3 Retail supply chain management: key priorities and practices Wesley S. Randall Department of Marketing and Logistics, College of Business, University of North Texas, Denton, Texas, USA 390 Brian J. Gibson and C. Clifford Defee Department of Supply Chain Management, College of Business, Auburn University, Auburn, Alabama, USA, and Brent D. Williams Department of Supply Chain Management, Sam M. Walton College of Business, University of Arkansas, Fayetteville, Arkansas, USA Abstract Purpose – The purpose of this paper is to investigate the unique supply chain strategies employed by retailers. Design/methodology/approach – A mixed methods approach was employed involving analysis of depth interviews with 27 retail supply chain executives combined with a follow-up survey capturing over 200 responses. Findings – In light of uncertain economic conditions, retailers appear to be developing more agile/responsive supply chain management (SCM) strategies. Additionally, retailers are putting greater emphasis on maintaining a balance of cost versus service than the cost-centered focus found in a prior study. Research limitations/implications – This study focused on US retailers and therefore results should be cautiously extended to the retailing environment in other countries. Practical implications – Retailing is not a “one size fits all” business, and...

Words: 5824 - Pages: 24

Premium Essay

Porter's Six Forces Analysis General Retail: Merchandise/Department Stores

...February 25, 2010 Assignment 2 Porter’s Six Forces Analysis General Retail: Merchandise/Department Stores Prepared by: Yulia Petukhova ID# A30 The department store industry will be analyzed taking department stores as players, individual consumers as buyers, and manufacturers and distributors as the key suppliers. The Rivalry among existing firms High The period from the end of the 20th century up until now has been marked by the consolidation trend in the department store industry, characterized by major acquisitions by a few larger, powerful competitors, greatly intensifying the rivalry among them.9, 13 Since there are only a few of them in the industry, they tend to match each other’s steps in some way or another. After JC Penny introduced itself to Manhattan just a block away from Macy’s, it is only a matter of short time before Kohl’s will finally announce its move into Manhattan as well.10 Slowdown in the industry growth coupled with reduced consumer spending and low switching costs intensifies rivalry even further prompting the market players to differentiate their products by introducing exclusive brands and increasing innovation.3, 15, 17, 19, JC Penny contracted Cindy Crawford to extend her jewelry brand exclusively at their stores, while Macy’s has signed a strategic alliance agreement to become an exclusive retailer of Ellen Tracy branded women’s sportswear in spring......

Words: 2385 - Pages: 10

Premium Essay

Retail Store Analysis of Sony Center

...Assignment on Retail Visit to SONY CENTER-Green Park Market. Submitted to: Prof. Sujit Sengupta Group Members Tuhina Bhattacharya Veronica S. Gomes Mukul Gola Rajeev Kumar Radheev Kumar PREFACE We were given an assignment on a retail visit where we had to find out in details about the merchandise, store layout, signage and profitability of any particular retail store. Since we had been to SONY CENTER at South Extension for a previous assignment, we decided to repeat our visit to SONY itself but at some other destination. This time we visited SONY CENTER located at the Green Park Market. Our interaction with the manager was brief as he did not much entertain us. Neither did he want to disclose much about his store, evaluation methods used, store management and so on. Major parts of the report are thus based on our observations and assessment of the store layout, look and feel. Following are the answers to the questions put up. 1. In general, are the store layout, design, and visual merchandising techniques used consistent with the exterior of the store and layout? The store has a Carpet Area of approximately 700 square feet. Since the area is comparatively less than other SONY CENTERS, additional spaces have been created intelligently by utilizing walls and fixtures. The store has a Straight Floor Layout. Figure 1.1 below shows a Straight Floor Layout. Fig. 1.1 Straight Floor Layout. There is a good......

Words: 1262 - Pages: 6

Premium Essay

Mkt-646 Retail Store Paper

...Retail Store Paper MKT-646 July 01, 2013 Retail Store Paper Marketing and branding are critical success factors for most companies. Although most people associate branding with retail products sold directly to consumers it is also very important to any subgroups, resellers or distributors that could sustain a loss in profits and reputation if the brand gains a negative image. In order for a business to be successful it must ensure that it is reaching the right audience and that the audience visiting the store perceives the products and information that the store is offering in a way that will turn eyeballs into sales (Bronnenberg & Mela, 2004). Staples is a good example for observation to determine what the office supply store does to convey their message to the right demographic and what adjustments could support futuristic goals for more excellent outcomes. Staples grasp on marketing and branding has helped the supply store gain the sustainable success presently held and will help the company to expand. So, this will only work if the company can focus on the changing atmosphere for business professionals and the consumers who frequently visit the location. All aspects of business are important when working to reach a certain demographic and when trying to convey a certain message to a desired audience. The wrong use of lighting, space, displays, etc. can contribute to visitors choosing not to purchase specific items from the......

Words: 992 - Pages: 4

Premium Essay

Audit of Different Retail Stores.

...Introduction: In this phase we have to arrange the data for three different stores which we have selected for our final project of retail. We have to analyze all those factors which are important to understand while we as marketers visits to any store for any purchase purpose and to determine the availability of all those things which works as the eye catching view and leads customer to purchase from that particular store. Saddique departmental store Saddique department store is located in Zahid Colony near dhula chunk. This is one of the oldest shops which started its business in 1999. Then they expand in 2010 into a large retail store have the 2 shops and various warehouse near the store where they store all that martial which consume more space like the bags of flour and rice. Their target consumers for that particular store are all those households near there shop which include the Kashmir road, colony, calimaxabad and its surroundings. They started their business with the purpose to reduce the efforts of the households by providing their products near to them and they are tended to charge the minimum margin on their products while they are serving both types of customers. One who purchase on the bulk and the 2nd category is for those individuals who purchase for in minimum quantity. Selected Product: A We have selected two products in FMCG’s sector which Colgate and Close-up. We have going to do a complete audit of these two products on the mentioned shops on the......

Words: 3723 - Pages: 15

Premium Essay

Srs on Retail Store

...E-Store Project Software Requirements Specification Version Revision History |Date |Version |Description |Author | | | |SRS 1.0 |Group-1 | | | |SRS 2.0 |Group-1 | | | |SRS 3.0 |Group-1 | | | |SRS 4.0 |Group-1 | Table of Contents 1. Introduction 5 1.1 Purpose 5 1.2 Scope 5 1.3 Definitions, Acronyms, and Abbreviations 6 1.4 References 6 1.5 Overview 6 2. Overall Description 6 3. Specific Requirements 7 3.1 Functionality 7 3.1.1 Sell Configured to Ordered Products. 7 3.1.2 Provide comprehensive product details. 7 3.1.3 Detailed product Categorizations 7 3.1.4 Provide Search facility. 7 3.1.5 Maintain customer profile. 8 3.1.6 Provide personalized profile 8 3.1.7 Provide Customer Support. 8 3.1.8 Email confirmation. 9 3.1.9 Detailed invoice for customer. 9 3.1.10 Provide shopping cart facility. 9 3.1.11 Provide multiple......

Words: 2870 - Pages: 12

Premium Essay

Retail Store Observation

...I visit a big shopping mall of my area and what I noticed there is their interesting promotional activity. The first Floor of the store was for the beauty products. There was very interesting beauty products promotional activity that I notice and I impressed a lot. What I see that there are multiple brands of beauty products available in store and every brand has their own promotional girl who applies the beauty and makeup products on customers face or give them an opportunity for trial at their own. This helps the customers to make the decision of buying those products from which they feel satisfied. Such type o marketing strategy is known as experiential marketing (Schmitt, 2000) This promotional activity benefits the retailor in many ways. It helps retailors to boost the sale. It also assist the retailors to satisfy the customers as well as it increase the percentage of loyalty of customers. It is because customers always like to test those beauty products that they tried once. It helps customers to decide about their desired products. And in future customers always like shopping in such retail store who adopts experiential marketing strategy for the sale of products. In other point of view it helps retailer to decide which products are demanded most by the customers. There are few other stores who are using experiential marketing for the sale of beauty products. Experiential marketing is very useful way to boost the sale level. It is good way to enhance customer’s......

Words: 341 - Pages: 2

Premium Essay

Duties and Responsibilities of a Retail Store Manager vital to the smooth operation of the store. The first main duty of a retail store manager is overseeing the hiring, firing and maintaining of personnel. These individuals are ones who make the store a success and it takes a strong manager to ensure that the perfect individuals are hired to fill salesassociate positions, clerical positions and other important job titles. In addition to these tasks, the retail store manager must see to it that each individual is adequately trained to fill their job title and supervise the work that they do throughout their employment at the store. Another important duty and/or responsibility of the retail store manager deals with the money that comes into the store and goes back out as well. The retail store manager is responsible for handling the turning in of cash at the end of each sales associate’s day and is required to ensure that all the money is accounted for in the end. In addition, a retail store manager is usually responsible for paying the employees and ensuring that the paychecks match the hours worked by each individual. Meticulous records are needed to be kept by the retail store manager to ensure that all money which has come into the store is accounted for and sales associates and other store employees are paid as they should be. Inventory is another responsibility of a retail store manager. Since there needs to be goods in stock to sell, it is imperative that the retail store manager check the inventory on a......

Words: 600 - Pages: 3

Premium Essay

Discuss the Differences Between Adopting the Conventional Wholesale Retail Approach of Opening Stores Versus the Direct Selling Approach

...conventional wholesale retail Approach of opening stores versus the direct selling approach. In direct selling, the selling process of products and services involves person-to-person. This takes place in people instead of using another means such as the internet or catalogs. Generally, direct selling is different from the other selling processes in that, it moves the selling floor to the customers instead of making the customer to go to a particular location to make purchases. On the other side wholesale retailing differs from direct selling in that, selling takes place in a specific location and consumers must go to that location to buy products and enjoy the services. In other words, the store has a specific physical location and consumers have to move to the store to make purchases. What are the issues of cost, control and commitment involved for each Approach? In direct selling, there are no much costs since it involves footwork of the consumer in finding another customer to buy the goods. It is less costly in that there is no need of physical location for the seller. The control and commitment of direct selling is dependent on the particular seller or consumer who wants to make sales. In direct selling the salesman can make sales depending on the ability to convince other people to purchase. On the other side, the cost of wholesale retailing is higher because selling is done in physical location where by they have to pay rent. The costs of setting the store are high......

Words: 729 - Pages: 3

Premium Essay

World - Wireless Device Retail Store

...World - Wireless Device Retail Store Budget Proposal For [2011 to 2014/15] BUSN-278 [Term] Professor[name] DeVry University Table of Contents |Section |Title |Subsection |Title |Page Number | |1.0 |Executive summary | | |3 | |2.0 |Sales Forecast | | |4 | | | |2.1 |Sales Forecast |4 | | | |2.2 |Methods and Assumptions |5 | |3.0 |Capital Expenditure Budget | | |5 | |4.0 |Investment Analysis | | |6 | | | |4.1 |Cash flows |6, 7 | | | |4.2 |NPV Analysis ...

Words: 1923 - Pages: 8

Premium Essay

Choosing a Retail Store

...requirements for the award of the Degree of MASTERS IN BUSINESS ADMINISTRATION Submitted by: ANUJA BHEKANE MBA (ENTREPRENEURSHIP) Roll No.10117 Research Guide: Dr. Rashmi Gopinathan Department of Business Management Padmashree Dr. D.Y. Patil University CBD Belapur, Navi Mumbai PENETRATING FOR THIS THE FIRST STAGE OF RETAIL OUTLET DECLARATION I hereby declare that the dissertation “Choosing a retail outlet in Andheri west for all types of gender’s wear in andheri west and all factor to be taken into consideration for the retail outlet to make a successful for all age” submitted for the MBA Degree at Padmashree Dr. D.Y.Patil University’s Department of Business Management is my original work and the dissertation has not formed the basis for the award of any degree, associate ship, fellowship or any other similar titles. Place: Mumbai Date: Signature of the Student CERTIFICATE This is to certify that the dissertation entitled “Choosing a retail outlet in Andheri west for all types of gender’s wear in andheri west and all types factor to taken into consideration for the retail outlet to make a successful for all age”is the bona fide research work carried out by Ms. Anuja Bhekane student of MBA, at Padmashree Dr. D.Y. Patil University’s Department of Business Management during the year 2010 - 2012, in partial fulfillment of the requirements for the award of the Degree of Master in Business Management......

Words: 21282 - Pages: 86