ComputerScienceExpert
$18/per page/
Please help me with a Presentation project following the attached rubric and using the Implementation report
1 Database Implementation Plan Report
Jace D. Swihart
IT-204 Intro to Data and Information Mgmt 2
DATABASE IMPLEMENTATION Database Implementation
a. What data from the scenario is needed for the database and why?
This scenario requires student data, instructor data, and course data which are essential
for optimal performance of the database. Student data provides details about students enrolled to
Birchwood Lanes. The data includes names, address, email, date of birth, courses taken, enrolled
courses, and enrollment date. Instructor data is required to provide details about instructors that
work in Birchwood Lanes. The data includes names, address’, phone numbers, courses taught,
etc. Additionally, course data is required to provide detailed information about the courses
offered in Birchwood Lanes. The data required is interdependent which implies that all data
about instructors, students, and courses have to be provided to ensure referential integrity is
maintained.
b. To what extent is additional information needed to develop complete data requirements?
It is essential to consider the relationship between various data sets. For example, the
entity student has a one to many relationships with the entity course. This implies that for the
database to function properly, all the data sets have to be provided. 3
DATABASE IMPLEMENTATION Relational Database Model 4
DATABASE IMPLEMENTATION a. Design a relational database model. 5
DATABASE IMPLEMENTATION b. Develop a logical database model. 6
DATABASE IMPLEMENTATION Database Selection
a. Why did you choose this DBMS?
The appropriate DBMS for Birchwood Lanes is MS SQL server. MS SQL server offers
various robust features which are easy to use and effective in managing school database. The
DBMS has a data size limit of 10GB (Nielsen, 2011). This is a relatively high data cap
considering the kind of data stored by the school. This data size limit can support school
operations without limiting the amount of data that can be stored. The annual purchase cost of 7
DATABASE IMPLEMENTATION MS SQL server is $1,790. The DBMS costs less compared to the purchase costs of Oracle, IBM
DB2, and MYSQL. With MS SQL Server, the school will incur fewer costs but get quality
service. The DBMS has high availability which implies that here will be less downtime and
ensures that the school database is accessible at all times (Mistry, 2014). It includes JSON
support, and the capability to stretch database hence can support scalability and maintain
database performance. However, the DBMS can only operate in Windows. Thus, the school is
required to have Windows platform to install and use the DBMS. Additionally, the DBMS
requires an x64 Processor with speed 1.4 GHz and minimum 1GB memory to operate optimally
(Petkovic, 2008). Overall, with MS SQL server, the school will have a robust DBMS that has
high availability and costs less.
b. To what extent are there additional or alternative technologies that might assist
Birchwood Lane Schools in managing its data?
Additional technologies that can be used with MS SQL server are data backup and
replication technologies. Data backup technology creates a copy of the data stored in the
database. This technology may be applied in Birchwood Lanes as a failsafe strategy in cases
where the database becomes corrupted or altered. Additionally, replication technology may be
essential as it keeps local copies of data in different nodes that will improve availability to
various Birchwood Lane Schools.
Implementation Plan
a. Be sure to include all relevant information and steps.
First, the DBMS software will be installed in the school system. The database
administrator will configure the database and set up security measures such as authentication 8
DATABASE IMPLEMENTATION control. Next, the school database will be created. Database tables will be created to store the
data required. Once the tables are created, all the data collected will be entered via the MS SQL
GUI interface. The database administrator will optimize the database queries to enhance the
database performance. Additionally, the staff at the school will be trained on how to use the
DBMS to manage data to help alleviate errors due to improper data entry.
b. Are there additional pieces of information necessary to develop a full plan for
implementation or that may impact implementation success?
Fuzzy data or missing data may affect implementation of data. Since the school is using
a relational database, missing data may affect the database results. The skills of the database
administrator are a key factor in the implementation of the database. An ineffective database
administrator may fail to configure the DBMS correctly causing the whole system to fail. 9
DATABASE IMPLEMENTATION References
Mistry, R., & Misner, S. (2014). Introducing Microsoft SQL Server 2014. Microsoft Press.
Nielsen, P., & Parui, U. (2011). Microsoft SQL server 2008 bible (Vol. 607). John Wiley & Sons.
Petkovic, D. (2008). Microsoft Sql Server 2008 A Beginner's Guide. McGraw-Hill Osborne
Media.
IT 204: Final Presentation Guidelines and Grading Guide
Overview
You will present your DBMS model and your proposed method of implementation to the board members of Birchwood Lane Schools. As this is a proposal
presentation, your goal is to persuade the board to accept your proposal; therefore, tailoring your delivery to meet the needs of your audience is essential.
Ensure that you include presentation notes. This presentation will pull largely from content included in your database proposal and implementation plan that
you submitted in Module Seven. Outcomes
This assessment will evaluate your mastery with respect to the following course outcomes: Apply the appropriate terminology of the realm of data and information management to real-world scenarios
Develop and address complete and valid data requirements for business cases
Present database management proposals in a persuasive manner given the needs of specific audiences Prompt
Specifically, the following critical elements must be addressed in your submission:
I.
II. III.
IV.
V. Introduction: Establish and communicate the summarized data and information requirements of Birchwood Lane Schools and explain the overall
approach you have taken to address these requirements.
Proposals:
a. Provide a brief outline of your conceptual DBMS model that speaks to the needs of your target audience and explains the graphics of your
conceptual model. The needs of your target audience may center on things such as level of technological comfort, familiarity with data
terminology, and what aspects of your proposal might mean the most to your audience.
b. Provide a brief outline of your logical model, and communicate the importance of these logical aspects to meet the needs of your target
audience.
c. Clearly and concisely articulate the main elements of your proposed plan for implementation.
Justification: How does the solution you have developed address the information and data requirements of Birchwood Lane Schools?
Closing Statement: Articulate the importance of the DBMS versus Birchwood’s traditional paper method using terminology tailored to your target
audience.
Visual Presentation:
a. Graphics: The visual presentation must be well organized, uncluttered, and appropriate for the needs of the target audience.
b. Text: The text aspects of your presentation (presentation notes) should be well written and polished. Rubric
Format: The presentation with notes must be between 5 and 10 slides including conceptual models, graphics, and diagrams.
This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions.
Instructor Feedback: Students can find their feedback in the Grade Center.
Critical Elements
Introduction Exemplary (100%)
Meets “Proficient” criteria, and
introduction is concise Proficient (85%)
Effectively establishes and
explains the general approach
taken to address the data
requirements Needs Improvement (55%)
Establishes and explains the
general approach taken to
address the data requirements,
but the delivery is not effective Not Evident (100%)
Does not establish and explain
the general approach taken to
address the data requirements Conceptual Outline Meets “Proficient” criteria, and
delivery of data requirements is
well articulated Develops data requirements
that are not complete or are
not valid Does not develop data
requirements 10 Logical Outline Meets “Proficient” criteria, and
model is organized simply and
intuitively Provides a brief outline of
conceptual DBMS model that
speaks to the needs of the
student’s target audience
Provides a brief outline of
logical model that
communicates the importance
of these logical aspects to
student’s target audience Visual conceptual model does
not clearly illustrate the entities
and relationships indicated by
the determined data
requirements 10 Implementation Plan Meets “Proficient” criteria, and
articulation is professional and
tailored to the needs of the
audience
Meets “Proficient” criteria, and
justification is persuasive and
tailored to the target audience Clearly and concisely articulates
the main elements of the
proposed plan for
implementation
Effectively justifies each
proposal by explaining how
they address the established
needs of the Birchwood Schools Does not justify each proposal
by explaining how each
proposal addresses the
established needs 15 Meets “Proficient” criteria, and
articulation is concise and
professional Articulates the importance of
the DBMS to Birchwood Schools
using authentic terminology
tailored to the target audience Articulates the main elements
of the proposed plan for
implementation, but is not clear
or is not concise
Justification includes an
explanation of how each
proposal addresses the
established needs, but delivery
is not effective
Articulates the importance of
the DBMS to Birchwood Schools
using authentic terminology,
but is not tailored to the target
audience Visual conceptual model does
not illustrate the entities and
relationships relevant to
requirements determined, or
no visual conceptual model
exists
Does not articulate the main
elements of the proposed plan
for implementation Does not articulate the
importance of the DBMS to
Birchwood Schools using
authentic terminology 10 Justification Closing Statement Value
20 10 Visual Presentation:
Graphics Meets “Proficient” criteria, and
the visual presentation is
professionally creative The visual presentation is well
organized, uncluttered, and
tailored to the needs of the
target audience Visual Presentation:
Text Submission is free of errors
related to citations, grammar,
spelling, and syntax and is
presented in a professional and
easy-to-read format Presentation notes have no
major errors related to
citations, grammar, spelling, or
syntax The visual presentation is
tailored to the terminology
needs of the target audience
but has organizational or clutter
issues
Presentation notes have major
errors related to citations,
grammar, spelling, or syntax
that negatively impact
readability and articulation of
main ideas The visual presentation is not
tailored to the needs of the
target audience 10 Presentation notes have critical
errors related to citations,
grammar, spelling, or syntax
that prevent understanding of
ideas 15 Total 100%