Database Management Systems

User Generated

xvatwnzrf98

Writing

Advanced Database Systems

ctu online

Description

400-600 words

Now that the ERD is created, and as you are working on the logical model, you need to choose an RDBMS for the final solution. Using the method for DBMS selection, analyze 3 different DBMS products available and make a determination about which product you will recommend to management for selection. (One of the databases to analyze must be MySQL).

Using the vendors' Web sites, determine a rating for the following features, and calculate a final score for each:

Vendor

Product Version

Desired Feature

Comments

Rating

Weight

Score

Vendor Stability

0.10

Operating System Choice and Requirements

0.05

Ease of Use/Training Requirements

0.20

Ease of Data Model Creation

0.15

Distributed Database Support

0.10

Administration Ease

0.20

Cost

0.20

Total

Based on your analysis, which database product will you recommend, and why?

As you are designing and developing the database, you think to the future and want to be able to grow the database as required, not only expanding the data model as needed, but also in the event that the company wants to open remote data centers and have replicated copies of the data. Describe distributed databases and how they might be used.

Your post should include the following details:

  • A completed template for 3 different database products (1 of them being MySQL)
    • Comments must be supplied
  • A recommendation for a DBMS, including a justification
  • A description of distributed databases

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Find attached

Surname 1
Student’s Name
Professor’s Name
Course Name
Date
Database Management System
The database is an organized collection of data, a relational database, on the other hand,
includes schemas, queries, tables, views, reports among other elements. Database designers
organize data in models to support processing. For instance, modeling books in a library system
to support a finding of books available on the shelves. Database management systems or simply
DBMS is a computer-based software application that interacts with other applications, end user,
and the database itself to analyze and capture data. DBMS defines, creates, query, updates, and
administer databases. Databases are not portable across different DBMSs; they can interoperate
using standards such as ODBC, SQL, and JDBC for a single application to function with
multiple DBMS.
MySQL is DBMS product that is in almost all ope...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags