Consider the following fragment of the Northwind Relational Database Schema (RDBMS) and data. Note that a...

 

Transcribed Image Text:

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. TID '20852' '30346' Territory TDes 'Rockville' 'Atlanta' '01833' 'Georgetown' '01730' 'Bedford' '06897' 'Wilton' '02903' 'Providence' '85014' 'Phoenix' Employee Territory EID TID 1 '06897' 2 '01730' '01833' '30346' '20852' '02903' '85014' '06897' 2 3 4 5 6 7 RID 1 4 1 1 1 1 2 EID 1 2 3 4 5 6 7 Employee Ename 'John' 'Sam' 'Edward' 'Susan' 'Peter' 'Alexandra' 'Charlotte' RID 1 2 3 4 Region Now, answer the following questions regarding the above schema. RTO? 2 NULL 2 2 2 5 5 RDes 'Eastern' 'Western' 'Northern' 'Southern' 01. Sunnose the above schema is implemented without cnerifying any integrity constraints 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. 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. TID '20852' '30346' Territory TDes 'Rockville' 'Atlanta' '01833' 'Georgetown' '01730' 'Bedford' '06897' 'Wilton' '02903' 'Providence' '85014' 'Phoenix' Employee Territory EID TID 1 '06897' 2 '01730' '01833' '30346' '20852' '02903' '85014' '06897' 2 3 4 5 6 7 RID 1 4 1 1 1 1 2 EID 1 2 3 4 5 6 7 Employee Ename 'John' 'Sam' 'Edward' 'Susan' 'Peter' 'Alexandra' 'Charlotte' RID 1 2 3 4 Region Now, answer the following questions regarding the above schema. RTO? 2 NULL 2 2 2 5 5 RDes 'Eastern' 'Western' 'Northern' 'Southern' 01. Sunnose the above schema is implemented without cnerifying any integrity constraints 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.