CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20), PRIMARY KEY (ID), FOREIGN KEY (DesignerID) REFERENCES DBDesigner (ID) ); Consider the following data in DBDesigner 1234567 Eric Schwabe 3456789 Janine Spears 5678901 Will Marrero 7890123 Cynthia Putnam and the following data in DesignTask 11111 1234567 Urgent 22222 1234567 Low 33333 5678901 Low 44444 7890123 High If you were to insert the following statement INSERT INTO DBDesigner VALUES ('3456789', 'Bruce Wayne'); What will happen? Error. Violates referential integrity constraints Error. Violates domain constraints No error. Does not violate nay constraint. Error. Violates uniqueness constraints. CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20), PRIMARY KEY (ID), FOREIGN KEY (DesignerID) REFERENCES DBDesigner (ID) ); Consider the following data in DBDesigner 1234567 Eric Schwabe 3456789 Janine Spears 5678901 Will Marrero 7890123 Cynthia Putnam and the following data in DesignTask 11111 1234567 Urgent 22222 1234567 Low 33333 5678901 Low 44444 7890123 High If you were to insert the following statement INSERT INTO DBDesigner VALUES ('3456789', 'Bruce Wayne'); What will happen? Error. Violates referential integrity constraints Error. Violates domain constraints No error. Does not violate nay constraint. Error. Violates uniqueness constraints. CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20), PRIMARY KEY (ID), FOREIGN KEY (DesignerID) REFERENCES DBDesigner (ID) ); Consider the following data in DBDesigner 1234567 Eric Schwabe 3456789 Janine Spears 5678901 Will Marrero 7890123 Cynthia Putnam and the following data in DesignTask 11111 1234567 Urgent 22222 1234567 Low 33333 5678901 Low 44444 7890123 High If you were to insert the following statement INSERT INTO DBDesigner VALUES ('3456789', 'Bruce Wayne'); What will happen? Error. Violates referential integrity constraints Error. Violates domain constraints No error. Does not violate nay constraint. Error. Violates uniqueness constraints. CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20), PRIMARY KEY (ID), FOREIGN KEY (DesignerID) REFERENCES DBDesigner (ID) ); Consider the following data in DBDesigner 1234567 Eric Schwabe 3456789 Janine Spears 5678901 Will Marrero 7890123 Cynthia Putnam and the following data in DesignTask 11111 1234567 Urgent 22222 1234567 Low 33333 5678901 Low 44444 7890123 High If you were to insert the following statement INSERT INTO DBDesigner VALUES ('3456789', 'Bruce Wayne'); What will happen? Error. Violates referential integrity constraints Error. Violates domain constraints No error. Does not violate nay constraint. Error. Violates uniqueness constraints.
Expert Answer:
Answer rating: 100% (QA)
Ans d Error Violates uniqueness constraints b Error Violates domain constraints Here Db design... View the full answer
Related Book For
Practicing Statistics Guided Investigations for the Second Course
ISBN: 978-0321586018
1st edition
Authors: Shonda Kuiper, Jeff Sklar
Posted Date:
Students also viewed these accounting questions
-
If you were to consider buying a School of Rock franchise, what issues would concern you the most about your ability to be successful as a franchisee for this company?
-
What audit procedures might you perform if you were to decide that the risk of fraud involving the cash account was relatively high for this client?
-
If you were to draw an age structure diagram for Poland, with a total fertility rate of 1.3, which of the following overall shapes would the diagram have? Explain why a country like Poland faces a...
-
What is a safe edge on a file?
-
Using the information in SE5-12B, calculate the gross profit from the sale and the gross profit ratio. Assume the customer does not pay within the discount period. In SE5-12B, Sams Supply, Inc., uses...
-
The Condé Nast Traveler Gold List for 2012 provided ratings for the top 20 small cruise ships (Condé Nast Traveler website, March 1, 2012). The data shown below are the...
-
If the yield to maturity on a two-year zero coupon bond is 13 per cent and the yield to maturity on a one year zero coupon bond is 10 per cent, what is the expected spot rate of one-year bonds in one...
-
The balances in the perpetual inventory accounts of Anditon Manufacturing Corporation at the beginning and end of the current year are as follows: The total dollar amounts debited and credited during...
-
16) For any consumer, the sum of their marginal propensity to consume, their marginal propensity to save, and their marginal propensity to import would always be A) negative . B) less than one. C)...
-
A nutrition plan app has a subscription that costs $10/month. The following chart gives average historical renewal rates for subscribers based on how many months they have been a subscriber. Month 1...
-
Which characteristic would suggest a tax is progressive? Explain.
-
In which way is the position reported by the wheel sensor indicating direction of motion? What happen when you rotate the IOLab around ( lift it up , do a 1 8 0 degree rotation and put it back down...
-
If you are concerned about hedging against the risk of widening credit spreads, would you use a Total Return of Credit Default Swap?
-
Suppose you are the payroll manager of a large manufacturing company operating in multiple locations. You are switching to a new payroll and scheduling software. You need to train 30 managers and...
-
Concisely and precisely explain the meaning and the implications of "risk reduction by pooling of losses". What are the key underlying assumptions?
-
Your answer is incorrect. Gary received dividend income from the following sources: $1,530 Met Life Insurance Company $1,900 Mexico Manufacturing Company $740 Schwab mutual fund $2,800 fair market...
-
We subtract the depreciation expense before we calculate the taxes. True False
-
Distinguish between the work performed by public accountants and the work performed by accountants in commerce and industry and in not-for-profit organisations.
-
Is Distracter a fixed or random factor? Provide a justification for your answer.
-
Create a Hasse diagram for Josh and Anns memory study corresponding to Question 1. Use the Hasse diagram to find the corresponding statistical model.
-
Explain why multicollinearity is a problem for researchers who are hoping to test whether specific explanatory variables impact the response (i. e., confirm a theory). Then explain why...
-
The Arcadia Company is contemplating a large capital investment of \($32\) million in new productionline equipment, which is expected to have a useful life of six years, a residual value of \($2\)...
-
San Joaquin Company began exploration of oil in Texas by paying \($600,000\) for the drilling rights on a large tract of land. The company drilled 10 oil wells on the land. Seven of the wells were...
-
The Arcadia Company is contemplating a large capital investment of \($32\) million in new productionline equipment, which is expected to have a useful life of six years and a residual value of \($2\)...
Study smarter with the SolutionInn App