This topic contains a solution. Click here to go to the answer

Author Question: Which permission do you grant if you want a user to have the right to remove data from a table? ... (Read 94 times)

deesands

  • Hero Member
  • *****
  • Posts: 514
Which permission do you grant if you want a user to have the right to remove data from a table?
 
  A) INSERT
  B) UPDATE
  C) DELETE
  D) None of the above

Question 2

What are some of the uses of one to one relationships? Provide examples.
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

paavo

  • Sr. Member
  • ****
  • Posts: 301
Answer to Question 1

C

Answer to Question 2

A one to one relationship can be used to separate data that must be secured from more public data. For instance, an Employee table could be split into two tables. One would contain the general, publicly available information about an employee and the other would contain private information such as his or her social security number, number of tax exemptions, etc. Another use is to create a hierarchy of tables in order to prevent unavoidable null attributes. If one had a Vehicle entity, for example, that contains data about several kinds of vehicles each with their own attributes, one could create a separate entity for each kind of vehicle with a one to one relationship to the original vehicle entity. This would eliminate nulls in the vehicle table for attributes not related to a particular kind of vehicle.




deesands

  • Member
  • Posts: 514
Reply 2 on: Jul 7, 2018
:D TYSM


ryansturges

  • Member
  • Posts: 338
Reply 3 on: Yesterday
Gracias!

 

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

For a complete list of videos, visit our video library