ER 모델링 실습

Conceptual Schema - ER 모델링 실습

모든 entity type은 따로 떨어져 있어야하면 안되고, PK가 꼭 존재해야한다.

1. Online Book store

Entity Type, Relationship Type, Attribute Type

• Cutomer
  • Customer ID --> Primary Key로 설정
  • Name(First name, Last Name) --> Composite Attribute로 설정
  • Address(Street, City, State, Zip Code) --> Composite Attribute로 설정
  • Phone Number
• Book
  • Title
  • ISBN --> Primary Key로 설정
  • Author(s) --> multi-valued로 설정
  • Publisher
  • Price
• Purchase
  • Number Of Copies
  • Date

2. Basketball Team

Entity Type, Relationship Type, Attribute Type

• Team

  • ID --> Primary Key로 설정
  • Name
  • Rank

• Player

  • SSN(Social Security Number) --> Primary Key로 설정
  • Name(First Name, Last Name) --> Composite Attribute로 설정
  • Height
  • Weight
  • Position(s) --> multi-valued로 설정

• Coach

  • SSN(Social Security Number) --> Primary Key로 설정
  • Name(First Name, Last Name) --> Composite Attribute로 설정
  • Salary

• Against

  • Date
  • Place