IT 204: Data and Database Management System (DBMS) Comparisons Wiki Guidelines and Rubric Wikis provide students with an effective collaboration
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.
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.
- 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.
- 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.
- 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?
- Operating System/Hardware Requirements: What operating systems will the DBMS work with? What are the hardware requirements to host it?
- Features: List key features of the DBMS. Include ACID (atomicity,consistency, isolation,durability), referential integrity, transactions, Unicode, and interface.
- 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% |