Docstoc

report of origin

Document Sample
report of origin Powered By Docstoc
					  Summary ORIGIN Depermental Store:
  We are going to make the Ms-Access database of ORIGIN departmental store that will be new
  opening store in the country before making the database we survey the market where should be it
  implemented and what type of customers needs that would be feasible for ORIGIN departmental
  store system.



  System development Life Cycle (SDLC) of Store:


1) Need analysis:
  to make ORIGIN departmental store database we research for the weakness or drawbacks of current
  system and their problems facing in the current system so we search to solve our problems we search
  departmental stores in different cities and observe their customer dealings and survey the products which
  are mostly useable by the customers.


2) System design:
  In this stage we design the database basic structure that how we can provide easy facilities to our
  customers in right manner so we chose the MS database access this system design took 3 weeks to make a
  structure that is feasible for customers and for employees.
  Format
  Screen design
  Database access tools


3) System development:
  In this stage we access different store and collect the data which is in the daily use of customers in this
  database we also add the advertisement of different products
  Database
   Outsourcing


4) Implementation:
  As you should know that our store is new upcoming in the market so we placed a phased conversion of
  database to all over stores in different cities. (Direct conversion)
5) Mantainnence:
1) Beta testing
2) Acceptance testing
   In this stage we implemented the new data in the MS access database all of the entries work right
   and in the quries options we also check the queries by passing the entries and also in the case of
   reports we have aspecific criteria of reports that what type of report we want can be easily
   accessable.




                           Description of the organization:

   The Departmental Store Database is very useful tool to check & query of Shipment to customers
   & employees sales. This Departmental software for the stores will help us to organize and
   manage all the sale items so that we never get tangled in so many entries. The Departmental
   Store Database would be a unique tool to check sales of products very easily.
   We have planned to computerize the Departmental Store’s that are all over the country. We have
   made many visits to the departmental stores, during which we interviewed the people working
   there. During these interviews, we came to know that they were facing problems in the query. As
   the Departmental store system is prepared in registers or in excel, the employees are unable to
   prepare different kinds of reports required by the management.



                        Working of the Existing System

   Related Information:
   Forms:

   Information Requirements in the Forms

1. Customer Information:
   Customer           Customer           Gender              Date              Address          City          Phone          Email
   ID                 Name                                   of                                               no
                                                             birth



2. Employee Information:
   Employee            Employee              Job Title                  E-mail                 Phone No              City
   ID                  Name                                             Address



3. Inventory Information:
   Product Code                   Product Name                       Quantity                             Supplier ID



4. Products Information:
   Product        Product            Price                   Quantity             Category             Shelf No         Supplier
   code           Name                                       Per Unit                                                   ID



5. Shipment Information:
   Orde        Custome            Employe              Produ               Issu              Custome          Produ          Revenu
   r ID        r ID               e ID                 ct                  e                 r Name           ct             e
                                                       Code                Dat                                Name
                                                                           e



6. Supplier Information:
   Supplier            Supplier              Address                 Phone no                  City                  Email
   ID                  Name




   Validation rule for specific identities and their field sizes:
                             ID                             Validation                   Field Size
                                                            Rule
                             Product ID                     “PD????”                     6
                             Customers ID                   “ODS?????”                   8
                             Suppliers ID                   “SD???”                      7
                             Employees ID                   “ED???”                      5
                             Order ID               “SHP????”               7




      There are two phases of data implementation:
 I.   Technical Information
      Tables, Forms, Queries, Reports, Macros
      In this stage we made the structures of all the tables, forms, queries, reports and macros so we can view
      our technical fields which are in our current database all the technical information is given right below.
II.   Implementation of Data
      Tables, Forms, Queries, Reports, Macros
      In this stage we implemented the data to all of our tables and we check the forms those are working right
      and fatherly we develop the reports that were observed right.




      Technical Information
      Tables
      Table:          Customer                                     The figure shown is the design view of
      Purpose:        Customer Identification                      customer table where customer ID is
      Primary Key: Customer ID                                     primary key. There are nine fields in this
                                                                   table in field properties of customer ID
                                                                   field we have describe a validation rule
                                                                   ODS<five digit codes>. This is use to
                                                                   give specific ID’s to each and every
                                                                   customer.




      Table:           Date / Cities
      Purpose:         Picking the data of cities
      Primary Key:                                                                                                 ID
In design view of table date / cities             we have used in this database are
primary key is ID. All the dates and cities       automatically recorded in this table.




Table:          Employee                          In design view Employee table build up
Purpose:        Employee Identification           on for employee’s information who is
Primary Key: Employee ID                          working in     ORIGIN.     In this      table
                                                  employee ID is primary key. ED<three
                                                  digit code> is the validation rule for
                                                  employee ID.




Table:                                        In design view of inventory table our Inventory
Purpose:                                      primary key is product code and the Identification
Primary Key: Product Code                     validation rule for product code is PD<four
                                              digit codes>.




Table:                                        Design view of product table identify theProducts
Purpose:                                                                                 Identification
                                              entire product that we have in ORIGN in this
Primary Key:                                                                             Product Code
                                              table we have used product code as a primary
                                              key.




Table:                                                                                        Shipment
Purpose:                                                                                      Identification
Primary Key: Order ID
                                                     Figure shows the design view of product
                                                     Shipment in this table we recorded
                                                     shipment that is made by our employees.
                                                     We use order ID as a primary key.




Table:                                               Supplier table shows the suppliers of allSupplier
Purpose:                                                                                      Supplier Ident
                                                     products that we have. Supplier ID is used
Primary Key: Supplier ID                             as a primary key in this table.




Froms
Form:


Customer
Purpose:


Will be used for entering or modifying information about the customers.


                                                     Figure     shows      information    about
                                                     customers that we have. In this form we
                                                     have added buttons like find record, next
                                                     record, add record, save record, delete
                                                     record, print form and close form.
Form:


Employee
Purpose:


Will be used for entering or modifying information about the employees.
                                                      Employee form shows all the information
                                                      about employees who are working in
                                                      ORIGIN.
                                                      By this form we can know their names,
                                                      job title, email addresses phone numbers
                                                      and the city from which they are.




Form:
                                                                                              I
nventory
Purpose:


Will be used for entering or modifying information about the Inventory in the Store.
                                                      Inventory table shows stock of a specific
                                                      product, quantity that we have and the
                                                      supplier of that specific product.




Form:


Products
Purpose:


Will be used for entering or modifying information about the Products in the Store.
                                                                         This       form         shows
                                                                         product price, product
                                                                         quantity         per        unit,
                                                                         product category and
In above figure form of products is shown. This form helps               the    supplier        of    the
us to access the specific product that we have in ORIGIN.                specific               product
.
.


Form:


Shipment
Purpose:


Will be used for entering information about the Products that have to Ship.
                                                                         Shipment form shows
                                                                         all the shipments that
                                                                         our    employees            have
                                                                         made       and    also       the
                                                                         customer to whom that
                                                                         shipment belongs.
Form:


Supplier
Purpose:


Will be used for entering or modifying information about the Supplier.
                                                                         Supplier form shows
                                                                         information about the
                                                                         supplier their names,
                                                                         addresses            phone
                                                                         numbers,    cities     and
                                                                         their email addresses.




Form:


Main Menu (Switch Board)
Purpose:


Use form connecting forms, queries and reports.
                                                                         In main switchboard we
                                                                         have     entered   forms,
                                                                         reports and queries that
                                                                         we have recorded in our
                                                                         data base. Switchboard
                                                                         helps our employees to
                                                                         access    to   customers,
                                                                         suppliers, product and
                                                                         shipments.




Reports

Report: Customer Purchase Report
Purpose: To list all the Customer Purchases and their relative information.
                                                                         In customer purchasing
                                                                         report we have shown
                                                                         all the products that our
                                                                         customers           have
                                                                         purchased and at what
                                                                         price       they    have
                                                                         purchased.




Report: Customer List
Purpose: To list all the Customer’s who are currently members and their relative information.




Customer report shows list in which all information about
customers is placed for example customer name, their
gender, their address etc.




Report: Shipment Details
Purpose: To list all the Shipment Details and the relative information about the Revenue.
                                                                          Shipment report shows
                                                                          all the shipments that
                                                                          are   made   by   our
                                                                          customers.




Report: suppliers
Purpose: To list all the suppliers and the relative information about them.
                                           Supplier report shows
                                           information about the
                                           supplier of the product
                                           that   we    have    in
                                           ORIGIN.




Macro
Macro: autoexec
Purpose: It automatically runs the file.
                         We    generated   auto
                         executed which have
                         the argument to open
                         the switchboard when
                         we open our database.




Implementation of Data
Tables
Customer:
This table contains information about people who are using our products and services in services
we use the membership ID’s for customers and additionally we have recorded Customer ID,
customer name, their genders, date of birth, addresses, cities, phone numbers, and email
addresses.


Dates / Cities:                                       attribute of cities so we put data of all
                                                      cities in the given table so the customer
                                                      form filling can’t creat any problem.




In this table we put the dates and city
names and the table as customer ,
employee and supplier table they have an
Employee:
             All the employees that are working in
             ORIGIN departmental store are recorded
             in this table.
             Employee table contains Employee ID,
             employee name, their job title, email
             address, their phone numbers, and city
             from which they are.


Inventory:
             In inventory table we have mentioned the
             entire stock of the product in our
             warehouse.
             This table contains Product code, product
             name, quantity of products, and their
             supplier IDs.




Product:
                              Product table contains
                              information about the
                              entire product that we
                              have. In this table we
                              have recorded Product
                              code,   product     name,
                              and price, quantity per
                              unit,   category,   shelf
                              number, and product
                              supplier.
Shipment:




In this table the shipment information is placed and we can see which customer have order the
specific product and how much revenue we have generated from a specific customer. In this
table we have mentioned order ID, customer ID, employee ID, product code, issue date,
customer name, product name, and revenues.




Supplier:




In this table we have added the record of the supplier’s which are currently providing the goods
and services in the store.
Queries

Customer Purchases:
                                                                mentioned customer ID,
                                                                customer name, product
                                                                name, product code and
                                                                price.

This query is generated for customer’s records. Through
customer query we can access to the record of each and
every customer what the customer have purchased. We have




Product and supplier:
                                                                In this query we have
                                                                mentioned        product
                                                                name, price, supplier

This query is building up on the bases of Products and their    name, supplier ID, and

supplier this query help us to find out suppliers of specific   Supplier’s        phone

products.                                                       number.




Sale by employee:
                                                                customer name, product
                                                                code, product name and
                                                                price of the products.
This record contains all the sales that are made by our each
and every employee. By this record we can check what our
employees have soled. We have recorded employee ID,
Shipment list by product name:
                                                             Shipment         list      by
                                                             product     name         query
                                                             contains Employee ID,
In this query we have mention about the specific product’s   order ID, customer ID,
shipment to the customer by a specific employee.             customer name, product
                                                             name, issue date and
                                                             revenues.




Supplier by products:
                                                             contains supplier ID,
                                                             supplier name, product
                                                             code,     product        name,
                                                             and     prices      of     the
This record is concerns with the suppliers who have supply   product that they have
us all the products which we have in stored. This record     supplied.
Reports
Customer purchase record:
                                                         (that     they         have
                                                         purchases),          product
                                                         name, and prices of the
                                                         products also we have
                                                         inserted a formula by
                                                         the purchases amounts
                                                         will    summed       up   in
Customers purchase record contains all the products or   grand total.
services that customers have purchased. This record
contains our customer ID, customer name, product code


Customer list:
                                                         Customers list contains
                                                         all the peoples who
                                                         interact with us and
                                                         uses our services or
                                                         products. In this list we
                                                         have mention details
                                                         about our customer. We
                                                         have recorded customer
                                                         IDs, names, and their
                                                         gender, date of birth,
                                                         addresses, city, phone
                                                         numbers        and    email
                                                         addresses.
Shipment and revenue:
                                                                criteria as a product
                                                                name so we can see
                                                                which specific product
                                                                has on shipment and its
                                                                further details.
This report tells us about the shipment and the revenue
which we generated from the customer and there dates are
also can also been seen on this report. We entered the


Supplier list:
                                                                every              supplier
                                                                separately.   We      have
                                                                recorded their names,
                                                                city, phone numbers,
                                                                addresses,    and     their
                                                                email addresses.
Supplier list contains all the peoples who are related to the
supply department. In this list we have mention each and

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:10/27/2010
language:English
pages:21