.Fernando Culebra, owner of Fernando's Skate Shop, still needs your help. Apply what you have learned about the steps of the design process to help Fernando get started in the design of his new database. Complete steps 1 and 2 of the design process by submitting a database mission statement and database mission objectives. Then, submit at least five questions you would ask Fernando and at least five questions you would ask his sister, Carlita, who works as a clerk in the shop.
Here is more background information about the business:
•While at the store, you observe a transaction in which a customer buys a skateboard. Carlita takes the skateboard and, on an index card, writes down the skateboard model, supplier, and price. Then, she calculates the tax on the cash register and provides the customer with a receipt upon payment.
•Carlita then asks the customer if they'd like to be added to a mailing list for local skateboarding events and issues. If they agree, the customer information is hand-written on an index card. Fernando then tells you that part of why he thinks his business is so successful is the active participation of the skateboarding community at events he sets up and puts on his mailing list.
Prepare your mission statement, mission objectives, and questions.
Mission Statement: The mission of Fernando's Skate Shop's new database is to streamline and automate the process of recording and managing customer transactions, inventory, and mailing list subscriptions. The database will improve efficiency, accuracy, and customer satisfaction, while also facilitating the growth and engagement of the local skateboarding community.
Mission Objectives:
1. To create a database that can store and organize information about skateboard models, suppliers, prices, and tax calculations.
2. To develop a functionality that generates and prints receipts for customer transactions.
3. To implement a feature that allows customers to opt-in for the mailing list for local skateboarding events and issues.
4. To design a database structure that enables efficient retrieval of customer information for targeted marketing and event organization.
5. To ensure data security and privacy by incorporating appropriate access controls and backups.
Questions for Fernando:
1. How do you currently track your inventory and manage supplier information?
2. Can you provide some examples of the different types of customer transactions that occur at your store?
3. How would you like the database to integrate with your cash register system, if at all?
4. What specific mailing list information do you want to collect from customers who opt-in?
5. What are your future plans for expanding your skate shop and how do you envision the database supporting those plans?
Questions for Carlita:
1. What are the current challenges you face in recording customer transactions and maintaining the mailing list manually?
2. How often do you need to refer back to past customer transactions or mailing list information?
3. Are there any specific details you think are important to include on the receipts for customers?
4. How do you manage inventory updates and ensure accurate stock levels?
5. In your experience, what are some common requests or preferences customers have expressed when it comes to subscribing to the mailing list?