Consider the aftercited boards: PROJECT(PROJ CODE, PROJ_NAME, PROJ_DESCRIPTION) EMPLOYEE(EMP CODE, EMP_LNAME, EMP_FNAME, EMP TITLE, PROJ_CODE) For the boards affordn overhead, toil on the problems below: For each board, fulfill the important guide. For each board, fulfill the exotic guide(s). Fulfill at lowest individual canvasser guide. If there are no canvasser guides, afford an specimen of an attainment that could be used as a canvasser guide. For individual of the boards, afford specimens of a superguide and a subordinate guide. For the affordn boards, decipher how existence honor and referential honor could be violated. Afford biased specimens. Use Visio to form a specific Crow’s Foot ERD. The diagram must apprehend entire entities, attainments, and relationships. Important guides and exotic guides must be perspicuously authorized on the diagram.
form PROJECT(PROJ_CODE VARCHAR(50) PRIMARY KEY,NAME VARCHAR(50) NOT NUL,PROJ_DESCRIPTION VARCHAR(50) NOT NULL)
SELECT * FROM PROJECT
form EMPOLYEE(EMP_CODE INT PRIMARY KEY,EMP_LNAME VARCHAR(50) NOT NUL,EMP_FNAME VARCHAR(50) NOT NULL,EMP_TITLE VARCHAR(50) NOT NUL,PROJ_CODE VARCHAR(50) NOT NULL)
SELECT * FROM EMPOLYEE