The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 3 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Please help me complete a wiki comparison for this weeks assignment a DBMS Wiki Assignment.
IT 204: Data and Database Management System (DBMS) Comparisons Wiki
Guidelines and Rubric
Wikis provide students with an effective collaboration tool. This easy-to-use tool facilitates collaboration, information dissemination, and application of learning,
providing meaningful connections with the content and relating new knowledge with personal experience.
For an excellent illustration of the utility and function of wikis, view Wikis in Plain English by Common Craft. For more information about Blackboard wikis, review
these tutorials.
Prompt:
Discuss each question below for the DBMS assigned to your group. Then summarize the discussion in the wiki. Use bullets for each entry.
1. Size Limits: Does the DBMS enforce table, data type, or column length level? If tables with lots of fields are needed for the client, this could be an issue.
2. Purchase Cost: How much does the system cost? Is there a base price for the server and then additional costs for clients? Consider the pricing model for
the school district listed in the Final Project Document.
3. Administration: Installation and Operational Costs and Considerations: How difficult is it to install, use, and maintain? Is special expertise or an ongoing
contract with the provider required?
4. Operating System/Hardware Requirements: What operating systems will the DBMS work with? What are the hardware requirements to host it?
5. Features: List key features of the DBMS. Include ACID (atomicity, consistency, isolation, durability), referential integrity, transactions, Unicode, and
interface.
6. Performance and Scalability: What is the speed of execution (i.e., how fast will it do what you need it to do)? What is the increase in performance when
additional resources are added? For example, does it support clustering? DBMS Comparison Table
DBMS 1. Data Size Limits Oracle IBM DB2 MS SQL Server Open Source
(Ingres,
PostgreSQL, or
MYSQL) 2. Purchase Cost 3. Administration 4. Operating System/Hardware
Requirements 5. Features 6. Performance/Scalability Rubric
Requirements of Submission: This milestone must be posted to the wiki.
Instructor Feedback: Students can find their feedback in the Grade Center.
Critical Elements
Data Size Limits Exemplary
Meets “Proficient” criteria, and
recommendations use evidence
from the discussion to show
both the positives and negatives
of the DBMS
(14-15) Proficient
Includes a well-developed
discussion of data size limits
using specific details Needs Improvement
Does not sufficiently discuss
data size limits Not Evident
Does not include data size limits (12-13) (11) (0-10) Value
15 Purchase Cost Administration Operating System/
Hardware
Requirements Features Performance and
Scalability Articulation of
Response Meets “Proficient” criteria, and
recommendations use evidence
from the discussion to show
both the positives and negatives
of the DBMS
(14-15)
Meets “Proficient” criteria, and
recommendations use evidence
from the discussion to show
both the positives and negatives
of the DBMS
(14-15)
Meets “Proficient” criteria, and
recommendations use evidence
from the discussion to show
both the positives and negatives
of the DBMS
(14-15)
Meets “Proficient” criteria, and
recommendations use evidence
from the discussion to show
both the positives and negatives
of the DBMS
(14-15)
Meets “Proficient” criteria, and
recommendations use evidence
from the discussion to show
both the positives and negatives
of the DBMS
(14-15)
Submission is free of errors
related to citations, grammar,
spelling, syntax, and
organization and is presented in
a professional and easy-to-read
format
(9-10) Includes a well-developed
discussion of purchase cost
using specific details Does not sufficiently discuss
purchase cost Does not include purchase cost 15 (12-13)
Includes a well-developed
discussion of administration
using specific details (11)
Does not sufficiently discuss
administration (0-10)
Does not include administration 15 (12-13)
Includes a well-developed
discussion of operating system/
hardware requirements using
specific details (11)
Does not sufficiently discuss
operating system/hardware
requirements (0-10)
Does not include operating
system/hardware
requirements (12-13)
Includes a well-developed
discussion of the features using
specific details (11)
Does not sufficiently discuss the
features (0-10)
Does not include the features (12-13)
Includes a well-developed
discussion of performance and
scalability using specific details (11)
Does not sufficiently discuss
performance and scalability (0-10)
Does not include performance
and scalability (12-13)
Submission has no major errors
related to citations, grammar,
spelling, syntax, or organization (11)
Submission has major errors
related to citations, grammar,
spelling, syntax, or organization
that negatively impact
readability and articulation of
main ideas
(7) (0-10)
Submission has critical errors
related to citations, grammar,
spelling, syntax, or organization
that prevent understanding of
ideas (8) 15 15 10 (0-6)
Earned Total Comments: 15 100%