Database Design for Beauty and Nails Company

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.