На головну

Column List

  1. Column DIVNUM
  2. Column List
  3. Column List
  4. Column PRONUM
  5. Draw lines between the columns to make true sentences about jobs in A opposite.
  6. III. Taking turns with your partner cover each of the columns and encourage each other to provide translation for the given words.
Name Code Type P M
Material number
MATNUM numeric(5) Yes Yes
Material name
MATNAME char(30) No Yes
Material type
MATTYPE char(30) No Yes

Column MATNUM

Column MATNAME

Column MATTYPE

Index List

Index Code P F U C Column Code Sort
MATERIAL_PK
Yes No Yes No MATNUM ASC

Reference by List

Referenced by Primary Key Foreign Key
COMPOSE
MATNUM COMPNUM
COMPOSE
MATNUM MATNUM
USED
MATNUM MATNUM

Table Member

Name: Member
Code: MEMBER
Label:
Number:
PK constraint:
Source: Relationship MEMBER

Column List

Name Code Type P M
Team number
TEANUM numeric(5) Yes Yes
Employee number
EMPNUM numeric(5) Yes Yes

Column TEANUM

Column EMPNUM

Index List

Index Code P F U C Column Code Sort
MEMBER_PK
Yes No Yes No TEANUM EMPNUM ASC ASC

Reference to List

Reference to Primary Key Foreign Key
TEAM
TEANUM TEANUM
EMPLOYEE
EMPNUM EMPNUM

Table Participate

Name: Participate
Code: PARTICIPATE
Label:
Number:
PK constraint:
Source: Entity PARTICIPATE

Column List

Name Code Type P M
Project number
PRONUM numeric(5) Yes Yes
Task name
TSKNAME char(30) Yes Yes
Employee number
EMPNUM numeric(5) Yes Yes
Start date
PARBEG timestamp No No
End date
PAREND timestamp No No

Column PRONUM

Column TSKNAME

Column EMPNUM

Column PARBEG

Column PAREND



Column DIVNUM | Index List

Graph of submodel Employee management | Column List | Column List | Column PRONUM |

© um.co.ua - учбові матеріали та реферати