DB_module

Tables (15)

ArtGroup (Untitled5)

  • Kind_of_Art (Key) — Primary key — NOT NULL

Artist (Untitled3)

  • Artist_name (Key) — Primary key — NOT NULL
  • Birthplace (Field)
  • Age (Field2)
  • Style (Field3)

Artwork (Untitled4)

  • Title (Key) — Primary key — NOT NULL
  • Year (Field)
  • Type_of_Art (Field2)
  • Price (Field3)
  • Artist_name (Key2) — Foreign key → Artist.Artist_name — NOT NULL

Course Session(Bridge) (Untitled13)

  • Course_ID (Key) — Foreign key → Courses.Course_ID — NOT NULL
  • Session_ID (Key2) — Foreign key → Training Session.Session_ID — NOT NULL
  • Trainee_ID (Key3) — Foreign key → Trainee.Trainee_ID — NOT NULL

Courses (Untitled9)

  • Course_ID (Key) — Primary key — NOT NULL
  • Course_Name (Field)
  • Team_ID (Key2) — Foreign key → Teaching Team.Team_ID — NOT NULL
  • Inst_ID (Key22) — Foreign key → Teaching Team.Inst_ID — NOT NULL

Grouped (Untitled6)

  • Title (Key) — Foreign key → Artwork.Title — NOT NULL
  • Kind_of_Art (Key2) — Foreign key → ArtGroup.Kind_of_Art — NOT NULL

Instructor (Untitled7)

  • Inst_ID (Key) — Primary key — NOT NULL
  • Inst_Name (Field)

Product (Untitled)

  • Pct_Code (Key) — Primary key — NOT NULL
  • Price (Field2)
  • Description (Field)

Region

  • Reg_Code (Dep_ID) — Primary key — NOT NULL
  • Name (Field)

Research (Untitled11)

  • Res_ID (Key) — Primary key — NOT NULL
  • Inst_ID (Key2) — Foreign key → Instructor.Inst_ID — NOT NULL
  • Res_Name (Field)

Sell (Untitled2)

  • Str_Code (Emp_ID) — Foreign key → Store.Str_Code — NOT NULL
  • Pct_Code (Key) — Foreign key → Product.Pct_Code — NOT NULL

Store (Employee)

  • Str_Code (Emp_ID) — Primary key — NOT NULL
  • Address (Field)
  • Reg_Code (Dep_ID) — Foreign key → Region.Reg_Code — NOT NULL

Teaching Team (Untitled10)

  • Team_ID (Key) — Primary key — NOT NULL
  • Inst_ID (Key2) — Foreign key → Instructor.Inst_ID — NOT NULL

Trainee (Untitled8)

  • Trainee_ID (Key) — Primary key — NOT NULL
  • Trainee_Name (Field)

Training Session (Untitled12)

  • Session_ID (Key) — Primary key — NOT NULL
  • Session_Name (Field)