Consider the following fragment of the Northwind Relational Database Schema (RDBMS) and data. Note that a...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
Explain how to maintain an information system for pine valley furniture s webstore.?
-
8. A straight section of railroad track crosses two highways 400 m and 600 m from an intersection. Find the dimensions of the largest rectangular lot that can be laid out in the triangle formed by...
-
1. Find the probability of obtaining between 40 and 60 heads when tossing a coin 100 times. 2. Find the probability of obtaining 6s between 20 and 40 times when rolling a die 200 times.
-
How might being charismatic contribute to the effectiveness of the manager of entry-level workers, such as those employed as cashiers of fast-good preparers?
-
On April 1, 2016, Big Spring Corporation issued $400,000 face value, 10 percent bonds at 99.16. The bonds were dated April 1, 2016, and will mature in 10 years. The discount is to be amortized on...
-
On January 1, 2018, Ranier, Inc., issued \(\$ 300,000\) of ten percent, 15 -year bonds for \(\$ 351,876\), yielding an effective interest rate of eight percent. Semiannual interest is payable on June...
-
A policy analyst is attempting to determine which mechanisms are most effective in resolving problems brought by citizens to local government. The analyst has broken down the mechanisms into two...
-
An example of an'agency relationship' is... A. The relationship between the owner of a company and the manager they've hired to run the company. B. The relationship between shareholders and the...
-
The A-36 steel wires AB and AD each have a diameter of 2 mm and the unloaded lengths of each wire are LAC = 1.60 m and LAB = LAD = 2.00 m. Determine the required diameter of wire AC so that each wire...
-
Why don't more firms use lockouts to break impasses? What conditions are necessary for mediation to assist in settling an impasse? Do you believe the present rights given to strikers by the NLRB are...
-
Jonathan Thompson has the following net 1231 results for each of the years shown. What would be the character of the net gains in 2019, 2021 and 2022? Tax Year 2018 2019 2020 Net 1231 Loss $8,000...
-
What is the output of the following code, In visual basic Function SubStr( St As String) As String Sum=1 for x=1 to 8 if x mod 20 then S=Mid(St, x, x*2) S=Mid(St, x, x+2) Else End if Next x SubStr=S...
-
Q1: Describe the Changes Clause including how it is invoked/applied, the benefits to both the government and the contractor and how issues resulting from the Changes Clause are resolved. Q2: Describe...
-
Comparative Statement of Financial Position for 2 0 X 4 and 2 0 X 3 , a Statement of income for 2 0 X 4 , and additional information from the accounting records of Olaniyi Industries, are provided...
-
Provide your perspective on the Kelly v. United States. Discuss why you agree or disagree with the outcome, your reasoning, and support your perspective using supporting evidence in the form of...
-
Total (gross) revenues per month $ 27,000 less explicit costs: Cost of merchandise sold $ 17,000 Wages to cashier, stock, and delivery help 2,500 Rent and utilities 800 Taxes 700 Total explicit costs...
-
Find the intercepts and then graph the line. (a) 2x - 3y = 6 (b) 10 - 5x = 2y
-
Describe and contrast the various cloud computing service models.
-
Read the narratives below and follow the directions for each. If you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Supply these extra explanations...
-
Find out which, if any, drawing packages, word processors, forms design, and database management systems your university or company supports. Research these packages to determine how they might be...
-
Cash larceny involves the fraudulent stealing of an employer's cash. These schemes often target the company's bank deposits. The fraudster steals the money after the deposit has been prepared, but...
-
Describe the four types of data analytics.
-
The corporate social responsibility highlighted in this chapter (see page 585) mentions that Home Depot believes in giving back. One of the ways the company has done this is through its Team Depot...
Study smarter with the SolutionInn App