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: Write the business rules associated with Customer and Order. Given the business rules you wrote above, draw the basic Crow's Foot ERD. Identify the different types of entities, attributes, keys and relationships you will want to consider when designing the database.