Can a database contain two identical records without a negative effect on the integrity of the database? why or why not?

Question

04-08-2022
Business

Answered

Discover the answers to your questions at Westonci.ca, where experts share their knowledge and insights with you. Connect with a community of experts ready to help you find solutions to your questions quickly and accurately. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

Can a database contain two identical records without a negative effect on the integrity of the database? why or why not?

Sagot :

Thanks for using our service. We aim to provide the most accurate answers for all your queries. Visit us again for more insights. We hope you found what you were looking for. Feel free to revisit us for more answers and updated information. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.

Horsetails and ferns reproduce by making millions of powdery spores. How are they transported? A. Dropped in place B. Blown by the wind C. Transported by insect

Which word best defines the word diminish? One would think his anxiety would diminish, not increase, once his name was called. A. Mature B. Grow C. Lessen D.Beg

as a result of the presidency of Franklin Delano Roosevelt the constitution was amended to do what

A gas occupies a volume of 444 mL at 273 K and 79.0 kPa. What is the final kelvin temperature when the volume of the gas is changed to 1880 mL and the pressure

Given the balanced equation representing a redox reaction: 2Al + 3Cu2+ --> 2Al3+ + 3Cu Which statement is true about this reaction? (1) Each Al loses 2e- and

What's the definition of "divine kingship"?

Which of the following is true of the Truman Doctrine? A. It amounted to an informal declaration of Cold War. B. It ended the policy of containment. End of exam

how do you say this saying in french ??? "There is no pressure when are making a dream comme true"

Distinguishing Fact from Opinion Consider the example of the state lottery to raise money for education. How might it be possible for two economists to see the

Tyler works in retail where she earns $10.50 per hour. She also earns $15 for every new credit account she gets customers to open and she gets a weekly stipend

sakshigupta4990 sakshigupta4990 · Answer 1 · 2022-08-11T02:27:52-04:00

Yes, a database can contain 2 identical records.

Identical records imposing a negative effect on the integrity will depend on whether the database semantics allow duplicates or not.

If the database table doesn't have any defined key or other 'unique' constraints, then we can have multiple identical records. Otherwise, we will not have multiple identical records.

The database might be a list of all transactions for a store, in which case it would be very possible for two people to purchase the same item, causing duplicate records.

Yes, a database can contain two identical records. The database/table structure determines whether identical records break integrity. If the database table does not have a defined key or other "unique" constraint, then it is possible to have multiple identical records, but not vice versa.

Learn more about database at

https://brainly.com/question/518894

#SPJ4

Sagot :

Other Questions