Benefits of relational database management system

Assignment Help Database Management System

Reference no: EM133468343

Assignment:

The company you are working for currently uses an Access database at its various locations. Your manager asks how many total customers the company is currently servicing. It is important to have a single central view of the data, but the use of Access at the many sites makes this task difficult. Describe the limitations of using Access in this fashion, and describe the pros and cons of using a single enterprise-scale relational database management system (RDBMS) instead. As you describe the benefits of an RDBMS, also discuss its features and components. Finally, you hear coworkers interchange the term database and DBMS; describe the difference between the two terms and how they work together. Your post should include the following details:

A description of Access and its limitations in a distributed business model
The features and components of an RDBMS
The pros and cons of an RDBMS
The difference between a database and DBMS

Help me answer these questions and please add the references for citation purposes.

Reference no: EM133468343

Questions Cloud

Create the projected marketing and promotion budget : Research and select target markets (Who will you promote your idea to?). Create the projected marketing and promotion budget.

What is the difference between a workstation and a server : What is the difference between a workstation and a server? What are different kinds of servers?

Describe an intrusion detection system : Describe what an Intrusion Detection System and an Intrusion Prevention system are, how they are similar, and how they are different.

How did you leverage knowledge gained in the intellipath : How did you leverage knowledge gained in the intellipath assignments (Units 1- 4) in completing the Comprehensive Project?

Benefits of relational database management system : Describe the pros and cons of using a single enterprise-scale relational database management system (RDBMS) instead.

Describe the advantages and disadvantages of choice you made : Describe the advantages and disadvantages of the choice you made. Explain why an MNC may invest funds in a financial market outside its own country.

Identify the types of information systems the company uses : Describe the company's industry, products/services sold, customer base, and competitors. Identify the types of information systems the company uses.

What is the effect on sales per capita : According to this regression, what is the effect on sales per capita when average local income increases from $35,000-$44,999 to $55,000+?

Review your internship experience successes and challenges : In a paper based on internship course experiences and learning objectives achieved, review your internship experience successes and challenge leading to growth.

User Account

All Pages