4. What Are The Features Of A Physical Data Model?

What Are The Features Of A Physical Data Model?

Answer

  1. Specification all tables and columns.
  2. Foreign keys are used to identify relationships between tables.
  3. Denormalization may occur based on user requirements.
  4. Physical considerations may cause the physical data model to be quite different from the logical data model.
  5. Physical data model will be different for different RDBMS. For example, data type for a column may be different between MySQL and SQL Server.

All database-design Questions
Ask your interview questions on database-design

Write Your comment or Questions if you want the answers on database-design from database-design Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---