Business Information Systems Database Project - COMR2002

This project involves designing and implementing a database to address data management issues within an organization. The assignment begins with an introduction summarizing the case study and the issues of paper based information management. The project details the database development activities including the ER model and the relational schema. The relational schema is then normalized to the 3rd normal form, with explanations for each step. The assignment then discusses the impact of using technology, covering aspects such as business information systems, cultural, security, ethical, and privacy issues. The solution includes the creation of database queries to answer specific questions and the development of reports. The project aims to provide a dynamic approach to a business environment and the ability to handle complex tasks. The database stores data in a central location for long-term use, enhances data access, and improves process tracking and control. It also identifies potential security and ethical issues related to the use of information systems and IT.

Name Id
Dale 300035345t

Table of Contents
Introduction................................................................................................................................2
Database.....................................................................................................................................3
ER Model...................................................................................................................................3
Relational Schema......................................................................................................................3
Impact of using technology........................................................................................................4

Introduction
The organization sales various products to the customer. The sales representative acts as
medium for selling the product. Each customer buy products through one sales representative. One
product is sold by various manufacturers.
The issue data management. The organization is having issues maintaining paper based
information. The data will allow the organization to store data for a very long time. The data
management can be done in organized way.
Database
The first step is collecting information regarding entities and attributes. Then the business
requirements are identified. Using the business requirements, the relationships among the entities
has been created. The normalization is a very crucial step in database development. After
normalization, the many-to-many relationships are decomposed into many-to-one and one-to-many
relations.

ER Model
Relational Schema
SalesRepresentative (Sales Rep Number, firstName, lastName, contactNumber, country, totalCommission,
commissionRate)
Customer (custNumber, salesRep, name, street, city, zip, country, creditLimit)
Order (orderNumber, custNumber, orderDate)
OrderedProduct (orderNumber, productID, quantity)
Product (productID, productName, productColor, productSize, availableQuantity)
CreditCard (cardNumber, customer, cvv, expMonth, expYear)
ManufacturerProduct (manufacturerID, productID, unitPrice)
Manufacturer (manufacturerID, manufacturerName, address)

The above relational schema is in first normal form because there is no multivalued
attribute. The schema does not have any partial dependency. This makes the schema to be valid for
second normal form. The third normal form describes that database should have no transitive
dependency. The address related information can be separated from customer table and put into
new address table to make the database in third normal form. Therefore, the following schema is in
3rd normal form.
SalesRepresentative (Sales Rep Number, firstName, lastName, contactNumber, country,
totalCommission, commissionRate)
Customer (custNumber, salesRep, address, name, creditLimit)
Address (addressCode, street, city, zip, country)
Order (orderNumber, custNumber, orderDate)
OrderedProduct (orderNumber, productID, quantity)
Product (productID, productName, productColor, productSize, availableQuantity)
CreditCard (cardNumber, customer, cvv, expMonth, expYear)
ManufacturerProduct (manufacturerID, productID, unitPrice)
Manufacturer (manufacturerID, manufacturerName, address)
Impact of using technology
The business information system can provide dynamic approach to a business environment
as well as it requires to be flexible enough for absorbing unpreventable alterations regarding the
information requires in the business. The business information system can satisfy the complex and
demanding tasks. The system can provide balance between the business operations and technology.
The system can predict the changes in the business operations. The organization implement the
system to meet their needs. Manual and paper based works are very hard to organize. The
organization can use the system for making the back processes automatic. The database used in the
system, can store data in a central location so that data can be used for long time. The database will
automatically maintain the data. As the data will be stored in central location, each person in the
organization will have access to same data. The data redundancy will be increased significantly. The
system can easily track processes of the organization and let the management control the business
operations effectively and efficiently.
The IS and IT can face various security issues such as cyber-attacks, physical attacks and
many more. The loopholes in the system is very common security issues in IS and IT. The systems can
be used by internal or cyber criminals to manipulate people, which can be huge ethical issue. The
administrators has access to inside data which can be manipulated to gain advantages.