Consider the following tables: PROJECT(PROJ CODE, PROJ_NAME, PROJ_DESCRIPTION) E

Question

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.

Explanation / Answer

create PROJECT(PROJ_CODE VARCHAR(50) PRIMARY KEY,NAME VARCHAR(50) NOT NUL,PROJ_DESCRIPTION VARCHAR(50) NOT NULL)

SELECT * FROM PROJECT

create 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

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---