Your Prototype Database Design Proposal: Product (Coursework Sample)
In the final phase of the Database Design Proposal assignment, you are required to design a working prototype of the proposal. You will be required to utilize SQLite Database. The SQLite database is a small, lightweight database application, suited for learning SQL and database concepts, or to just explore some database-related ideas without requiring a full-blown database management system (DBMS). Refer to "Supplement: SQL Examples for SQLite Database," for the link to the SQLite Database download and examples.
The working prototype should include the following:
1) Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design.
2) Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.
APA format is not required, but solid academic writing is expected.
This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.
Less Than Satisfactory
100.0 %Module 8 Rubric: Database Design Proposal: Product
30.0 %Write-Up Analysis
Analysis of the criteria is not outlined or outlined poorly.
Ignores or superficially evaluates the detail requirements. Draws unwarranted or fallacious conclusions.
Surface level evaluation of the detail requirements is offered. Claims and ideas of the criteria are supported.
Analysis is direct, competent, and appropriate of the criteria.
Thoughtfully analyzes and evaluates the detail requirements. Draws warranted, judicious, nonfallacious conclusions. Information and evidence are accurate, appropriate.
Does not meet the assignment criteria.
Demonstrates minimal knowledge of the subject. Develops most of the database prototype assignment components (one or two components may be missing or inadequate). Does not describe the limitations of the database.
Demonstrates a moderate knowledge of the subject. Develops most of the database prototype assignment components (one component may be missing or inadequate). Does not fully describe the limitations of the database.
Demonstrates knowledge of the subject. Develops all of the database prototype assignment components. Describes the proposal plan. Justifies some of the limitations of the database.
Demonstrates a full and deep knowledge of the subject. Develops all of the database prototype assignment components. Accurately presents the impact of the database in practice.
Content is incomplete or omits most of the requirements stated in the assignment criteria.
Content is incomplete or omits some requirements stated in the assignment criteria.
Content is complete, but somewhat inaccurate and/or irrelevant. Research is inadequate in relevance, quality, and/or timeliness.
Content is comprehensive and accurate, and rationales are clearly stated. Research is adequate, timely, and relevant, and addresses all of the issues stated in the assignment criteria.
Content is comprehensive, accurate, and persuasive; rationales are clearly stated. Research is adequate, timely, and relevant, and addresses all of the issues stated in the assignment criteria.
8.0 %Language Use and Audience Awareness (includes sentence construction, word choice, etc.)
Inappropriate word choice and lack of variety in language use are evident. Writer appears to be unaware of audience. Use of "primer prose" indicates writer either does not apply figures of speech or uses them inappropriately.
Some distracting inconsistencies in language choice (register) and/or word choice are present. The writer exhibits some lack of control in using figures of speech appropriately.
Language is appropriate to the targeted audience for the most part.
The writer is clearly aware of audience, uses a variety of appropriate vocabulary for the targeted audience, and uses figures of speech to communicate clearly.
The writer uses a variety of sentence constructions, figures of speech, and word choice in distinctive and creative ways that are appropriate to purpose, discipline, and scope.
7.0 %Mechanics of Writing (includes spelling, punctuation, grammar, language use)
Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice and/or sentence construction are used.
Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register), sentence structure, and/or word choice are present.
Some mechanical errors or typos are present, but are not overly distracting to the reader. Correct sentence structure and audience-appropriate language are used.
Prose is largely free of mechanical errors, although a few may be present. A variety of sentence structures and effective figures of speech are used.
Writer is clearly in command of standard, written, academic English.
100 %Total Weightage
Database Design Proposal: Product
Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design.
Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.
The database design protocols focuses on creating and maintain a database for a hospital that can be accessed by users in various departments, including the health practitioners working there and they can also access patient detail when a need arises. Automating the records system will allow the users to identify relevant data faster and while the database contains data from diverse sources, users will get the information that they have require based on the queries. The database is a relational one that focuses on patient data and the health practitioners.
FieldRelationshipPatient idprimary keyNameAgeGenderWeightPhone noAddressInsurance coverage Disease/ of conditionPhysician no
FieldsRelationshipspatient idprimary keyroom nodate of admissiondate of dischargelab noOutpatient table
FieldsRelationshipsPatient idPrimary keydatelab no
Physician/ doctor table
FieldsRelationshipDoctor idPrimary keydoctor namedepartment
FieldsRelationshipradiologist idPrimary keyradiologist name
FieldsRelationshippharmacist idPrimary keyPharmacist name
FieldsRelationshipnurse idPrimary keynurse namenurse department
FieldsRelationshipsroom numberprimary key room typestatus
When designing a database it is necessary to identify the fields and the users of the database system, since it should achieve the intended purpose. The database system requires less maintenance when compared to the paper based system, and this saves time and effort. (Ismail, 2014) For the different entities (tables) and attributes (columns), I identified the fields and the relationships since the primary key determines the relationship to the other attributes. For the database system, the various users will seek specific information mostly focusing on the patient as is common in the electronic health records. Hence, the health practitioners need to get used to using the proposed project to access data and information when they required.
Avoiding duplication is important as the database needs to contain the relevant content the leaders ensure that there is efficient performance (Hazen et al., 2014). Regardless of the type of information that the users want, an easy to use system that allows them to retrieve data the required information is necessary. When the patients first arrive there is a ne
- Health Data Reporting: Substance Abuse Crises and Mandatory ReportingDescription: How was this information gathered and submitted to the authorities? Propose ways of improving the status quo and provide reasons why this has not yet been accomplished....3 pages/≈825 words | 2 Sources | APA | Health, Medicine, Nursing | Coursework |
- Database Design Proposal Coursework: Analysis Description: What types of information or data would the users of the proposed system like to have compiled. What would this data provide evidence of or answer? Provide specific examples. ...3 pages/≈825 words | 3 Sources | APA | Health, Medicine, Nursing | Coursework |
- HIM650 v10R Assignment: Database Schema-SQL Statements Description: Modify the database by adding an additional column to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph...3 pages/≈825 words | 3 Sources | APA | Health, Medicine, Nursing | Coursework |