The Scenario:

Your consulting team is continuing its systems analysis and design work for Mid-Century Modern Décor Unlimited (MCMDU).

Business Background:

…Now it is time to complete an essential first step in structuring system data requirements.

Your team has determined that a relational database system will be used to support the company’s inventory management processes. The database design process involves three stages:

1.Conceptual data modeling(detailed in textbook chapter 8)

Following the third stage, the physical data design will be implemented in a commercial relational database product. The deliverable from the logical data design could be implemented in any relational database product, so you are not concerned with physical implementation issue for a specific product until you reach the physical data design stage.

The Tasks:

This task involves the development of components of a conceptual and logical data models, as described in Chapters 8 and 9, for the business. The work for Tasks 1, 2, and 3 is to be completed in a single Word document with the deliverables of each of the three subtasks clearly labeled as Task 1, Task 2, and Task 3. The work for Task 4 is to be completed in a Microsoft Visio file.

1.Task 1 Conceptual Design: brainstorm within your team to build from your careful analysis of the business scenario to propose, in a Microsoft Word document, a list of all potential entities with their associated attributes. An “entity” is a person, place thing, or event about which you collect, store, and retrieve data. Use the structure illustrated in the Attributes section on page 265. For example, a customer entity might be illustrated as CUSTOMER: Customer_ID, Customer_First_Name, Customer_Last_Name, Mailing_Address, Email_Address, Phone_Number (this is just an example, your team may have better and/or more complete ideas on defining this entity!). For your Task 1 listing, do not identify the candidate key(s): the deliverable from this subtask is to list the Entities and their respective Attributes.

PS: I will attach the Textbook CH8 and MCMDU case study below.