Computer Science Question

In this assignment, you will start to Plan your Database.

You are required to independently Plan and Design a Database

• Plan: Select a Company and line of operation (for example, Best Buy – Retail Sales operation)Brainstorm how you can create a database to meet the company’s needsList the Requirements
• Design:Create an Entity-Relationship diagram based on your requirements

Tasks: Review the Resources below to help guide the completion of this assignment:

1. Review this source for what an ERD (Entity Relationship Diagram) is: What is an Entity Relationship Diagram (ERD)?
2. Review this source for SQL Server DataTypes with Examples.
3. Determine requirements. Requirement Gathering And Creating Initial ER Model
4. Create an ERD for your database. This database should not be more than 7 – 10 tables.

Upload your ERD and a 2-page document explaining your ERD in detail.

ERD: You may use Visio or Draw.IO to create

During this process, please take screenshots. You should have a minimum of 5-7 screenshots for each process.

Submit all task results in a SINGLE Word file with all sections

Naming convention of file to be submitted: firstnameLastname_Module2_HandsOn_Assignment.docx