We are trying to build a truly professional custom tailoring business by having a comprehensive database that keeps track of customers' information (demographics, measurement etc) and? order history (keeping track of brands of fabrics, color preferences, order amount etc.).? The database will also facilitate the recording of information during a tailoring appointment (ie. a user-friendly interface to record all the items that the customer orders).? There should be popped up reminders notifying us of customers' birthdays, a certain level of cumulative order amount (allowing us to recognize customers who have purchased a lot from us) etc.
We also want to add some new features on the website with linkages to database.? For example, we want returning customers to be able to order new shirts online (the new order should show up in the database).? We also want customers to make able to make appointments online (appointment date and time will then show up in database).? We will need help on both the website and the database.
There should also be security features in the database.? For example, employees can only access certain parts of the database and are not able to export customers' info onto an excel (but the owner should be able to do that).
Overall, the database should be user friendly and simple, allowing us to log in from anywhere and to add new fields easily (for example, new demographic info that we collect from customers in the future)
I will also give some sample data for construction of the prototype