Testing and Implementation of a Database for Business Operations

Running head: DATABASE
Database
Name of the Student
Name of the University
Author’s note:

1DATABASE
The database has been tested based on the various parameters that has been discussed in
the test plan. The first thing that has been tested is the database anomalies. The anomalies makes
the database more complex to manage. Each table of the database has been tested to see whether
there is any multivalued attribute, partial dependency or transitive dependency. Multiple values
for a foreign key has been added to the tables to test the database. Everything went fine with the
normalization. The purchase of many cars by same buyer has been checked by entering multiple
data rows in the sales invoice table for each customer. The same has been tested to see whether
same seller can sell many cars. This test also went well. The database stores only the relevant
data. Taken as an example, the database accepts only date value for attributes that refers to buy
or selling date. The ownership dates also accept only date value. The primary keys and their
foreign keys have the same data type and data range.
Another things that has been tested in the database is that whether it supports the real life
situations. Taken as an example, the ownership detail has two date related attributes such as
from-date to to-date. As per the real life scenario, the to-date must be bigger than the from-date.
This situation has not been implemented in the database. However, this could have been
implemented using the check constraint which would have checked whether the from-date is
shorter than to-date. Another real-life scenario is, ownership of the car changes when a purchase
is made. This function is left for manually entering by the end-user such as receptionist.
However, this could be implemented using trigger function.
Purpose of database is to provide in-depth date about business operations. These
information are used for assisting the management to make decisions. The BI or Business
Intelligence reports allow the management to fetch data in a more convincing way by showing
the data in graph or pivot table. For this reason, the database has been tested to see whether it can