Customer Database table
1. I need customer database for organizing customer information and it's helpful for finding the name of customer who order my product.
2. I would collect customer profile such as Name, Last name, Gender, E-mail, Home address for delivery if customer want, Date of purchase, Phone number and Customer ID to get products and sign name to make sure you bought a product.
3. e-commerce website have to use Microsoft SQL or Oracle for connecting database to website.
Microsoft SQL server is transaction control. For the purpose of this article, a transaction can be defined as a group of operations or tasks that should be treated as a single unit.
Oracle database using power query and it quickly and easily load data from Oracle to Excel
4. target market is a more broad group of potential customers defined by ranges. a target market might be ages 18-34 year old, or certain income bracket.
5. this filters show that the group of customers who paid before the end of January and filters help to find information about date, time to purchase, gender and customer ID as you want.
Good work, to improve you need to elaborate on the point 3. Try to write more, a paragraph for each point to explain your understanding.
ReplyDeleteAlso, what can you use this information for in your own website development or e-commerce development? What does the information you are gathering mean to you? How could you use it to optimise your business?
ReplyDelete