Er Diagram

Video Encryption/ Sharing Sevice

Adam McDonald Susan Seley Steve Mesa

ER Diagram Revision November 29, 2006 Term PK PurchasedVideo PK,FK2 PK,FK1

1

term_id

1

price duration

term_id trans_id tkey

PublishedVideo PK

video_id

FK1

owner title category description url length size resolution format quality skey min_age connect_rating

Comment

1

PK,FK1 PK,FK2

0..*

video_id username

1

0..*

Keyword PK,FK1 PK

Account

0..*

comment rating

1

PK

1..*

1 FK1 video_id

video_id keyword

1

0..*

username password firstname midinit lastname dob street_addr city state zipcode phone_num email balance_usd

1

1 1 Transaction

0..*

1 1

FK1

0..*

paypal_id username paypal_email

0..1 0..*

credit_id

FK1

username firstname midinit lname number exp_month exp_year cvv2

FK4

username date type credit_id bank_id paypal_id amount_usd

FK3 FK2 FK1

0..*

Credit PK

trans_id

Paypal

0..* PK

1

PK

0..1 Bank

0..*

PK

bank_id

FK1

username bank_name routing_num account_num

0..1

0..*