Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EMPLOYEE (ename, fname, lname, salary, type, total_projects, programming language)
- Primary key = (enum)
- project_emp (enum ,pnum)
- primary key (enum, pnum)
- Fkey1 = enum references employee
- fkey2 = pnum references project
- PROJECT(pnum, title, budget, pnum, snum, snum, spec, ecdate)
- primary key (pnum, title, snum)
- fkey1 = snum references stage
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement