123 School Work

Database ManagementERD and database table relationships

• This is a preview of the essay.
  To view the full text you must login!
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
       There are many relationships that the Entity Relationship Model, or ERD and database tables share. These relationships are very important to the progression of a completed database. When one analyzes the database tables, it can be realized that there is a need to show a representation between the database tables. By creating an ERD, the relationship between the database tables can be formally represented. Understanding the relationship between the ERD and the database table is an important part of the creation of a good database.
       One of the important relationships the ERD and the database tables have is what is called the entity. The entity is an ERD term for a table. The entity, like the table, is an object or concept that contains data. The data that resides both in the table and the entity is common to that specific table or entity. Figure 1...