Tuesday, October 26, 2010

4.4 Entity Relationship Diagram


In our first entity group we have labelled as customer. Under customer we then have what information we might need from the customer to help our process flow more smoothly. We have their first name, last name, their home address, and as always a number to contact them. All of these different things that I just named off are known as attributes. Like previously mentioned, attributes help us label our customers with some sort of information. With our next entity group we have product. Under product we have the information about the cabin that our customer is interested in renting. In order to know this information we have the cabin that their interested in renting as a cabin number which allows us to narrow everything down to which exact cabin they are staying and all the different descriptions of that cabin. We also have the occupancy of that cabin and the description for other attributes. With our last entity group we have invoice and within invoice we have the cabin number again, description, price, tax, and the total price. With all this different information it helps us better understand our customer. If our customer wants to change something like for instance, which cabin they are wanting to stay in, the only thing we will have to do is pull up their name and all of this information will be listed. 


No comments:

Post a Comment