CSC 316 Module 1 SLP

Satisfactory Essays
Trident University
Anuj Kainth
Module 1 SLP
CSC 316 – Database Systems I
Professor: Michael J. Pelosi
26 January 2013

"Data Needed for the PC Store Project”
Introduction:
A database to track inventory and sales for the PC Store will be a necessary and vital improvement for the stores success. The database will need relatable data that can be stored and called upon when needed to track inventory and customers efficiently. Such a system could eventually provide personalized suggestions of items for the customers to purchase. Implementing such a system will require the PC Store to start gathering data that will benefit the database and provide tangible results.
Data
Starting the database will require a good inventory of the items we carry in stock such as laptops, desktops, parts and accessories. The database will need information on model numbers, serial numbers, brand, type of item and suggested retail price. This information will be collected by the employees and input into the database through terminals that connect to the stores server.
The next step in building this database will require information on product sales to determine which items are selling the most and how often. This data will allow for ease in managing inventory and ensuring orders are placed in a timely manner. The data needed for this function will be sales order number, price at sale, tax, items sold and customer contact information. The data will be collected at the point of sale using a touch screen tablet interface in tandem with the sales register. The customer will directly be prompted to input their contact information at the point of sale which will associate the information with the correct order number.
Learning from GIS Studying the geographical information systems graphical database was vital in determining types of data that should be considered when building a database. The insight on all the small details of the project such as hail size, proximity, and

You May Also Find These Documents Helpful

  • Satisfactory Essays

    CSC 316 Module 6 Case

    • 293 Words
    • 1 Page

    Trident University Anuj Kainth Module 6 Case CSC 316 – Database Systems I Professor: Michael J. Pelosi 17 March 2014 Database Systems 1 was a subject that I truly enjoyed participating in. The very first day of the class I realized that this was going to be a course that I would learn a lot from and would be able to see the connections that this course has to all aspects of the world. Through the combined knowledge this course provided me I will be able to apply more convincing and…

    • 293 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    Module 1 Slp

    • 1391 Words
    • 6 Pages

    TUI UNIVERSITY Robert Brown Module 1 SLP OPM 500 Operations Management for Managers Dr. Kevin Dickenson January 15, 2013 4 Corners Cookie Company The 4 Corners Cookie Company was established in 2013 from a vision of Robert Brown to create a local and unique cookie and bakery company that produces quality cookies, cupcakes and cakes. The 4 Corners Cookie Company breaks the mold of creating commonly known round cookies and produces all of its 16 varieties of cookies in the shape of a square…

    • 1391 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Tui Mgt 499 Module 1 Slp

    • 426 Words
    • 2 Pages

    Trident University International MGT499 – Strategic Management Module 1 SLP Core Professor: Dr. Sara Garski This is a leading global food service retailer with more than 33,000 local and global restaurants. McDonalds was my chosen business for this project, because this is a major franchise that started out as a BBQ establishment, that grew into a major hamburger franchise over a extended period of time. I think that by analyzing the strategic planning process of McDonalds, I will…

    • 426 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Itm Slp Paper Module 1

    • 643 Words
    • 3 Pages

    Web Browser Differences Trident University ITM501 Jerry Wetfall August 21, 2013 Web browsing has become a popular internet tool in today’s society. It has enhanced everyday demands with the click of mouse or keyboard. With technology at your fingertips, no question has been left without an answer. By exploring all the pros and cons that come along with different web browsers, each one play a major role for everyone throughout the world. With this being said, being used, everyone…

    • 643 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Module 3 - Slp Fin501

    • 355 Words
    • 2 Pages

    Trident University FIN501 Module 3-SLP Dr. Glenn Tenney Risk and return, portfolio diversification and the Capital Asset Pricing Model; The cost of equity Session Long Project company: Target Corp. 1. Beta of Target= .43 Yield to Maturity (Risk free rate)= 0.19% Risk premium=7% Cost of equity of Target= Risk free rate +Beta*Risk premium =.19%+.43*7% =.032%= Answer 2. Beta of Wal-Mart: 0.4 Cost of equity of Wal-Mart= Risk free rate +Beta*Risk premium =.19%+.4*7%…

    • 355 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    Tui Mkt 501 Module 1 Slp

    • 2251 Words
    • 10 Pages

    INTRODUCTION / NAME of YOUR ORGANIZATION. This Module 1 SLP will be the first part of an in-depth market analysis. The company I have chosen is Starbucks Coffee Company. The first Starbucks opened in 1971 at Pike Place market in Seattle, WA. Eleven years later, Howard Schultz was hired by the company to be the director of retail operations and marketing. The first Starbucks with the current coffee house look and feel was opened in 1984 in downtown Seattle. The Starbucks headquarters is still…

    • 2251 Words
    • 10 Pages
    Best Essays
  • Powerful Essays

    MHM522 Module 3 SLP

    • 1038 Words
    • 4 Pages

    Trident University Erica L. Montgomery Module 3 SLP Incident Reporting Requirements MHM/522 Legal Aspects of Health Administration Dr. Paulchris Okpala May 18, 2015 Investigation of the incidents at the hospital level The incident reporting requires the application of either the voluntary or the mandatory systems. Both in Minnesota and in Utah, the reporting function lies in the hands of the professional boards. In both cases, there is a vast number of incidents that are reportable…

    • 1038 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Trident University Anuj Kainth Module 2 SLP CSC 316 – Database Systems I Professor: Michael J. Pelosi 7 February 2014 "Database Design for the PC Store Project" Introduction The database design for the PC Store project needs to fulfill several requirements the management has to oversee the sales, operations and profits of the store. The requested data will include Sales Transactions List, Inventory Status List, Monthly Profit Reports, Monthly Report of PCs not selling and Inventory Status…

    • 801 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    MOD 1 SLP

    • 1451 Words
    • 4 Pages

    Trident University Zina B. Groover Module 1 SLP Course Number: LOG 501 Dr. Tom G. Javarinis October 20, 2014 The Potato Chips According to how products are made. The potato chip became both a national and international sensation when a customer sitting in a restaurant called Moon’s Lake House located in Saratoga Spring, New York. Complained about his french fried potatoes being too thick and sent them back to the kitchen for redoing. The Chef working…

    • 1451 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Eco Mod 1 Slp

    • 698 Words
    • 3 Pages

    Mary Baldwin ECO202 Module 1 SLP 1/25/13 Trident University 1. Identify and briefly describe the organization you are going to use. Why do you think it will be an interesting focus for your application of economic ideas? I picked to do my SLPs on the Dell computer corporation. When reading the module instructions, I was hoping to see Apple on the list because I am somewhat familiar with the company. Though Dell wasn’t my first thought, I’m glad to have found it on the list since I have read…

    • 698 Words
    • 3 Pages
    Good Essays