
	Home


	Homework Help


	Answer Board


	Resources (Beta)

You Are Here:

Home > Answer Board > Computer Science > Topic: Computer Science

Member's Topic Headline:

Computer Science

Know the answer? Have a better solution? Share it.

Join the thousands of students
getting ahead in their classes.

Member Testimonials

Question:

Answers:

Cramster Expert

Isabeli(CS SME)

(Cramster SME)

Cramster In-House Subject Matter Expert

Date Posted: 5/30/2008 2:19:54 AM Status: Live

Asker's Rating: Helpful

Response:

Dear,

A)
Many- to- Many relation ship with an entity:
When an instance of an entity may be related to multiple instances of another entity and vice versa, that is called a “many-to-many relationship".

Example: Supplier may provide many different products, and each type of product may be offered by many suppliers:

Multivalued Attribute:

A multivalued attribute M of an entity E is represented by a separate table EM

Table EM has attributes corresponding to the primary key of E and an attribute corresponding to multivalued attribute M

CustomerNumber	CustomerName	AccountBalance	CustomerPhone
14112	james	114.53	555-1212 555-3434
15267	rita	453.78	555-2424
34589	meer	543.30	555-6774 555-3443

Here CustomerPhone is MultiValued.

sheryf's Comment:

good

unixlearner

Scholar

Karma Points: 259

Date Posted: 5/30/2008 2:53:25 AM Status: Live

Asker's Rating: None Provided Moderator's Rating: Somewhat Helpful

Response:

Entity:
In database, an entity is a single person, place, or thing about which data can be stored.
Entity Instance:
A specific occurence of a defined business object that is eventually represented as a row in a table.

I did my best to answer your question. You do your best to rate me High. :-)

By reading or posting messages on these forums, you are agreeing to the Answer Board's Terms of Service and Conduct (TSC).

Computer Science

Question:

Advertisement:

Answers: