hw7

Tables (10)

ATTRIBITE (Untitled4)

  • attribute_id (PK) — Primary key — NOT NULL
  • relation_id (PK2) — Foreign key → RELATION.relation_id — NOT NULL
  • db_id (PK22) — Foreign key → RELATION.db_id — NOT NULL
  • DBMS_NAME (PK222) — Foreign key → RELATION.DBMS_NAME — NOT NULL
  • attribite_name (Field)
  • data_type (Field2)
  • is_pk (Field3)

DATABASE (Untitled2)

  • db_id (PK) — Primary key — NOT NULL
  • DBMS_NAME (PK2) — Foreign key → DBMS.DBMS_NAME — NOT NULL
  • db_name (Field)

DBA (Untitled10)

  • login_id (Key) — Foreign key → PROGRAMMER.login_id — NOT NULL
  • code (Key2) — Foreign key → PROGRAMMER.code — NOT NULL

DBMS (Untitled)

  • DBMS_NAME (PK) — Primary key — NOT NULL
  • prog_name (PK2) — Foreign key → PROGRAM.prog_name — NOT NULL
  • Prog_extension (PK22) — Foreign key → PROGRAM.Prog_extension — NOT NULL
  • login_id (Key) — Foreign key → PROGRAM.login_id — NOT NULL
  • code (Key2) — Foreign key → PROGRAM.code — NOT NULL

GENERAL_USER (Untitled7)

  • login_id (Key) — Primary key — NOT NULL
  • prog_name (PK) — Foreign key → PROGRAM.prog_name — NOT NULL
  • Prog_extension (PK2) — Foreign key → PROGRAM.Prog_extension — NOT NULL
  • login_id (Key2) — Foreign key → PROGRAM.login_id — NOT NULL
  • code (Key22) — Foreign key → PROGRAM.code — NOT NULL

LANGUAGE (Untitled6)

  • language_name (PK) — Primary key — NOT NULL

PROGRAM (Untitled5)

  • prog_name (PK) — Primary key — NOT NULL
  • Prog_extension (PK2) — Primary key — NOT NULL
  • login_id (Key) — Foreign key → PROGRAMMER.login_id — NOT NULL
  • code (Key2) — Foreign key → PROGRAMMER.code — NOT NULL
  • date (Field)
  • description (Field2)
  • version_num (Field3)
  • language_name (PK3) — Foreign key → LANGUAGE.language_name — NOT NULL

PROGRAMMER (Untitled9)

  • login_id (Key) — Primary key — NOT NULL
  • code (Key2) — Primary key — NOT NULL
  • Field

PROGRAM_CALLS (Untitled8)

  • prog_name (PK) — Foreign key → PROGRAM.prog_name — NOT NULL
  • Prog_extension (PK2) — Foreign key → PROGRAM.Prog_extension — NOT NULL
  • login_id (Key) — Foreign key → PROGRAM.login_id — NOT NULL
  • code (Key2) — Foreign key → PROGRAM.code — NOT NULL

RELATION (Untitled3)

  • relation_id (PK) — Primary key — NOT NULL
  • db_id (PK2) — Foreign key → DATABASE.db_id — NOT NULL
  • DBMS_NAME (PK22) — Foreign key → DATABASE.DBMS_NAME — NOT NULL
  • relation_name (Field)