Your Prototype Database Design Proposal: Product
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.
Unsatisfactory
0.00%
2
Less Than Satisfactory
74.00%
3
Satisfactory
79.00%
4
Good
87.00%
5
Excellent
100.00%
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.
40.0 %Prototype
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.
15.0 %Comprehension
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
Cancel
Database Design Proposal: Product
Name
Institution
Date
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.
Synopsis
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.
Patient table
FieldRelationshipPatient idprimary keyNameAgeGenderWeightPhone noAddressInsurance coverage Disease/ of conditionPhysician no
Inpatient table
FieldsRelationshipspatient idprimary keyroom nodate of admissiondate of dischargelab noOutpatient table
FieldsRelationshipsPatient idPrimary keydatelab no
Physician/ doctor table
FieldsRelationshipDoctor idPrimary keydoctor namedepartment
Radiologist table
FieldsRelationshipradiologist idPrimary keyradiologist name
Pharmacist
FieldsRelationshippharmacist idPrimary keyPharmacist name
Nurses
FieldsRelationshipnurse idPrimary keynurse namenurse department
Room table
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 need to record their basic information. This includes the name, age, phone number and address, as well as other information like insurance coverage as this influence billing as such, there was patient table, inpatient table and the outpatient table, and the patients may need to see more than one doctor and especially when t...
π Other Visitors are Viewing These APA Coursework Samples:
- Assignment: Access to Shelter to Schizophrenic Patients12 pages/β3300 words | 10 Sources | APA | Health, Medicine, Nursing | Coursework |
- Provider patient communication1 page/β275 words | 4 Sources | APA | Health, Medicine, Nursing | Coursework |
- Coursework Journal Request for Practice Experience2 pages/β550 words | No Sources | APA | Health, Medicine, Nursing | Coursework |
- Nursing Leadership Essay Help3 pages/β825 words | 5 Sources | APA | Health, Medicine, Nursing | Coursework |
- Biomedical, Information and Knowledge Technology Coursework1 page/β275 words | 4 Sources | APA | Health, Medicine, Nursing | Coursework |
- Topic 4 Discussion 1: United States health system1 page/β275 words | 2 Sources | APA | Health, Medicine, Nursing | Coursework |
- Childhood Education1 page/β275 words | 1 Source | APA | Health, Medicine, Nursing | Coursework |