ANSWER ALL THE QUESTIONS SOME GUY KEEPS POSTING THE ANWSERS BUT DOSENT SOLVE 2-4

Question

ANSWER ALL THE QUESTIONS

SOME GUY KEEPS POSTING THE ANWSERS BUT DOSENT SOLVE 2-4

SO PLEASE ANWSER ALL

CIST 1220 – SQL - Test #2

Spring Semester, 2018

(125 Points) --- Good Luck!

Take Home Questions – Give Details

( ANSWER ALL QUESTIONS THEY ALLL SHOULD BE AT LEAST 2 TO 3 PARAGRAPHS IN LENGHT)

5.(15 Points) Explain just what Data Integrity is and how the use of Constraints may result in better Data Integrity.

6.(10 Points) Explain exactly how a “Join” works. What is a Cartesian Product?

7.(15 Points) Briefly describe the difference and similarities between a “Join” and a ‘Correlated Sub-Query”. Discuss the advantages and disadvantages of each.

8.(10 Points) Describe a Transaction. What is a transaction and what keywords are used to create transactions?

Explanation / Answer

5.(15 Points) Explain just what Data Integrity is and how the use of Constraints may result in better Data Integrity.

Answer)
Data Integrity is regarding the maintenance of a stable and consistent database where the data is accurate, consistent over the lifetime of the data. Data Integrity manages the data in such a way that the data quality is maintained in the database and any changes in the database is stable and doesn't corrupt the database or have incorrect or incomplete information in the database.

Data Integrity is to ensure that the quality of the database and the data in it should be of the same good quality which was expected to be. Any unintended changes should not do any damage to the integrity of the data and intentional changes have to be consistent with the data and the changes in the database have to be stable and of good quality such that later retrieval of data doesn't lead to problems. Data integrity is implemented in the database by implementing integrities of many kinds. In terms of integrity constraint the types of integrity are:

Entity integrity : where the concept of primary key comes, which the unique identifier of a record in a table.
Referential integrity : where the concept of foreign key comes, where the primary key in one table will be referenced by other table as foreign keys in other tables.
Domain integrity : where the description and definitions of the relational database are declared in a domain.

Thus Entity integrity, Referential Integrity and Domain Integrity are all necessary to produce better Data Integrity in the database.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.