Question

Suppose a user creates a new relation r1 with a foreign key referencing another relation r2....

Suppose a user creates a new relation r1 with a foreign key referencing another relation r2. What authorization privilege does the user need on r2? Why should this not simply be allowed without any such authorization?

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Given that the user created a new relation r1 with a foreign key and using this foreign key the user is referencing to another relation r2.

  • In order to create a foreign key constraint the REFERENCES privilege is to be obtained on the parent table.
  • The column referenced by r1 in r2 should be a primary key. This is because the column referenced should not be having NULL values
  • The datatype for the column that is defined as foreign key in r2 and the column which is referenced in r1 should be same.

Hope it helps!!!

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Instructions: Step 1: Create UNF Relation from a User View. The goal here is to create...
Instructions: Step 1: Create UNF Relation from a User View. The goal here is to create a single relation for the data found in the user view. The method used is: •   Examine the user view •   Identify all attributes •   Describe the user view using DBDL Here is an example of a user view. This reports lists the customers of the Premiere Corporation. Premiere Corporation Customer List CustNo   Name   Street   City   State   ZipCode   SalesRepNo 124    Sally Adams   482...
1.Suppose that you are a foreign exchange trader for a bank based in New York. You...
1.Suppose that you are a foreign exchange trader for a bank based in New York. You are faced with the following market rates: Spot exchange rate: SFr 0.9845/$. 6 month dollar interest rate = 1.0% per annum 6 month Swiss franc interest rate = 0.25% per annum 6 month forward exchange rate: = SFr 0.9785/$ a) Is there a Covered Interest Arbitrage (CIA) opportunity here? Explain why or why not. b) Given the data in part (a), spell out the...
Relations and Functions Usual symbols for the above are; Relations: R1, R2, S, T, etc Functions:...
Relations and Functions Usual symbols for the above are; Relations: R1, R2, S, T, etc Functions: f, g, h, etc. But remember a function is a special kind of relation so it might turn out that a Relation, R, is a function, too. Relations To understand the symbolism better, let’s say the domain of a relation, R, is A = { a, b , c} and the Codomain is B = { 1,2,3,4}. Here is the relation: a R 1,    ...
In this lab, you will write a program that creates a binary search tree based on...
In this lab, you will write a program that creates a binary search tree based on user input. Then, the user will indicate what order to print the values in. **Please write in C code** Start with the bst.h and bst.c base code provided to you. You will need to modify the source and header file to complete this lab. bst.h: #ifndef BST_H #define BST_H typedef struct BSTNode { int value; struct BSTNode* left; struct BSTNode* right; } BSTNode; BSTNode*...
Suppose that you are a foreign exchange trader for a bank based in New York. You...
Suppose that you are a foreign exchange trader for a bank based in New York. You are faced with the following market rates: Arbitrage funds available                                                          $ 5,000,000 Spot exchange rate (kr/$)                                                          6.1717 (i.e., 1 dollar = 6.1717 krones) 3-month forward rate (kr/$)                                                       6.1981 U.S. dollar interest rate                                                             4.000 % per annum Danish krone interest rate                                                          4.950 % per annum Note: The maximum amount you may invest is $5,000,000 or its equivalent in Danish krones....
BYP5-7 Jacquie Boynton was just hired as the assistant treasurer of Key West Stores. The company...
BYP5-7 Jacquie Boynton was just hired as the assistant treasurer of Key West Stores. The company is a speciality chain store with nine retail stores concentrated in one metropolitan area. Among other things, the payment of all invoices is centralized in one of the departments Jacquie will manage. Her primary responsibility is to maintain the company's high credit rating by paying bills when due and to take advantage of all cash discounts. Phelan Carter, the former assistant treasurer who has...
QUESTION 1 Advanced Security Inc. was hired by the Treasury Bank Inc. for securing their systems....
QUESTION 1 Advanced Security Inc. was hired by the Treasury Bank Inc. for securing their systems. The first thing they did was implement the best practice if separation of domains. As a result of this The bank had to get a new domain name. any change made in the records points to only one party who could have made that change. If you are a technical person, you must have office in a particular area of the building. accessing outside...
Suppose you are a researcher in a hospital. You are experimenting with a new tranquilizer. You...
Suppose you are a researcher in a hospital. You are experimenting with a new tranquilizer. You collect data from a random sample of 9 patients. The period of effectiveness of the tranquilizer for each patient (in hours) is as follows: 2.5 2.7 2 2.9 3 2.4 2.3 2.5 3 a. What is a point estimate for the population mean length of time. (Round answer to 4 decimal places) b. Which distribution should you use for this problem? normal distribution t-distribution...
Chapter 1 Running Your Own MNC Developing Your Idea Create an idea for your own MNC...
Chapter 1 Running Your Own MNC Developing Your Idea Create an idea for your own MNC to conduct international business. Your idea should be simplified to the degree that you could possibly implement it someday. However, your idea should also be sufficiently creative to be successful if done properly. Your idea should focus on one country and one foreign currency, since many MNCs are focused in this manner when they are first created. So that you can recognize the issues...
Develop an application to support course administration. Read the following detailed description of this application, and...
Develop an application to support course administration. Read the following detailed description of this application, and complete the tasks listed below. *. A course has a unique course number and title, and is assigned to one or more areas of the Computer Science program. Each course has an instructor, at least one teaching or research assistant, an online conference whiteboard, a time (interval), and a capacity (maximum number of participants). A course need not be offered each term, but the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT