Homework Solution: Consider the following tables: PROJECT(PROJ CODE, PROJ_NAME, PROJ_D…

    Consider the following tables: PROJECTPROJ CODE, PROJ_NAME, PROJ_DESCRIPTION) EMPLOYEEEMP CODE, EMP_LNAME, EMP_FNAME, EMP TITLE, PROJ_CODE) For the tables given above, work on the problems below: 1. For each table, identify the primary key. 2. For each table, identify the foreign key(s). 3. Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key. 4. For one of the tables, give examples of a superkey and a secondary key. 5. For the given tables, explain how entity integrity and referential integrity could be violated. Give specific examples. 6. Use Visio to create a detailed Crows Foot ERD. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.
    Consider the following tables: PROJECT(PROJ CODE, PROJ_NAME, PROJ_DESCRIPTION) EMPLOYEE(EMP CODE, EMP_LNAME, EMP_FNAME, EMP TITLE, PROJ_CODE) For the tables given above, work on the problems below: For each table, identify the primary key. For each table, identify the foreign key(s). Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key. For one of the tables, give examples of a superkey and a secondary key. For the given tables, explain how entity integrity and referential integrity could be violated. Give specific examples. Use Visio to create a detailed Crow's Foot ERD. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.

    Expert Answer

     
    create PROJECT(PROJ_CODE VARCHA

    Consider the aftercited boards: PROJECTPROJ CODE, PROJ_NAME, PROJ_DESCRIPTION) EMPLOYEEEMP CODE, EMP_LNAME, EMP_FNAME, EMP TITLE, PROJ_CODE) For the boards affordn overhead, toil on the problems below: 1. For each board, fulfill the important guide. 2. For each board, fulfill the exotic guide(s). 3. 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. 4. For individual of the boards, afford specimens of a superguide and a subordinate guide. 5. For the affordn boards, decipher how existence honor and referential honor could be violated. Afford biased specimens. 6. Use Visio to form a specific Crows Foot ERD. The diagram must apprehend entire entities, attainments, and relationships. Important guides and exotic guides must be perspicuously authorized on the diagram.

    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.

    Expert Rejoinder

     

    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