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.