Friday, October 15, 2010

Blog 4.4- Entity Relationship Diagram

This ERD shows the relationship between three database tables. Each table has a different number of attribute types relating to a single entity; such as the attribute type: customer key relating to the entity: customer. Each attribute has a data type like the attribute type: name would have the data type: text and the attribute: phone would have the data type: number. An attribute of an attribute type would go into more detail; for example name would have an attribute of Tom. Once a entity is complete, the table is called a record. An invoice has many records within it. 

No comments:

Post a Comment