Question

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

Answer 1

Answer:

Yes.

Explanation:

a database can contain two records that look alike. Structure of the database table decides whether the same records will impose negative effect on the integrity therefore, it's not  recommended practice in design of database.

Answer 2

The given question is can a database contain two identical records without a negative effect on the integrity of the database? Why or why not?

The database's or table's structure will determine this

For some aspects the answer is yes and for some aspects the answer is no..

1.yes

The answer is yes if the table has no defined constraints because the database will not be negatively impacted by having multiple records which are identical.

2.No.

The answer is no of the database contains defined constraints such as primary key.

It is the role of database administrator to employ procedure to guarantee data integrity.

which includes data backup, Access controls and data

validation.

backup keeps a copy of data at different locations

data encryption encrypts the data to lock it by cipher.

Access control includes privilege assignments like read/write .

data validation such as output validation to confirm uncorrupted data and input validation to prevent incorrect data entry

# spj2

we can find the similar questions through the link given below

https://brainly.in/question/6892091