Question: CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20),

CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID)

); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20),

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.

Step by Step Solution

★★★★★

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Ans d Error Violates uniqueness constraints b Error Violates domain constraints Here Db design... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related 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...

Explain how you reconcile the various positions to develop a cohesive ethical approach to human sexuality.

Find the smallest value of P for which the crate in Fig. P4.35 will be in equilibrium in the position shown. ( Hint : A rope can only support a tensile force.) Fig. P4.35 A 60% B 30 P

The following cross tabulation summarizes the data for two categorical variables, x and y. The variable x can take on values low, medium, or high and the variable y can take on values yes or no. a....

Use the information in Exercise 6-3. Assume that Trout Company specifically sold the following units: In Exercise 6.3 Trout Company uses a perpetual inventory system and made purchases and sales of a...

This exercise is based on the data sets associated with Figure 2.25 in Chapter 2. a. Use the SQL Data Definition Language to create a relational schema that consists of the following three relations:...

You must have completed Exercise 11 of Chapter 10 before beginning this exercise, and thus have used the SQL Data Definition Language to populate the tables for the three relations COMPANY, STUDENT,...

Phillip Morgan, the owner of Morgan Importing, makes periodic buying trips to various countries. During the trips, he keeps notes about the items he purchases and basic data about their shipments. He...

Harry Runkle has a weakness. He likes cars. The new Porsche Cayman looks so good on the showroom floor that he could barely control himself. He managed to escape the salesman but has been thinking...

Describe the strengths and weaknesses of the pre-trial testimony of expert witnesses Dr. Morgan Sain, Forensic Scientist Dale Ryan, and Dr. Leslie Torgeson and the forensic evidence on state v. sarah...

Mack's Juices produces and bottles a line of fruit juices. Themanufacturing process entails mixing and adding juices and otheringredients at the bottling plant, which is a part of BlendingDivision. 2...

Case Study Elegant Firm Parti: Recently you attended a presentation by Dr Ales, renowned entrepreneur and business leader, who spoke at length about the development of an accounting information...

1. Prepare a differential analysis to determine whether Wantum - Cardz should accept the special sales order. 2. Now assume that the Hall of Fame wants special hologram baseball cards. Wantum - Cardz...

JAGUAR LAND ROVER PLC: BOND VALUATION Jaguar Land Rover Automotive plc (JLR), a wholly owned subsidiary of the Indian company Tata Motors Limited, announced, on March 3, 2015, an issue of Senior...

Edward gets a $ 4 0 0 , 0 0 0 loan. His loan has a period of 1 0 years and an annual interest rate of 5 % . He pays equal payments every quarter, and his interest is compounded quarterly. What would...

Economic feasibility is an important guideline in designing cost accounting systems. Do you agree? Explain.

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...

Where do we go from here?

Class Exercise: Pick a stock market index of your choosing and obtain daily data on the value of the chosen index for five years to find out if the stock index is characterized by ARCH effects.

Generate two random walk series as indicated in Eqs. (21.7.1) and (21.7.2) and regress one on the other. Repeat this exercise but now use their first differences and verify that in this regression...