Database Design Essay

633 words - 3 pages

Database Design and how it is used at Wal-Mart
Benjamin Stites
DBM/380
7/2/2012
University of Phoenix.

What is a Database System?

A database system consists of four components which are the users, the database application, the database management system, and the database itself. We will describe all four components briefly.

Database: The database allows a business to store important data using a collection of related tables and other structures.
Database Management System: A database management system is a computer program that is used to create, process, and administer the database. (Kroenke & Auer, 2010)
Database Application: A database application is a set of one or more computer programs that serves as an intermediary between the user and the database. They read and or modify database data by sending SQL statements to the database.
User: The user is the fourth component of the database ...view middle of the document...

By outsourcing to NCR it allowed Wal-Mart to store more information on customer needs and enables Wal-Mart to keep track of employees and inventory stock. The database for online ordering stores the customers address, order numbers, order date, and amount ordered by the customer. (Wallack, 2009)

Type of Database Architecture Wal-Mart Uses

Wal-Mart’s software is provided by Teradata and Wal-Mart also used NCR’s Teradata Relational Database System alongside its Oracle based architecture database. This has allowed Wal-Mart to know what their customers wants and needs are, and how many of a certain item sales each month. The database then creates an order form or automatically orders the item base on supplies. Wal-Mart was also the first to adopt the RFID data management system. The RFID system allows Wal-Mart to keep track of products when they are shipped to each store.

Conclusion:

By outsourcing to NCR in 1997 and by being the first to adopt the RFID System Wal-Mart has become the largest retailer in the world. Wal-Mart being motivated by giving customers what they want and need made decisions that change the business landscape forever. When it comes to relational database usage Wal-Mart became too big to handle all the information on their own so they outsourced to NCR to help manage the situation. By also adopting the RFID System when it became cheaper to do so Wal-Mart was able to handle their shipping data more effectively. This allowed Wal-Mart to become the first company to use a database in such a way that it made Wal-Mart the richest retailer in the world.

References
Kroenke, D. M., & Auer, D. J. (2010). Database Concepts (4th ed.). Uppersaddle River, NJ: Prentice Hall.
McKnight, W. (01/30/2007). RFID DAtabase Management Systems Architecture for Retailers. Retrieved from http://b-eye-network.com/view/3871
Schuman, E. (10/13/2004). At Wal-Mart, Worlds Largest Retail Datat Warehouse Gets Even Larger. Retrieved from http://www.eweek.com/c/a/Enterprises-Applicatons/At-WalMart-Largest-Retail-Warhouse-Gets-Even-Larger/
Wallack, B. (2009,April). Team Five Presentation. Retrieved from http://walmart.blogspot.com

Other Papers Like Database Design

Miss Essay

331 words - 2 pages Date: TO WHOM SO EVER IT MAY CONCERN He was employed in the said position from dates of dd/mm/yyyy and dd/mm/yyyy. He had worked 40 hours per week and his annual salary was xxxx per annum. Besides salary, he also had other benefits like performance bonus, house rent allowances, transport allowances and medical insurance. His Responsibilities were as follows * Database Analysis and Design

Normalization Essay

1733 words - 7 pages Normalization of Database Tables l 4 4 4 Introduction to Normalization of Database Tables Normalization of Database Tables ISM 602 Dr. Hamid Nemati Introduction to Normalization of Database Tables 4 4 4 Objectives The idea of Dependencies of Attributes Normalization and Database Design Understand concepts of normalization (Higher-Level Normal Forms) Learn how to normalize tables Understand normalization and database design

Strategic Hr

576 words - 3 pages Unit 10: Strategic Human Recourses Management Unit code: H/601/1991 QCF Level 5: BTEC Higher National Credit value: 15 Aims Knowledge and Skills needed to understand: * Design * Query and * Implement database systems. Unit abstract An understanding of: * Database tools and * Database technologies * Database * Complex data structures and interface Databases provide the infrastructure to many

Database 6th Ch1 and Ch2

1287 words - 6 pages database is called the database schema, which is specified during database design and is not expected to change frequently but data base state is the data in the database at a particular moment in time. 2.4. Describe the three-schema architecture. Why do we need mappings between schema levels? How do different schema definition languages support this architecture? Answer Three-schema architecture is internal schema, conceptual schema and external

Management Information Systems: Managing the Digital Firm

597 words - 3 pages MBA635 – ELP ASSIGNMENT – WEEK 01 Avinash Shankar Coleman University Database Integration – A framework The Physical Database Design depicts the actual structure of a set of relational tables specific to the platform and Database Management Systems (DBMS) on which the database is implemented. It is used to transition a logical data design into a physical database design that can be used to generate Data Definition Language (DDL

Assignment 3: Understanding the Basics of Databases

945 words - 4 pages databases. The conceptual model focuses on what data is required and how it should be organized - what tables should exist, and the connections between them. In this phase entities are recognized, and the relationships between them. The conceptual model is then translated into a logical data model. The logical database model is when the table columns in each table are explicitly defined. “Logical database design develops a conceptual model of the

Database Administration

2063 words - 9 pages DATABASE DESIGN AND THE IMPORTANCE OF DESIGNING A FUNCTIONAL PROCESS CIS475 Instructor: IBRAHIM ELHAG, PhD 3/6/2012 DATABASE DESIGN One of the most important if not the most important aspect of a database is the database design process. It is a must that the design is good and functional. A database consists of many different parts of an engineer’s design, which together makes up a complete database system

Relational Databases

2149 words - 9 pages Relational Database: Design This paper evaluates four similar web databases and concludes with an overview of considerations for designing web databases. The web databases reviewed are: (a) the Academy of Motion Pictures and Arts (Academy, 2013), (b) IMDb (IMDb, 2013), (c) Complete Index to World Film (Complete Index, 2013), and (d) Labor Film Database (Labor Film, 2013). Table 1 summarizes each database in terms of purpose, target audience

Visual Basic Database Tutorials

708 words - 3 pages called Microsoft Access uses it. You can also use this same database in your Visual Basic applications. This VB6 tutorial explains how. * Optimizing Database Applications Optimize, Optimize, Optimize! This is how you can create the best, fastest, most user friendly apps. In this tutorial you learn what the optimum way to do database development is. * Database Design As you begin to program more advanced programs that store data in

Service Request Sr-Ht-003

778 words - 4 pages data helps to design the new databases so that it will meet the goals and to test the databases to see if the goals are met. The database designers will at times refer to the goals as data integrity, referential integrity, or keyed data access. It will be ideal to normalize the data before the database tables are made. Data normalization is very important in transactional, or the online transactional processing database world where many data

Smith Consulting Database Environment

2637 words - 11 pages Smith Consulting Database Environment Student Name DBM/380 Date: Instructor name: Smith Consulting Database Environment Smith Consulting’s current employee management system is inefficient involving a one table database, which produces duplication of many attributes throughout the system. The first iteration of database design provided a new version consisting of various one-to-many relationships to link its various modules. There are

Related Essays

Database Design Essay

932 words - 4 pages Running Head: UNIT 2: DESIGN A RATIONAL DATABASE SYSTEM Unit 2: Design a Rational Database System Dale Henderson Kaplan University Professor Michael Collins IT520: Database Management Systems August 12, 2013 |Term |Definition |Example

Database Design Process Essay

1023 words - 5 pages Abstract Database Systems has a practical, hands-on approach that makes it uniquely suited to providing a strong foundation in good database design practice. Database design is more art than science. While it's true that a properly designed database should follow the normal forms and the relational model, you still have to come up with a design that reflects the business you are trying to model. This paper shows describes design process of

Database Design Essay

1911 words - 8 pages Gestiunea studentilor intr-o universitate Scenariu In cadrul unei universitati a fost nevoie de crearea unei baze de date pentru a centraliza datele legate de studenti. Baza de date ne ofera posibilitatea de adauga, modifica sau sterge datele legate de studenti respectand anumite norme de integritate. Fiecare student va avea inregistrate date precum nume,prenume,cnp,data nasterii,gupa din care face parte,anul s.a. . Baza de date ne va oferi

Computer Essay

390 words - 2 pages application programs to concurrently access the same database. Depending on the task which the database is being used for, the advantages will usually outweigh the disadvantages but, like with most things, there are some disadvantages. First of all, the database systems are complex, difficult, and time-consuming to design and often need a specialist to help with the design. There are substantial hardware and software start-up costs as well as the