Question

***** this is question and answer i just need the schema

Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

Data Modeling:- Data Modeling is the first step in database designing.It is the representation of data model, or collected data. Also shows that collected data stored in database and linked with each data such as entities,objects and relationship between these data entities.Data modeling is the most important and initial step in creating data models it also referd to as a conceptual model.Data modeling is the process of creating data model and desiging database which are used to stor the related data in the form of row and columns in tables.

Conceptual data model vs Physical data model:-

CONCEPTUAL DATA MODEL:-

1. Conceptual data model is stratigy based data model it expalins the whole system.

2. Conceptual data model holds the summaries details of database such as number of entity,attributes and relaionship between them.

3. It includes the high-level data model record such as definations of all entities and working activity of whole data model.

4. It addresses digital and non-digital concepts of database model. development and desiging is initial for the system database.

Physical data model:-

1. Physical data model is the representation of internal structure of the data base model such as it shows the structure of tables and data records in the tables.

2. It also describes the data requirements of the system.

3. It shows the other database which are linked with one another to share some entities and IDs.

4. It includes the physical objects in physical data model such as primary key,foreign key , view and storage procedures etc.

CONTRAST:-

Physical data model:- Physical data model is the actual representation of database such as it shows the data stored in the tables in form of rows and columns.

Example:- Table student holds student_name, Rollno and Class_name etc.

Conceptual data model:- Conceptual model defines the data records such as entities, attributs and relationship between these entities.

Example:- Entity Bool have Attributes such as author name adition etc and relationship between book and author of book.

Answer 1

Schemas for Conceptual data model and Physical data model

I have created these 2 schemas in refrence to a country whose each city has its own team and they play games with different teams of different cities. each team has certain number of players and 2 or 3 coaches.

CONCEPTUAL DATA MODEL-

• Highly abstract
• Easily understood
• Easily enhanced
• Only "Entities" visible
• Abstract Relationships
• No software tool is required to define a Conceptual Data Model

PHYSICAL DATA MODEL-

• Entities referred to as Tables
• Attributes referred to as Columns
• Database compatible table names
• Database compatible column names
• Database specific data types
• Difficult for users to understand
• Significantly more effort required to enhance in comparison to Conceptual and Logical Model
• Difficult to port to a different database, once design is finalized.
• Tools like ERWin and PowerDesigner can help in automatically porting over the Logical Data Model to Physical Data Models of different versions.

If any doubt, please feel free to ask and comment, i would like to answer them.
Thank you