Explore BrainMass
Share

Entity Types and Relationships

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

There are many kinds of entity relationships in a database model. The relationships can be classified by the following things.

Cardinality: maximum and minimum
Degree: binary, ternary, degree 4, and so forth
Entity type: strong, weak, ID-dependent, and supertype/subtype

What are these different types of classifications? Do they overlap, or do they each tell us something unique about the entity relationship? Why is it important to classify each of these types in an ERD (entity relationship diagram) model?

© BrainMass Inc. brainmass.com October 25, 2018, 7:42 am ad1c9bdddf
https://brainmass.com/computer-science/databases/entity-types-and-relationships-512537

Solution Preview

Kindly find the enclosed document for the solution.

An entity-relationship model, a graphical representation of entities and their relationships to each other, is typically used in computing in regard to the organization of data within databases or information systems. An entity is a piece of data, an object or concept about which data is stored. A relationship on the other hand is how the data is shared between entities.

The basic types of connectivity for entity relations are:
- one-to-one,
- one-to-many,
- and many-to-many.

Each of them tells us about ...

Solution Summary

The basic types of connectivity for entity relations are:
- one-to-one,
- one-to-many,
- and many-to-many.

Each of them tells us about the unique feature of connectivity that they have among the entities in an ERD. This idea is illustrated with the example in given solution.

$2.19
See Also This Related BrainMass Solution

ERD Entity Relationship Diagram

ERD Entity Relationship Diagram - Visio is the preferred software for the Entity Relationship Diagrams. Your ERD should contain all 11 tables and should clearly flag all Primary keys, foreign keys and cardinality. Your ERD software should show the data types for each field (such as data, number, text etc.
I need Primary Keys only on these topics in the attachments Parts Inventory Purchases, Parts Inventory Issues, Parts Catalogue, Vendors, Parts Purchasing History, Vehicle Maintenance

View Full Posting Details