Relationships in a database model

Assignment Help Data Structure & Algorithms

Reference no: EM1380235

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

Discuss different types of classifications and 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?

Reference no: EM1380235

Questions Cloud

Miles per gallon application : All average calculations should produce floating- point results. Avoid division by zero- if the user enters zero for the number of gallons, in-form the user that the input value for gallons must be greater than zero.

Data warehouse and operational databases : Every big organization has large documents or databases containing data used in operating the business. Does a data warehouse differ from these operational files or databases?

Designing and populating a course table : Use data to design and populate a course table. Designate the CourseID field as a Primary Key and permit your database to automatically produce a value for this field.

Water resources engineering : The current practice of a particular part of water resources engineering is supported through a variety of commercial software. Pick a specific domain within water resources engineering.

Relationships in a database model : Discuss different types of classifications and do they overlap, or do they each tell us something unique about the entity relationship?

Gas pump - compute the total cost from the number of gallons : Write a program that will help an elementary school student learn multiplication and compute the total cost from the number of gallons entered and the selected grade.

Creating a database with asp.net : Make a database with a table called "MyUsers" and "MyRole" The table should have the following columns.

Questionm about distributed database : Explain what a distributed database is and how replication works with respect to managing the information in these databases.

Developing a new customer order entry system : The system development team at Wilson Corporation is working on developing a new consumer order entry system. In the process on designing the new system,

User Account

All Pages