Database Concepts - Essay

PT2520: Week 4 Database Management Systems (DBMSS)

Essay 4.1/Implementing Physical Design

1

Explore and research the latest versions of the following database management systems (DBMSs) on the

market: Oracle 11G, Microsoft SQL Server, MySQL, and IBM DB2.

Look up information on the ITT Tech Virtual Library and the Internet. Use the following keywords and phrases

to begin your research: “Database Management Systems, Compare different DBMS systems, Oracle 11G,

Microsoft SQL Server, MySQL, IBM DB2.” Here are a few links to get you started:

DBMS Info web links

http://www.infoweblinks.com/content/dbms.htm

A Comparative Study on the Performance of the Top DBMS Systems

http://arxiv.org/ftp/arxiv/papers/1205/1205.2889.pdf

Top 10 Enterprise Database Systems to Consider

http://www.serverwatch.com/trends/article.php/3883441/Top-10-Enterprise-Database-Systems-to-

Consider.htm

SQL Data Types

http://onlamp.com/pub/a/onlamp/2001/09/13/aboutSQL.html

Based on your research, complete the following tasks:

1. Compare the four DBMSs on different parameters, including pros and cons. Click here to access and

complete the comparison table.

2. Based on your analysis, choose the DBMS you want to use to build your database for the Wild Wood

Apartments scenario. Click here to view the scenario again. Explain why the DBMS you have chosen

will work best for the given scenario.

Submission Requirements:

Submit your response in a three- to four-page Microsoft Word document.

Font: Arial; 12-point

Line spacing: Double

Evaluation Criteria:

Click here to view the grading rubric for this assessment.

Did you create a comparison table for the listed DBMSs?

Did you select an appropriate DBMS for Wild Wood Apartments?

Did you justify your selection with reasons and references?