A stationary business is interested in starting a Web site for their Stationary shop, so their existing customers can submit stationary and custom orders online. They want this Web site to help them reach new customers. What type of database management system, if any, should the Stationary shop use to organize and manage their data and information for business purposes?
For more information on DBMS, take a look here:
http://en.wikipedia.org/wiki/Database_management_system
I don't know how much information you need. There's a lot in there, but still a lot more out there.
On a very basic level, to set up a shopping cart, you would need a database that handles the inventory. This can either be tied into the main inventory of the entire store or a separate one. Your customers may decide to not keep count of inventory on the web site and just let people order, while informing them of back orders. That's primarily a cost issue and the business would have to weigh the pros and cons of that.
Depending on the sensitivity of information given in ordering, you may need a lot of security features in both the software and the programming. You don't want people easily hacking in and getting credit card information.
You want some way to keep the customers coming back. So problem solve issues there. Think about how amazon, bn.com, etc. handle these issues.
Getting new customers might involve tracking advertisements placed on other web sites. (just one idea...think of others) You would need some database system to see which ads are effective.
Just thoughts off the top of my head.
Matt
To organize and manage data and information for their online stationary shop, the stationary business should consider using a relational database management system (RDBMS). An RDBMS is a type of DBMS that organizes data into tables, with each table containing rows and columns.
To set up a shopping cart, the business would need to create a database that handles the inventory. This inventory database can be either integrated with the main inventory system of the physical store or can be a separate one specifically for the online shop.
Security is crucial when handling sensitive information like credit card details. The DBMS should have robust security features to protect customer data from hackers or unauthorized access. Encryption, access control, and regular backups are some security measures to consider.
To encourage repeat customers, the business should implement features like customer accounts, order history, and personalized recommendations. The DBMS should be able to store and manage customer-related data, such as names, contact information, order details, and preferences.
To reach new customers, the business can track the effectiveness of advertisements placed on other websites. This involves setting up a tracking system and storing the data in the database. Using the data collected, the business can analyze and measure the impact of different advertisements and optimize their marketing strategies accordingly.
Overall, the stationary business should choose an RDBMS that can handle their specific requirements, such as inventory management, security, customer data storage, and tracking advertisement effectiveness. Additionally, they may consider seeking professional advice or consulting with a web developer experienced in e-commerce solutions to ensure the successful implementation of the website and the database management system.