Sunday, September 4, 2011

1.2 Data Explaination

1. Customer

Customer ID
ABBY0098 - > ABBY-00-98 -> relate to name, address, age -> apply to sale records & product records
Data -> Information -> Knowledge - > Wisdom

Our customers each will be given an ID number to represent the in our system. At first the identification number is just a piece of data because it is only letters and numbers with no meaning. Then we format it, so a human will be able to understand it transforming data into information. then we will relate it to other data about the customer, such as the customer name, address or age transforming it into knowledge. Lastly, the customer id number can be used to find more information related to the customer, such as what products or hair styles the customer chose or any sales information, so our hair stylists will know which customers owe us or pay us the most throughout the year.

2. Product (Hair Styles)

Hair Style ID
CUT0098 - > CUT-00-98 -> relate to name, price, description -> apply to sale records & customer records
Data -> Information -> Knowledge - > Wisdom

Our hair styles each will be given an ID number to represent them in our database. At first the identification number is just a piece of data because it is only letters and numbers with no meaning. Then we format it, so a human will be able to understand it transforming data into information. then we will relate it to other data about the hair style, such as the hair style name, price or description transforming it into knowledge. Lastly, the hair style id number can be used to find more information related to the customer, such as what customers have chosen this hair style or how many sales include this hair style, so our hair stylists will know which hair styles are the most popular or even track how much product like shampoo or color is used in a given month.

2. Event (Hair Style Sale)

Hair Style ID
0902201105 - > 09-02-2011-05 -> relate to date, total paid, tax amt, customer id, hair style id -> apply to customer records & hair style records
Data -> Information -> Knowledge - > Wisdom

Our sales records each will be given an ID number to uniquely represent them in our database. At first the identification number is just a piece of data because it is only letters and numbers with no meaning. Then we format it, so a human will be able to understand it transforming data into information. Then we will relate it to other data about the sale, such as the total paid, date and tax amount transforming it into knowledge. Lastly, the sale id number can be used to find more information related to the sale, such information about the customer that is part of the sale.


No comments:

Post a Comment