Business Finance Homework Help
Database Design Project
Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
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.
