Create data models like a conceptual (CDM)
This is a forum discussion from Databases and Big Data Management class.
This week’s case, Foxcore Retail, describes a small retail business that sells seasonal novelty items
Foxcore realizes that they need to build a database because their current method of tracking sales, salespeople, etc. is inadequate.
Before they build their database, they should design a conceptual data model. You have been asked to help them with this design.
In this Forum please answer the following questions.
1.Is it necessary to create a data model before creating the database? What are the benefits of performing this step?
2. After reading through a description of business requirements, identify the entities and attributes that could be used in a potential data model. What are the relationships between entities?
Data Model
Student’s Name
Institutional Affiliation
Course Name and Number
Lecturer’s Name
Assignment Due Date
Data Model
Question 1
I believe it is necessary to create a data model before creating a database because a data model shows the logical structure of a database, including the relationships and constraints that determine how database managers can access and store data. Developers can create data models like a conceptual (CDM) without considering database concepts since the model provides a data-centric perspective of a business by documenting how various entities relate to each other. In this data model, there is hardly any detail available on the actual structure of the database. This process demonstrates the possibility of creating a data model before creating a database.
One of the benefits of performing this step is data quality. A data model improves an application's conceptual quality and lets developers lever...