Connolly and Begg, Essay Example

Based on guidelines presented by Connolly and Begg (2005) and Hernandez (2003) and on the given details about the company, the following mission statement and subsequent objectives are presented.

Database Mission Statement: The Fernando’s Skate Shop (FSS) database is committed to ensuring the efficient and accurate management of customer, product and other data and information related to business operations of FSS.

Database Mission objectives:

• Document and store sales and returns transaction data of FSS
• Document and store product and supplies inventory data of FSS
• Document and store revenue and expenses data of FSS
• Build customer mailing list
• Return relevant information necessary during business operations
• Return relevant information for the organization of planned events

Questions for Fernando

• What are the specific problems that the store encounters in relation to managing data for customer transactions?
• What are the specific problems that the store encounters in relation to managing inventory data?
• What are the specific problems that the store encounters in relation to managing revenue and expenses data?
• How are data stored and what problems arise from this storage system?
• What are data management problems encountered in preparing for and inviting people to skateboarding events?

Questions for Carlita

• What is done with the transaction data written on the index cards after it is filled out? That is, in what other parts of the store’s operations are they used for?
• What are problems that you encounter when retrieving data from the transactions database?
• How does the store calculate tax?
• What is done with the customer information written on the index cards after it is accomplished? That is, where is it stored and how is it retrieved?
• What are other problems related to managing information about store operations that you encounter?

References

Connolly, T., and Begg, C. (2005). Database systems: a practical approach to design, implementation, and management. Addison-Wesley.

Hernandez, M. (2003). Database design for mere mortals: a hands-on guide to relational database design. Addison-Wesley.