1. Customer
Customer ID
CMR811 ---> CMR-8-11 ---> relates to name, date, address ---> apply to sale records and product records
Data--> Information--> Knowledge--> Wisdom
Our customers that purchase an online subscription will be given an ID to represent them in our data base. The letters and numbers are data for our system that our customers would not understand. Then we format it, to make it easier for the person calculating the accounting books to understand. Then we relate the information so that it represents the person’s name, the date they bought the product, and their address. Finally, we will use this information to help use keep track of how long that person stays with our newspaper and how much the person owes us.
2. Product (online subscriptions)
Online Subscriptions ID
YR811-->YEAR-8-11-->relates to the name, price, description-->apply to sale records and product records
Data--> Information--> Knowledge--> Wisdom
Our online subscriptions will be given an ID number to represent the different types of subscriptions we have. The identification number is data because it nothing but letters and numbers until we format it so that it anyone will be able to understand what the number represent as information. Then we relate the information to the customer’s name, the price of the item, and a brief description. Finally, we will use the information to determine which of our subscriptions is the most popular to our customers.
3. Event (online subscriptions sales)
Subscription Sales ID
1126201130->11-26-2011-30->relates to date, total paid, taxes, customer ID, Online Subscriptions ID-> apply to sale records and product records
Data--> Information--> Knowledge--> Wisdom
Our sales of subscriptions will be given an ID number to represent the different sales we have in our database. The ID number is our data because it nothing but numbers and letters which will be formatted to transform the data into information. As information we will relate this information to the date it was paid, how much was paid, the tax amount included, the customer, and the subscription they bought.
No comments:
Post a Comment