NIT2113 Cloud Application Development: Database for Nail & Beauty

This project involves the creation of a cloud application database for a beauty and nails company, specifically Nail & Beauty Supply. The database includes two objects: customer and merchandise assignment. The customer object contains fields for customer ID, name, and phone number. The merchandise assignment object includes fields for item ID, brand, cost, description, quantity, sales price, and supplier. The project details the database schema, data population process (including converting .xls files to .csv), and the manual data entry required due to import issues. The project also covers creating custom views for the data and generating reports, such as a merchandise assignment history report and a customer list report. Finally, a dashboard is created from the reports to provide a summarized overview of the data.

Name
Institution
Cloud Application and Development

In this project there is the creation of a database for beauty and nails company containing two
objects; the merchant_assignment and the customer objects. Customer object contains three
fields; customer Id which is of type number, customer name which is a text of length 255 and a
phone number which is of type number with a length of 255.
The object merchant_assignment is made up of eight fields, 1 standard field and seven custom
fields. The standard field is merchantname which is a text with a length of 255. The seven
custom fields are brand, cost, Description, itemID, Quantity, Sales Price and Supplier. Brand is
of type text and of length 255 because it requires text that describes the brand of the item or
product. Cost is currency therefore used a currency data type of length eighteen with decimal
places taking two. Cost requires a monetary value which requires that the field be of data type
currency. Description is of data type text of length 255 because it requires descriptive language
to give more details on the data item or product offered by nail beauty supply. ItemID is of
datatype auto data which increments automatically, it is also the unique identifier of the data
items or products in the merchant_assignment table. Quantity is of data type number because it
requires numerical and is of length eighteen, whole numbers taking sixteen digits whereas
decimals take two digits . Sales Price is of data type currency because it requires monetary
figures that is why the data type is of type currency. Supplier is of data type text having a length
of 255 giving the name of the supplier. The name of a supplier is of type text.

The schema of the database

After the design of the database named nail beauty, population of the data from the xls files was
done. The .xls files were converted to csv files to enable importation to the database.
The customer object importation worked but the items object importation did not work as
expected, the data had to be populated manually into the data objects in the database.
The following is the data presentation of the customer object after population of the data from
the .csv file.
The records displayed are the record id, customer name and the telephone numbers of the
respective customers of nail beauty.

The following image shows the data populated in the merchandise_assignment object where all
the information about the items nail beauty owns as a company.
We have the edit and delete button at the left most side of the display where the user can alter the
data in the merchandise_assignment object.
Views of data
The view of the customers can be changed so as to display as much detail as possible. This is to
enhance the user interface for more interaction between the system and the user. On the change
view one can change the view of what the user needs to view in the most comforting way. The
following interface shows the window for changing the view of both the customer and the
merchandise objects.
First you click on the create new view
Then this window appears where you enter the view name

The choice of what fields are to appear in the new view from the selected data object is done.
This is where what data fields are to be displayed in the newly created and named window.
The buttons up and down are to for placing the display fields either on top or below another
field. The add and remove buttons are to add the fields to be displayed and to remove fields
from display respectively.

Reports
Reports were created. There is the merchandise_assignment history report about the creation,
population and modification of the merchandise_assignment object. It states the times of creation
and modification. This is as shown in the image below.

The is the report on the customers nail beauty has as shown below. It states the names of the
customers and at the end states the number of customers nail beauty has as a company. The total
number of customers nail beauty has is 122 customers in total.

Dashboard
A dashboard has been created from the reports done in the system.

References
Al-Masree, H. K. (2015). Extracting Entity Relationship Diagram (ERD) from relational database
schema. International Journal of Database Theory and Application, 8(3), 15-26.
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage
Learning.

Appendix