Question: Identify and describe the components of the table shown in
Identify and describe the components of the table shown in Figure Q3.17, using correct terminology. Use your knowledge of naming conventions to identify the table’s probable foreignkey(s).
Answer to relevant QuestionsIdentify the foreign keys.A database user manual notes that, “The file contains two hundred records, each record containing nine fields.” Use appropriate relational database terminology to “translate” that statement.Create the relational diagram to show the relationship between STORE and REGION.Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.For each table, where possible, identify:a. The primary keyb. A superkeyc. A candidate keyd. The foreign key(s)e. A secondary key
Post your question