× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
o
5
4
m
4
b
4
x
4
a
4
l
4
t
4
S
4
m
3
s
3
New Topic  
asjstr asjstr
wrote...
Posts: 465
Rep: 8 0
5 years ago
Describe and discuss the main elements of the Entity-Relationship (E-R) model. Include an example.
Textbook 
Database Processing: Fundamentals, Design, and Implementation

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 34 times
1 Reply

Related Topics

Replies
wrote...
5 years ago
The E-R model is basically made up of entities, attributes and relationships. Entities represent the things people want to keep track of, such as customers and products. Each "thing" is presented by an entity or entity class–in this case CUSTOMER and PRODUCT. Individual members of each entity class are called entity instances–for example CUSTOMER John Smith and PRODUCT Canned Tomato Soup. Each entity is described by a set of attributes. For example, a CUSTOMER will have a CustomerNumber, a LastName and a FirstName, while a PRODUCT will have a ProductNumber and a Description. These, of course, have specific values for each entity instance. Finally, the entities are connected by relationships. There are relationship classes between entity classes and relationship instances between entity instances. For example, in general a CUSTOMER buys a PRODUCT, and a PRODUCT is sold to a CUSTOMER. Specifically, CUSTOMER John Smith buys a PRODUCT Canned Tomato Soup.
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1096 People Browsing
Related Images
  
 473
  
 234
  
 316
Your Opinion
Which of the following is the best resource to supplement your studies:
Votes: 249

Previous poll results: What's your favorite math subject?