CHOSEN SCENARIO: VINCE’S VINYL
A. Conceptual Model:
A conceptual model, or a summary-level data model, is generally used on strategic data projects to describe an entire organization. As the most abstract form, it is useful in communicating ideas to a wide variety of stakeholders. Platform specific information, e.g., data types, is excluded. Other implementation details, e.g., procedures and interface definitions, are omitted. CDM (Conceptual Data Model) is typically created without consideration of database concepts and used in the initial planning phase. Business practice, rather than information similarities, defines relationships. In this phase, it is irrelevant how information is stored and managed, but primarily understanding how stored data is used is crucial.
It provides the overall structure of the database and high-level information about the subject areas and/or data structures of an enterprise. Its simple purpose is to establish the Entities, their Attributes and their ‘high-level’ relationships. In other words, there is little detail, consisting of the basic Entities along with their simple relationships. If any Attributes are included, they are loosely typed (e.g., no length settings). Connectors between Entities do not define relationships to specific Attributes. (UC Davis).
Common characteristics of a CDM (DataModel.com):
Conceptual Model for Vince’s Vinyl: The primary entities are: the owner, vendors/suppliers, customers/buyers, employees and albums. The owner purchases albums from vendors/suppliers, sells them to customers/buyers and employs part-time help, who stocks and also sells the albums to customers/buyers. (See screenshot below.)
A logical data model, or a fully-attributed data model that is independent of DBMS, technology, data storage or organizational constraints, typically describes data requirements from the business aspect. Also referred to as LDM, it represents the (entire or partial) business requirements of an enterprise and is developed before the physical data model. It involves using the business information discovered during CDM and translating it into a relational style, empirical layout of the data.
While the data modeling uses a relational model notation, the resulting data implementations using relational technologies are not required. This technique includes more detail, or Attributes. Nevertheless, it is still “generic” since it is not bound to a specific DBMS. It helps to define the detailed structure of the data elements in a system and the relationships between data elements. The model refines the data elements introduced by a Conceptual data model, just as it forms the basis of the physical data model.
The process of creating a logical model (based on a conceptual model) involves (DataModel.com):
Common characteristics of a logical data model (DataModel.com):
Logical Model for Vince’s Vinyl: Necessary aspects of the DBMS are represented to address the business solution. (See screenshots below.)
Physical level modeling involves adding “platform specific” detail to the model, i.e., detail specific to the DBMS, where the database is to be deployed. This can be accomplished by creating a copy of the logical model and by adding the physical definitions. It includes all required tables, columns, relationships, and database properties.
It visually represents the structure of the data, as implemented by a relational database schema (e.g., tables, columns, indexes, constraints, primary and foreign keys). In other words, by defining a physical data model, the database schema can be derived automatically.
The logical model, which was derived from the business concepts (or, conceptual model), is in turn adapted for database deployment. PDM, as it is sometimes known, involves the final stage of planning. This stage involves an absolute design of the database implementation, which is often completed by a data architect, or a database administrator. As such, the CDM, LDM and PDM phases are finalized.
The key aspects of PDM are (DataModel.com):
Common characteristics of a physical data model (DataModel.com):
Physical Model for Vince’s Vinyl: This model builds on the nonphysical (conceptual and logical) models that have been crafted. (See screenshot below.)
(Special note: In case the above sample is insufficient, I am including the database diagram that I also submitted for the Scenario Activity.)
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more