Question
creating an Entity Relationship Diagram (ERD) for the case scenario provided. You need to include at least 8 tables in your ERD. The tables should
creating an Entity Relationship Diagram (ERD) for the case scenario provided. You need to include at least 8 tables in your ERD. The tables should be normalized along with showing all relationships between them. Any business would need far more than 8 tables to build a full database system, for this project just limit yourself to 8 tables. This should also be accompanied by a 2-3 page description of the reason why you created these tables for the case scenario. You should cover the business importance of these tables and briefly describe how you normalized/broke up the tables in the way that you did.
Create a database system for XYZ, a technology and appliance store that will help manage all aspects of their business. They are a local technology and appliance store starting from scratch, so it is up to you to design them a system to start building their business properly. They would need to manage customer, employee, and stock information. The needs of XYZ can be specific, so make sure to accommodate as many as possible. In the future, they would like the ability to expand their database and leverage the information inside of it. While there is just one store right now, the idea is to be able to expand in the near-term future. When thinking through the assignment prompts, keep this in mind. The ability to data mine the information you collect is valuable to any business. Leveraging information is vital to XYZ and its goal of expansion.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started