Question

1. Consider the following tables:

STORAGE(ST_CODE, ST_NAME, ST_LOCATION, ST_CONTACT)

ITEM(IT_CODE, IT_DESCRIPTION, IT_QUANTITY, ST_CODE)

For the tables given above, work on the problems below:

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 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.

Answer 1

Please do understand my concern, as per Chegg guidelines we are supposed to answer the first question if there is more than one question in a post, your downvote effects my career a lot, if I get a downvote for a wrong answer or incomplete answer I will accept it. Please give a positive rating

4)

the super key for REGION- REG_CODE,  REG_DESCRIPTION,

the super key for STORE - ST_CODE, ST_NAME

secondary key for REGION- REG_DESCRIPTION, REG_LOCATION

secondary key for STORE - ST_NAME, ST_MANAGER, REG_CODE

5)

entity integrity means the primary key cannot be null

the primary key for STORAGE is ST_CODE if it is null then it will cause entity integrity constraint

the primary key for STORE is IT_CODE if it is null then it will cause entity integrity constraint

ST_CODE is the foreign key for the ITEM table, so if the ST_CODE value is null in STORAGE then it causes referential integrity