Business Finance Homework Help

Database Design Project

 

For this case analysis, you will assume the role of a manager for a small company.

You  have been tasked with a project that involves designing and  implementing a database for the company’s managers to assist with  business decision making.

This case analysis is comprised of the following parts: 

  • Part I: Database Design and Context
    • What is a database?
    • What are the uses of databases?
  • Part II: Entity Relationships Diagrams (ERD)
    • What is an ERD?
    • How would you develop a database using an ERD?
    • Show an ERD for your small company.
  • Part III: Creating a Database
    • Using  the ERD you developed, create a database (use MS-Excel) with a MINIMUM  of SIX records (aka tuples) in rows and SIX fields (aka attributes) in  columns.
    • Database MUST show the use of at least ONE Pivot Table (included as an MS-Excel tab) to demonstrate functionality.