Re: Newbie needs help with E/R model

Comments appended to your lines...

Stu

> Movies:
> -sku (ID #)
> -title
> -year
> -price (Are certian movies for sale? or cheep rental because they are
old?)
> -format (i.e., vhs, dvd) (Entity)
> -condition (i.e. rental, new for sale, used for sale) (What govers each of
these atributes?)

> -genre
>
> Branch:
> -store ID#
> -phone no.
> -address (Entity)
>
> Members:
> -account no.
> -name
> -address (Entity)
> -phone no. (Can members have more than one phone number? Entity?)
> -credit card no. (Can members have more than one card? Entity?)
>
> Stars:
> -name
>
> I don't know how I could get closer to 10 entities. It took me long
> enough to come up with 5! Am I maybe giving each entity too many
> attributes?
>
> Here are the relationships I thougt of:
>
> rented(member, movie) date_from, date_thru
> memberOf(member, branch) date_from, date_thru
> starsIn(star, movie)
>
> I still need 7 relationships. Any help or hints are greatly
> appreciated!
> Rob
>
>
> StarsIn (movies, stars)
Received on Fri Jun 06 2003 - 15:21:24 CEST