Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Fundamentals Of Database _Assignment Add in library

256 Download3 Pages 590 Words

Questions:

1. Which account is designated as the owner of a relation? What privileges does the owner of a relation have?

2. How is the view mechanism used as an authorization mechanism?

3. Discuss the types of privileges at the account level and those at the relation level.

4. What are the main reasons for and potential advantages of distributed databases?

5. What additional functions does a DDBMS have over a centralized DBMS?
 
 

Answers:

1. With respect to some specific relation, an ‘owner’ account is the user account that have all controls over that relation.

Owner can have maximum privileges on the relation. An owner of the relation can have the following privileges,

  • Selection
  • Modification
  • Referencing

With respect to that relation.

2. With respect to a database, a view is a set of records from a query and is represented as a virtual relation. It is not a part of the physical schema of the database, rather it is a virtually calculated set of records those are processed dynamically from the database.

Views can also be used in access control mechanism. These can be used to grant access limits on some relation for multiple users.

For example, in an office, there will be payroll information of all employees. Now, the accountant have access to the payroll relation. CEO is an employee, so the payroll information of the CEO will also be in the payroll relation. But an account should not have access control to all payroll information of the CEO. Thus, view will be used to separate the access control on the same physical relation payroll. It will give different level of access control on the data of the payroll relation.

3. Granting privilege is related to the concept of authorization of the identifier for some user account. A user will have some set of access restrictions to some relations of the database. When the user will need to access some relation, the system will check for the set of relations and access controls that have been granted previously to that user, if it matches, then the user will have access to the requested information from some relation. Assignment of privileges to some user can be any of the two types. Those are,

  • Account level

The DBA of the database will set the privileges in this level. The privileges will be effective independently to each of the relations of the database.

  • Relation level

Again the DBA will set the privileges to relations or views of the database.

4. Distributed databases works based on some network. The potential advantages of distributed databases are,
  • It is easier and more flexible for development of applications.
  • It performs better.
  • It is scalable.

5. The additional features of distributed database over the same in centralized database are,

  • It keeps track of distribution, replication and fragmentation of data.
  • It supports distributed query processing over a network.
  • It supports distributed transaction management, data replication management, distributed recovery management.
  • There is distributed catalog management.
  • The overall complexities of the above features is lesser in distributed database compared to centralized databases.
 

References

Cellary, W., & T. Morzy, E. G. (2014). Concurrency Control in Distributed Database Systems. Elsevier.

Elmasri, R., & Navathe, S. B. (2013). Fundamentals of Database Systems. Pearson .

Mullins, C. S. (2013). Database Administration: The Complete Guide to DBA Practices and Procedures. Addison-Wesley Professional.

Özsu, M. T., & Valduriez, P. (2011). Principles of Distributed Database Systems. Springer.

Rahimi, S. K., & Haug, F. S. (2010). Distributed Database Management Systems. John Wiley & Sons.

Silberschatz, A., Korth, H. F., & Sudarshan, S. (2011). Database System Concepts (6th ed.). McGraw-Hill.

OR

For years, MyAssignmenthelp.com has been operating as one of the cheap assignment help providers in the USA. We are one of the best college paper writing services that keep service price minimal. We do not let the affordability of our service to hamper the standard of our work. We have separate teams of experts to provide report writing help . At MyAssigenmnthelp.com, we believe in earning credibility, so students can pay for assignments only after getting satisfied solutions. Tough assignments bother you? Trust us with your project. You will not regret paying us to write assignments for you.

Most Downloaded Sample of Management

277 Download1 Pages 48 Words

Toulin Method Of Argumentation

You are required to write a researched argument essay that convinces persuades the reader of your position / stance. This is an academic, researched and referenced do...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
202 Download9 Pages 2,237 Words

Consumer Behavior Assignment

Executive Summary The purpose of this report is to elaborate the factors which are considered by individuals before selecting an occupation. Choosing an occupati...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
368 Download13 Pages 3,112 Words

Internet Marketing Plan For River Island

Introduction With the increase enhancement in the field of technology, it has been considered essential by the businesses to implement such technology in their b...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
328 Download9 Pages 2,203 Words

Strategic Role Of HR In Mergers & Acquisitions

Executive Summary In a merger & acquisition, role of an HR has emerged as a very critical function. At each stage of merger and acquisition process, HR plays a s...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
357 Download7 Pages 1,521 Words

Relationship Between Knowledge Management, Organization Learning And HRM

Introduction In this competitive business environment where every business organization is trying to attract the customers of each other, it becomes essential for ...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
Next
Free plagiarismFree plagiarism check online on mobile
Have any Query?