Database And Business Intelligence Assignment 2022

Running head: DATABASES AND BUSINESSES INTELLIGENCE
Databases and businesses intelligence
Name of the student
Name of the University
Author note

1
DATABASES AND BUSINESSES INTELLIGENCE
Table of Contents
Introduction................................................................................................................................3
Discussion..................................................................................................................................3
DBMS Concepts.........................................................................................................................3
ERD............................................................................................................................................4
Rules for EERD......................................................................................................................4
Reduced Relational Schemas.................................................................................................5
Entity Sets Representing as Schemas.....................................................................................5
Key attributes.............................................................................................................................5
Tables.........................................................................................................................................5
Queries.......................................................................................................................................5
Conclusion..................................................................................................................................6
References..................................................................................................................................7

2
DATABASES AND BUSINESSES INTELLIGENCE
Introduction
The sales and marketing database management system is referred to the process and
system to manage the marketing and sales that is it manages the inventory of the organization
associated with the technological system (Laudon & Laudon, 2016). The system solves the
different problem which affecting direct purchase and sales in the marketing environment.
Without proper implementation of marketing and sales database in an organization, a large
market organization may run out of stock of some important items. In this report, we develop
an Entity Relationship Diagram (ERD) that captures the detailed requirements for the database
system. Next from we derive a corresponding set of well-normalised tables and populate those
tables with data. Finally, showing both the SQL query statement and the query results relevant to
the sales and marketing database which helps to create, retrieve, update and delete (CRUD)
information from the database in a well-organized manner, hence reduce data redundancy and
increase data integrity.
Discussion
Sales and marketing management is all about specifying the placement and size of
goods in stock to meet future demand. Sales and marketing management also concerns
associated with the assessment, product management, market valuation, marketing feasibility,
costs of products, future and sales price forecasting (Balducci & et al., 2015). This system
stores all the information related to the organization such as store details, stock details, details
of every order, details of customers, details of the employees in the organization, generate
sales and marketing report weekly or daily based. The database management system
characterized the individual aspects of marketing and sales for the organization.

3
DATABASES AND BUSINESSES INTELLIGENCE
DBMS Concepts
A database is a system that helps to manage a set of related information. It can be
defined as a collection of coherent and meaningful data. In an organization, multiple users
are included, and they share the same recourses. So most of the data is stored repeatedly.
Storing the same data multiple times is termed as redundancy which gives several problems
such as problem in updating records, wastage of memory that causes data inconsistency
(Kasbe, 2016). To maintain a large amount of data in a well-organized manner by using the
database approach.
In early days, the applications of the database systems were directly built based on the
traditional file systems. All the system records are stored into files. The traditional operating
system supports the file-processing systems (Suseela & Uma, 2017). But the traditional file
processing system has certain disadvantages such as data inconstancy, data redundancy,
accessing data are difficult, data isolation (different files, formats), integrity problems like
insert, modify or delete constraints, atomicity problem, simultaneous accessing of the
database by several users, security problems. The database system provides solutions to
overcome all those problems.