Group 10 Nike

Group 10
Name Regno
Sidharth Singhee
JU2020MBA2981
Keerthana yadhav
JU2020MBA5210
Rajath Kamath
JU2020MBA7111
Himanshu sethi
JU2020MBA3794
Nikitha R
NIKE MANAGEMENT SYSTEM
Nike Inc.’s organizational structure reflects the abilities and limits

of the business in its operations. A company’s organizational or
corporate structure is the composition and system design applied
on the interconnections among employees, groups, and divisions
of the business. In Nike’s case, the corporate structure highlights
the need to address differences among regional markets. These
differences are linked to region-specific demands of target
customers, such as variations in the preferences for apparel based
on sports popularity and climate. As such, Nike Inc. has
developed its organizational structure to enable adjustments in
dealing with market differences. As one of the leading players in
the athletic footwear, apparel and equipment industry, the
company and its corporate structure serve as an example of how
regional variations must be included in business strategies.
DATABASE AND ITS FACILITIES
This database is being developed to help the company to

maintain the record in the best possible way and also to reduce
the human efforts. Below is the list of some features which are
provided in this database system-
1.Keep records of different categories like- Customer’s name,

Phone number, orders, products, etc.
2.Easy ways to enter new customers, orders, products, and
modify it.
3.Automatic total Price calculation.
4. Different criteria to find customers and their orders.
5.Classify the customer name wise.
6. Find products in a particular categories.
TABLES
Tables are the key objects in the access file, as they contain
the data that is stored in the database. Tables are made up of
rows and columns and allow for direct data entry in to the
grids. The row is the record which contains the individual
record. The columns, also referred to as fields, consist of
categorized information. For our database we have formed
five tables, one is for keeping the details of the customer;
second table is for keeping the records of the products with
their price ;third table is for product categories ; fourth table
is for orders and lastly, fifth table is about the order details .
Below mentioned are the things which are recorded in the
table.
TABLES
TABLE 1:- CUSTOMER TABLE 2:- PRODUCT TABLE 3:- ORDER

1. CUSTOMER ID 1. PRODUCT ID 1. ORDER ID
2. LAST NAME 2. PRODUCT NAME 2. CUSTOMER ID
3. FIRST NAME 3. CATEGORY ID 3. ORDER DATE
4. EMAIL ID 4. PRICE 4. SHIP EMAIL
5. MOBILE NUMBER 5. IMAGE 5. SHIP MOBILE NUMBER
6. ADDRESS 6. SHIP CITY
7. CITY 7. SHIP STATE
8. STATE 8. SHIP PINCODE

9. PINCODE
TABLES
TABLE 4:- ORDER DETAILS TABLE 5:- CATEGORY

1. ORDER DETAILS ID 1. CATEGORY ID
2. ORDER ID 2. CATEGORY NAME
3. PRODUCT ID 3. DESCRIPTION
4. PRODUCT NAME
5. TOTAL PRICE
6. ORDER TOTAL
Database relationships
In a relational database (Access), the data in one table is

related to the data in other tables. In general, tables can
be related in one of three different ways: one-to-one,
one-to-many or many-to-many. The relationship is used
to cross reference information between tables.
Query
A query can pull the information from various tables and

assemble it for display in the form or report. A query can
either be a request for data results from your database or
for action on the data, or for both. A query can give you
an answer to a simple question, perform calculations,
combine data from different tables, add, change, or delete
data from a database.
Form
A form is a database object that you can use to enter,

edit, or display data from a table or a query. Forms can
be used to control access to data, such as which fields of
data are displayed.
Report
A report is a database object that comes in handy when want to

present the information in the database for any of the following
uses:
-Display or distribute a summary of data.
-Archive snapshots of the data.
-Provide details about individual records.
-Create labels.
THANK YOU

Group 10 Nike

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

Group 10 Nike

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Group 10 Nike

Uploaded by

Copyright:

Available Formats

Group 10

Nike Inc.’s organizational structure reflects the abilities and limits

This database is being developed to help the company to

1.Keep records of different categories like- Customer’s name,

TABLE 1:- CUSTOMER TABLE 2:- PRODUCT TABLE 3:- ORDER

8. STATE 8. SHIP PINCODE

TABLE 4:- ORDER DETAILS TABLE 5:- CATEGORY

In a relational database (Access), the data in one table is

A query can pull the information from various tables and

A form is a database object that you can use to enter,

A report is a database object that comes in handy when want to

You might also like