Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. EMPLOYEE (ename, fname, lname, salary, type, total_projects, programming language)
  2. Primary key = (enum)
  3.  
  4. project_emp (enum ,pnum)
  5. primary key (enum, pnum)
  6. Fkey1 = enum references employee
  7. fkey2 = pnum references project
  8.  
  9. PROJECT(pnum, title, budget, pnum, snum, snum, spec, ecdate)
  10. primary key (pnum, title, snum)
  11. fkey1 = snum references stage
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement