nr542-Database Project Final Report Assignment #3

Database Project Final Report
Assignment #3
Guidelines with Scoring Rubric
Purpose
The purpose of this assignment is to present the results of the database project.
Course Outcomes
Through this assignment, the student will demonstrate the ability to:
(CO#1) Utilize critical inquiry and judgment to evaluate the design, development, implementation, and outcomes of strategies for managing healthcare-related information (PO#4)
Due Date: Sunday 11:59 PM MT at the end of Week 7
Total Points Possible: 150
Submit a PowerPoint presentation of the database project (12-15 slides).
Use the database plan as a guide, updating as needed. All work done during this course, including discussion threads, assignment papers, appendices, and references, may be used to develop this report. Corrections and updates based on feedback are expected.
Provide the reason(s) for the database, including any supporting evidence. Describe the database developed for the course, showing or narrating the three models: conceptual, logical, and physical. Show the relational tables. Include 3 questions that guided database design. Report the results of testing the database and any revisions needed to the database as a result of testing. Conclude with a recap of the database project and insights gained from working on this project. The presentation and speaker notes must follow APA guidelines.
Criteria for Content:
- Introduction establishes topic and organization of presentation
- Reason for database is provided, including supporting evidence
- Structure of the database developed for this project is described, including conceptual, logical, and physical models; can be presented as text, graphics, or a combination
- Relational tables are presented in standard format, with primary keys identified, any secondary keys identified if used, attributes with one data characteristic for each attribute, and normalization issues identified and resolved
- Three questions developed for database plan
- Description of how database was tested
- Results of testing, including any needed changes
- Recap of entire project
- Insights on information management developed from working on project
- Speaker Notes are provided for each slide, except for title and references slides, and provide sufficient depth to allow someone else to take over the presentation.
Criteria for Format and Special Instructions
- Grammar, spelling, and punctuation are consistent with formal academic writing.
- APA format is used correctly for citations and references
- Create 12 - 15 slides, not counting title or references slides
- Citations are not included in slides but are part of Speaker Notes
Category |
Points |
% |
Description |
Introduction |
10 |
6.7 |
Introduction establishes topic and organization of presentation |
Reason |
20 |
13.3 |
Reason for database provided, including supporting evidence |
Database structure |
20 |
13.3 |
Structure of student’s database described, including conceptual, logical, and physical models |
Relational Tables |
20 |
13.3 |
All relation tables shown, with primary and secondary keys, attributes with data characteristics, and identification and resolution of normalization issues |
Questions/Queries |
10 |
6.7 |
Three questions developed for database plan in week 3, with any updates |
Testing |
15 |
10 |
Description of how database was tested, with results and any necessary changes |
Conclusion |
15 |
10 |
Recap of project and conclusions on success of project and insights on information management developed from working on the project |
Speaker Notes |
10 |
6.7 |
Speaker notes are present on each required slide and are sufficient to allow someone else to take over the presentation |
Number of Slides |
10 |
6.7 |
Presentation uses 12 – 15 slides |
APA Format/References |
10 |
6.7 |
Presentation uses APA correctly for citations and references; citations are present only in Speaker Notes |
Writing Mechanics |
10 |
6.7 |
Grammar, spelling, word usage, and punctuation are consistent with formal written work. |
Total |
150 |
100 |
A quality assignment will meet or exceed all of the above requirements. |
Grading Rubric
Assignment Criteria |
Exceptional (100%) Outstanding or highest level of performance |
Exceeds (88%) Very good or high level of performance |
Meets (80%) Competent or satisfactory level of performance |
Needs Improvement (38%) Poor or failing level of performance |
Developing (0) Unsatisfactory level of performance |
|
||
Content Possible Points = 120 Points |
|
|
|
|
|
|
||
Introduction |
10 Points |
9 Points |
8 Points |
4 Points |
0 Points |
|
||
Introduction is thorough and establishes the topic and organization of the presentation |
Introduction includes basic information about the topic and the organization of the presentation |
Introduction includes information about the topic OR the organization of the presentation but not both |
Introduction does not include information about the topic and the organization of the presentation |
Introduction is not present |
|
|||
Reason |
20 Points |
18 Points |
16 Points |
8 Points |
0 Points |
|
||
Reason for database is provided in depth, including supporting rationale(s) |
Reason for database is provided including supporting evidence |
Reason for database is provided and only partially supported by evidence |
Reason for database is provided. Supporting evidence NOT included |
No reason for database is provided
|
|
|||
Database Structure |
20 Points |
18 Points |
16 Points |
8 Points |
0 Points |
|
||
Database structure is described in depth, including conceptual, logical, and physical models. Description can be narrative or a combination of narrative and graphics |
Database structure is described simply, including conceptual, logical, and physical models. Description can be narrative or a combination of narrative and graphics |
Database structure is described Only 2 models are included |
Database structure is described Only 1 model is included |
Database structure is not described OR no models are included |
|
|||
Relation Tables |
20 Points |
18 Points |
16 Points |
8 Points |
0 Points |
|
||
All of the following are present
|
Two of the following are present:
|
One of the following is present
|
Some but not all relation tables are not shown OR
AND
|
No relation tables are shown |
|
|||
Questions/Queries |
10 Points |
9 Points |
8 Points |
4 Points |
0 Points |
|
||
All of the following are present
|
Two of the following are present:
|
One of the following is present
|
Two appropriate questions developed for the database are present |
No questions for the database are present |
|
|||
Testing |
15 Points |
13 Points |
12 Points |
10 Points |
0 Points |
|
||
|
|
OR
|
BUT
|
AND
|
|
|||
Conclusion |
15 Points |
13 Points |
12 Points |
10 Points |
0 Points |
|
||
All of the following are present:
|
All of the following are present:
|
2 of the following are present:
|
1 of the following is present:
|
None of the following are present:
|
|
|||
Speaker Notes |
10 Points |
9 Points |
8 Points |
4 Points |
0 Points |
|
||
|
|
|
Speaker Notes are provided for fewer than 75% of the required slides |
Speaker Notes are not provided for any slides |
|
|||
Format Possible Points = 30 Points |
|
|
|
|
|
|
||
Number of Slides |
10 Points |
9 Points |
8 Points |
4 Points |
0 Points |
|
||
Presentation uses a minimum of 12 and a maximum of 15 slides |
Presentation uses a no more than 11 slides or uses 16 slides |
Presentation uses no more than 10 slides or uses 17 slides |
Presentation uses no more than 9 slides or uses 18 slides |
Presentation uses fewer than 7 slides or more than 19 slides |
|
|||
APA Format/References |
10 Points |
9 Points |
8 Points |
4 Points |
0 Points |
|
||
AND
|
AND
|
AND
|
OR
|
|
|
|||
Writing Mechanics |
10 Points |
9 Points |
8 Points |
4 Points |
0 Points |
|
||
|
|
OR
|
|
|
|
|||
|
|
___Format 30 Points |
|
|
|
|||
Total Points 150 |
|
|
_____of 150 Points |
|

-
Rating:
5/
Solution: Nr542-Database Project Final Report Assignment #3