What are some of the uses of one to one relationships? Provide examples
What will be an ideal response?
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.
You might also like to view...
An advantage that effective teams can bring to organizations is ______.
A. higher quality leader and follower exchanges B. reduction in overtime worked C. more innovative and creative success D. cost benefits
Tracer Corp, an exploration company, wishes to develop a silver mine on a piece of land known as the Harris tract. It lacked the capital to do so on its own, so it entered into negotiations with Big Tree Mining Ltd
for a joint venture on the project. The negotiations collapsed. Big Tree, believing Tracer's information that there was a rich silver vein on the Harris tract and knowing that Tracer did not yet own it, bought the land itself and subsequently developed the mine, making a huge profit. Which of the following is true? A) Tracer has no remedy unless it establishes that Big Tree owed it a fiduciary duty. B) Tracer has no remedy unless it establishes that Big Tree acquired the Harris tract pursuant to a constructive trust. C) Big Tree is liable to Tracer for breach of confidence D) Tracer has no remedy unless it establishes that Big Tree committed a breach of contract. E) Any one of A, B, or D
Which of the following would be an example of a career goal?
A. making a difference in people's lives B. becoming financially independent C. expressing yourself creatively D. all of the above
The target maximum defect rate of a Six Sigma process is how many parts per million?
a. 1.0 b. 2.5 c. 3.4 d. 4.4