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.
Answer the following question listed below. This assignment has a 150 minimum word count. You will...
Answer the following question listed below. This assignment has a 150 minimum word count. You will also be required to reply to 1 response (100 minimum word count for each response) and use at least one credible reference. 1. List 3 facts about small businesses. 2. What are advantages in starting a small business? 3. Which Entrepreneurial Resource would you make use of?
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?
Instructions: Need proper and complete answer (containing minimum 500 words) for following question related to 'Principles...
Instructions: Need proper and complete answer (containing minimum 500 words) for following question related to 'Principles of Marketing'. Please include an additional listing of any references or supplemental materials used. Feel free to use whichever reference style you prefer. If you reference information from the Web or from any other sources (e.g., journal articles, library books, textbook), make sure that you do not copy the material verbatim (i.e., copied exactly from the original word for word). You should paraphrase (i.e.,...
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT