Question

1. Create a Physical E-R data model for Linda's Hair Salon and Spa, showing how you went from a Logical to the Physical using best practices.

Answer 1

physical E-R data model:the physical E-R data model is also called as LOW LEVEL MODEL

physical E-R model designs DBMS CREATORS (OR) DBMS ADIMINISTRATORS

physical E-R model exists (or) contains some requriments are gives

above exmple in physical model Linda's Hair Salon and spa some requriments are gives

physical data model consists of the table structures ,columns names and values ,foregin and primary keys and the relationship among the tables

LOGICAL DATA MODEL:logical data model is also called as conceptual model

its consists the E-R diagrams