In this Entity Relationship Diagram, there are three main Entities : Customer, Invoice, and Product.
In each entity their are different attribute types, such as name, address, phone #, etc. A specific name such as John Smith is an Attribute. Each entity is viewed as having a table, each containing rows and columns. The rows being records and columns being attributes. Each attribute has its own data type dependent upon the type of information, such as name being text and phone # being integers. The customer entity contains attribute types such as Name, Address, and gender, it also contains a customer key, and ID number that is specific to the individual so it can be accessed by the other entities. The Product entity contains attribute types such as the type of product, the price and the Product key. Like the customer key it is a reference key used to compare and correlate data in other entites.
In each entity their are different attribute types, such as name, address, phone #, etc. A specific name such as John Smith is an Attribute. Each entity is viewed as having a table, each containing rows and columns. The rows being records and columns being attributes. Each attribute has its own data type dependent upon the type of information, such as name being text and phone # being integers. The customer entity contains attribute types such as Name, Address, and gender, it also contains a customer key, and ID number that is specific to the individual so it can be accessed by the other entities. The Product entity contains attribute types such as the type of product, the price and the Product key. Like the customer key it is a reference key used to compare and correlate data in other entites.
No comments:
Post a Comment