$20 Bonus + 25% OFF +
5
%
Cashback
information
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Fundamentals Of Database _Assignment

tag 256 Download3 Pages 590 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

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

MyAssignmenthelp.com is the perfect solution to render quality solution for all sort of academic issues. We have hired professionals from different fields of study to provide assistance with different subjects. We successfully have provided different types of assignment solutions on 100+ subjects. We have hired industry experts to deliver nursing assignment, hr assignment and finance assignment help. To offer quality content with IT assignments, we have hired IT professionals to render programming language assignment help and IT assignment help for other types of IT assignments as well.

Most Downloaded Sample Of Management

Toulin Method Of Argumentation

Download : 292 | Page : 1

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 document that demonstrates your understanding of the objectives of the course. The structure of the argument will follow the TOULMIN METHOD of argumentation.

Read More arrow Tags: Australia Arlington Management University of New South Wales 

Consumer Behavior Assignment

Download : 214 | Pages : 9

Executive Summary The purpose of this report is to elaborate the factors which are considered by individuals before selecting an occupation. Choosing an occupation is indeed a major decision of everyone’s life and it does give a shape to where he would be heading in the course if time. The report begins with a list of various occupations which have been going since the human civilization started though it has indeed changed its form to...

Read More arrow Tags: Australia Arlington Management University of New South Wales 

Internet Marketing Plan For River Island

Download : 373 | Pages : 13

Introduction With the increase enhancement in the field of technology, it has been considered essential by the businesses to implement such technology in their business processes. Further, the increasing demand from the customers regarding the better quality of products and services delivered to their doorstep has also necessitated for the businesses to implement the e-business strategy in their business processes. E-business which is common...

Read More arrow Tags: Australia Arlington Management University of New South Wales 

Strategic Role Of HR In Mergers & Acquisitions

Download : 332 | Pages : 9

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 strategic role. The importance of role of HR part in integration of the merged companies should not be taken lightly and should be handled very carefully and with due planning. At pre acquisition stage, due diligence should be taken before the start of the process and HR must carve ou...

Read More arrow Tags: Australia Arlington Management University of New South Wales 

Relationship Between Knowledge Management, Organization Learning And HRM

Download : 365 | Pages : 7

Introduction In this competitive business environment where every business organization is trying to attract the customers of each other, it becomes essential for these organizations to remain competitive by innovating new ideas and thoughts, so that value added products and services can be provided to the customers. The motive of such organization in providing value added services to their customers, require their employees to be quite effect...

Read More arrow Tags: Australia Arlington Management University of New South Wales 
Next
watch

Save Time & improve Grade

Just share your requirement and get a customized solution.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,118,350

Orders

4.9/5

Overall Rating

5,044

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

416 Order Completed

95% Response Time

Tyler Moore

MBA in Accounting

Washington, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

755 Order Completed

95% Response Time

Douglas Cowley

Masters in Finance with Specialization in Audit

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2830 Order Completed

97% Response Time

Leroy Bicknell

MBA in Marketing

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

230 Order Completed

97% Response Time

Liya Han

Master Of Science in Geotechnical Engineering (MSc Geotec)

Singapore, Singapore

Hire Me

FREE Tools

proofreading

Proofreading & Editing

Complete guid on proofreading and editing.

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Delighted to got my assignment done quickly, have not submitted yet but I love this service, and I pray for good grade if I submit it, then I\'ll come back and give exceptional feedback. Thanks. Hope there won\'t be any complain

flag

User Id: 327344 - 23 Oct 2019

Australia

student rating student rating student rating student rating student rating

My assignment was well done and I was really happy with the mark I have got. Thank you

flag

User Id: 286432 - 23 Oct 2019

Australia

student rating student rating student rating student rating student rating

it was very helpful. All my questions were answered above and beyond. Thank you so much for your help.

flag

User Id: 286432 - 23 Oct 2019

Australia

student rating student rating student rating student rating student rating

Great work always never fail me. I am 1000 percent happy always. The quality of work is just fantastic

flag

User Id: 311431 - 23 Oct 2019

Australia

student rating student rating student rating student rating student rating
Have any Query?