Databases

**i need it now**
Consider the following fragment of the Northwind Relational Database Schema (RDBMS)
and data. Note that a question mark after a column name indicates that the column is
nullable, and any primary key columns of each table are underlined


Q1. Suppose the above schema is implemented without specifying any integrity constraints.
List four different inconsistency problems that might occur while giving examples.
Q2. What referential integrity constraints are necessary for the above given schema?
Redraw/ Rewrite the relational schema diagram specifying the needed foreign keys.
Q3. Which strategies must be applied when deleting or updating a referenced primary key?
Give an explanation on why a particular strategy is chosen?
Q4. What is the consequence of deleting an Employee? What is the consequence of
updating a TID? In both cases, consider your answers in Q2 and Q3.
Q5. Can you reverse engineer the above RDBS? i.e., construct from the above relational
schema a corresponding entity-relationship diagram (ERD) considering your answer in Q2.
Be certain to indicate keys and show the participation and cardinality constraints