You understand that database technology can dramatically improve your ability to analyze information, compared to spreadsheet technology, and assist you in developing your strategic plans for the cafe. To help you familiarize yourself with databases and their associated business value you need to create a report detailing the basics of databases and why they are better for running a business than spreadsheet applications. Be sure to provide a detailed explanation of relational databases along with their associated business advantages.
PROJECT FOCUS:
Once you understand the benefits associated with a relational database you decide to build a small database to help you track and analyze customer orders and sales information. Identify the different types of entities, attributes, keys, and relationships you will want to consider when designing the database.