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)