IT 204: Data and Database Management System (DBMS)

IT 204: Data and Database Management System (DBMS) ComparisonsWiki
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.

WRITE THIS ESSAY FOR ME

Tell us about your assignment and we will find the best writer for your paper.

Get Help Now!

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
Oracle IBM DB2 MS SQL Server Open Source
(Ingres, PostgreSQL, or MYSQL)

1. Data Size Limits
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 Exemplary Proficient Needs Improvement Not Evident Value
Data Size Limits Meets “Proficient” criteria, and recommendations use evidence from the discussion to show both the positives and negatives of the DBMS
(14-15) Includes a well-developed discussion of data size limits using specific details
(12-13) Does not sufficiently discuss data size limits

(11) Does not include data size limits
(0-10) 15
Purchase Cost Meets “Proficient” criteria, and recommendations use evidence from the discussion to show both the positives and negatives of the DBMS
(14-15) Includes a well-developed discussion of purchase cost using specific details
(12-13) Does not sufficiently discuss purchase cost

(11) Does not include purchase cost
(0-10) 15
Administration Meets “Proficient” criteria, and recommendations use evidence from the discussion to show both the positives and negatives of the DBMS
(14-15) Includes a well-developed discussion of administration using specific details
(12-13) Does not sufficiently discuss administration

(11) Does not include administration
(0-10) 15
Operating System/
Hardware
Requirements Meets “Proficient” criteria, and recommendations use evidence from the discussion to show both the positives and negatives of the DBMS
(14-15) Includes a well-developed discussion of operating system/
hardware requirements using specific details

(12-13) Does not sufficiently discuss operating system/hardware
requirements
(11) Does not include operating system/hardware
requirements
(0-10) 15
Features Meets “Proficient” criteria, and recommendations use evidence from the discussion to show both the positives and negatives of the DBMS
(14-15) Includes a well-developed discussion of the features using specific details
(12-13) Does not sufficiently discuss the features

(11) Does not include the features
(0-10) 15
Performance and Scalability Meets “Proficient” criteria, and recommendations use evidence from the discussion to show both the positives and negatives of the DBMS
(14-15) Includes a well-developed discussion of performance and scalabilityusing specific details
(12-13) Does not sufficiently discuss performance and scalability

(11) Does not include performance and scalability

(0-10) 15
Articulation of Response 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) Submission has no major errors related to citations, grammar, spelling, syntax, or organization

(8) Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas
(7) Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas

(0-6) 10
Earned Total
Comments: 100%