The lecture note is in the attachment.
Part 1:
Instructions:
Provide your response to the following:
List the differences among conceptual data model, logical data model, and physical data model?
Provide an example of each.
Part 2: Reply to the following posts(in short)
1.Conceptual Data Model vs Logical Data Model vs Physical Data Model
COLLAPSE
A conceptual data model depicts a high-level, business-oriented view of information. Non critical details are left out of the conceptual data model in order to emphasize the most important entities, attributes, and relationships. The conceptual model may contain many-to-many relationships but not every relationship. Issues such as cardinality, optionality, and data types can be skipped at the conceptual level. It also does not identify most keys aside from some simple candidate keys. The goal of a conceptual data model is clarity at a high level. For example a conceptual data model of a student and advisor relationship would only havethe entities' listed and their relationship.
A logical data model consists of fully normalized entities with all attributes defined along with domain or data type. A logical data model requires the specifications of candidate keys for unique identification of each occurrence in every entity. It must also clearly define the primary and foreign keys or imply it based upon the data relationships. Cardinality and whether relationships are mandatory or optional, must be documented in the logical data model. All relationships should be clearly and explicitly names. For example a logical data model of student and advisor relation would include the entities' names, entity relationships, attributes (name, year, major, id), primary key, and/or foreign key.
The physical data model is created to transform the logical data model into a physical implementation ready for DBMS input. It does not include the entity name, entity relationship, or attributes. Instead it has definite primary keys, foreign keys, table names, column names, and column data types. For example a physical data model for a student advisor relation would include the primary key (student id), the foreign key (advisor id), table names (student, advisor), and their corresponding attributes (name, office number, etc.)
2.Types of Data Models
COLLAPSE
Data modeling is the process of creatinga data model for the data to be stored in a Database. Data modeling helps provide a visualrepresentation. Thishelps provide consistency with naming conventions, default values and securitywhile keeping the integrity of the data. Thesemodels emphasize how data should be organized.
A conceptual data model is a high level data model that is structured for business view to support business processes,record business events and track related performance measures.a conceptual data model identifiesthe highest level relationships between the entities.There are no primary keys or attributes specified. This data model defines what the system contains.
A logical data model is a more detailed model that helps add information to the elements in the conceptual model. It also helps define the structure of the data elements and define relationships between the entities. At this stage, there is still no primary or secondary key defined. There is no many-to-manyrelationshipsin this model.
A physicaldata model describes the databaseimplementation of the data model. This data model contains the relationships between the tables which address the cardinality. The columns now have exact data types and lengths assigned and also have primary and foreign keys defined.
Part 3:
Create aData Modelbased on the following information:
Bonus Question:
Page138 (textbook)
What to Submit
1. A single data diagram (use Visio or Draw.IO)