Business Information System Report: Sales Data Database & Database

This report details the development and functionality of a sales data database system designed to store and manage business sales activities. The system includes three tables: Customers, Orders, and Sales Rep, each containing relevant fields to capture specific data. The Customers table stores customer details such as ID, name, address, state, sales rep ID, and initial sales date, with the Customer ID serving as the primary key. The Sales Rep table includes Sales Rep ID and Sales Rep Name, with Sales Rep ID as the primary key. The Orders table tracks customer orders with fields for Sales Rep ID, Customer ID, Product Code, and Quantity. A query, named 'Sales by Individual Sales Rep,' was created by selecting relevant fields from these tables, and a corresponding 'Sales Report' was generated to present the query results, providing a comprehensive overview of sales performance and customer activity within the business system. Desklib provides this and many other solved assignments for students.

Business information system report
Sales data database system was formulated to address and store the business related activities.
One of the main functions of the sales data system was to store data regarding the sales activities
in business. Data storage in business is one of the most vital aspects in sighting whether the
business is doing well or not. As a result, the developed business system contained objects such
as tables, a query and a report. The tables created were customers table, orders table and sales rep
table, the query created was named sales by individual sales rep and finally the report was
created reporting the query results and it was named sales report.
Customers table
This table constituted of six fields with the names customer ID, customer name, address, state,
sales rep and finally initial sales date which recorded the customers’ details. Customer ID field
properties were; the data for the field was “Autonumber” and in the table, the field was primary
key holder. The primary key assigned to that file ‘Customer ID’ checked to ensure that there was
no duplicate records in the field since the records uniquely identified all the records contained in
the field. The field “customer name” had the properties such as short text data type, the field’s
records were required hence restricted not to be left empty during the data entry process in the
table datasheet view and finally, zero length was not allowed for that field. Address field was
made to have short text data type, required and the zero length was not allowed as well. Field
“State” was restricted to text, field size length of 3 characters and it was as well required. Field
“Sales rep ID” was assigned number as the data type and the field was required. Finally, the
“Initial sales data” field was assigned date/time data type with medium data as the date format.
Customer table example was as below;

Customers
Customer ID Customer Name Address State Sales Rep ID Initial Sales Date
1 Ann 122 Albert St TAS 3 15-May-17
2 Antonio 161 Sussex St WA 2 04-Dec-16
3 Thomas 899 Beacon Rd QLD 1 17-Feb-17
4 Christina 4 The Avenue NT 4 15-Apr-16
5 Martin 128 Farrel St TAS 3 27-Jun-16
6 Francisco 50 Park St QLD 1 11-Nov-16
7 Ming Yang 396 Clarendon St WA 2 04-Oct-17
8 Elizabeth 100 Gloucester St NT 4 04-Dec-16
9 Sven 72 Libercal St VIC 5 01-Oct-17
10 Roland 120 Princes St VIC 5 30-Aug-17
Sales rep table
The table consisted of two fields i.e. Sales rep ID and Sales rep name which recorded the sales
representatives’ details. The sales rep ID field had autonumber as the data type and it was the
primary key holding field which uniquely identified records in the table. Sales rep name had
short text data type with required and zero length not allowed as the field property. Sales rep
table is as below;
Sales Rep
Sales Rep ID Sales Rep Name
1 Kris
2 Edward
3 Ludick
4 Grilo
5 Kupkova
Order table
This table recorded the orders made by the customer in the business. It consisted of four fields
i.e. sales rep ID, customer ID, Postcode and quantity. The table is as below;

Orders
Sales Rep ID Customer ID ProductCode Quantity
1 3 NWTB-1 8
4 4 NWTB-34 15
2 2 NWTB-87 9
5 9 NWTB-87 43
4 4 NWTBGM-85 100
5 10 NWTBGM-85 3
5 10 NWTBGM-85 23
5 9 NWTBGM-85 36
3 5 NWTBGM-86 8
3 1 NWTBGM-86 10
2 7 NWTBGM-86 50
1 6 NWTBGM-86 30
4 8 NWTC-82 200
3 5 NWTCA-48 300
2 2 NWTCFV-88 6
2 7 NWTCFV-90 300
1 3 NWTCFV-94 17
4 8 NWTS-65 10
3 1 NWTS-66 25
1 6 NWTS-66 5
The systems’ query was created by selecting field from the tables such as customer table, orders
table and sales rep table. The field included in the query were; customer name, from customer
table, product code from order table, quantity from orders table and finally, sales rep name from
sales rep table. From the query, a report was created named sales report. The report reported the
results from query in the business system.