Question

In: Computer Science

Complete the following questions with proper citations; there is a 150-word minimum per question. Questions: Describe...

Complete the following questions with proper citations; there is a 150-word minimum per question. Questions: Describe the difference between database structural integrity and semantic data integrity. Describe the preferred method of implementing referential integrity in a relational database. Explain two ways that views can be used to implement data security. What is a cascading REVOKE, and what effect can it have on database security?

Solutions

Expert Solution

Structural Intregrity Constraints

Structural integrity constraints are the most basic constraints that are inherent in nature and shown by entities in the database.

Structural constraints for relational systems are as follows:

(i) Domain type integrity constraints

(ii) Domain range integrity constraints

(iii) Nonnull integrity constraints

(iv) Unique key integrity constraints

(v) Referential integrity constraints

Semantic Integrity Constraints

There are vaious database states in which various constraints are there which are related not only to the legal instances of data and realistic requirement but also with facts specific to database. these constraints are known as semantic integirity constraints.

E.g. 1: An employees boss is necessarily affiliated with that employee's organization or company.

E.g. 1:

E.g. 2: Boss salary is always less than subordinate emlooyee's salary.

E.g 3: Each student is assigned some course and have some mentor.

Preferred method for establishing referential integrity:
The attribute that has been taken for referential key should be chosen it with the entity whose cardinality in m.

Well views are not part of physical schema so the changes made in data in the underlaying tables is reflected whenever the views are envoked.
With the help of view the data present in tables are shown in limits as per requirement and authentication of user.

Views can combine various tables in one and do not need to carry required data everytime. Mostly views are computing the output at the time of their invocation because only view definition is changed in the database. So the database is not exposed to the external word every time.

Many times permissions are granted to specific user (depending upon its authentication) which can later be revoked once some external event occurs (Like time expired or all allowed attempts tried) then all the permission granted in the hirarchy will be expired i.e. revoked.


Related Solutions

Complete the following questions with proper citations; there is a 150-word minimum per question. Questions: What...
Complete the following questions with proper citations; there is a 150-word minimum per question. Questions: What is the difference between a logical backup and an image copy backup? What is a “quiesce” point, and why is it important for point-in-time recovery? Name and describe the three types of database failures that require recovery. Name and describe four factors that impact the duration of recovery.
Please submit a 1,000 word paper, double spaced with proper APA citations answering the following: Since...
Please submit a 1,000 word paper, double spaced with proper APA citations answering the following: Since taxes distort market outcomes and efficiencies, should the government legalize currently illegal drugs which have very inelastic demand and heavily tax them to generate revenue?
Answer the following question in your own words. Your answer must have a 150 minimum word...
Answer the following question in your own words. Your answer must have a 150 minimum word count: Explain the difference between fixed costs and variable costs. Describe their significance and give examples of each one.
Answer the following question in your own words. Your answer must have a 150 minimum word...
Answer the following question in your own words. Your answer must have a 150 minimum word count: Define budgeting and describe its primary purposes and benefits to an organization.
Answer the following question in your own words. Your answer must have a 150 minimum word...
Answer the following question in your own words. Your answer must have a 150 minimum word count: Describe the three (3) primary methods of cost allocation and describe how they differ.
Answer the following question in your own words. Your answer must have a 150 minimum word...
Answer the following question in your own words. Your answer must have a 150 minimum word count: Describe the difference between financial accounting and managerial accounting. Give examples of the uses of each one.
Answer the following question in your own words. Your answer must have a 150 minimum word...
Answer the following question in your own words. Your answer must have a 150 minimum word count: Describe the differences between top-down and bottom-up budgeting.
Please read the following and submit a minimum 150 word commentary at title link above: In...
Please read the following and submit a minimum 150 word commentary at title link above: In your own words, summarize the general philosophies of any two of the following famous economists: John Maynard Keynes, Milton Friedman, Adam Smith, Karl Marx, John Stuart Mills, Friedrich Hayek.
Please answer the following questions with a minimum of 150 words. As a parole officer, how...
Please answer the following questions with a minimum of 150 words. As a parole officer, how would you handle a juvenile who will turn 18 years old in 2 months and who persistently violates his curfew, which is a condition of his parole program?
Respond to the following questions in 150-200 words (per question): Explain why economic profits are zero...
Respond to the following questions in 150-200 words (per question): Explain why economic profits are zero in the long run in a monopolistically competitive market. Explain the unique characteristics of the four primary market structures. What are the characteristics of a public good? Discuss the two ways that product differentiation affects the demand for a product. Describe at least five different forms of government intervention in the economy. Explain how these economic concepts currently influence the structure of the American...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT