Conceptual Data Model For The Planned Database Discussion
Here is a brief synopsis to help you understand entities, attributes, relationships and data models.
An entity is the thing we want to gather information about and you can visualize it as a table with columns and rows. Each entity or table is named and usually is a noun. Each column is an attribute, is named, and represents specific information; while each row is a particular instance of what the entity or table signifies. Relationships supply the structure needed to pull information from multiple entities or tables and are usually verbs.
A data model is a tool that we use to describe the data requirements and assumptions in a system, but a model also determines the structure of data, facilitating the design of databases. Conceptual Data Model For The Planned Database Discussion
ORDER HERE A PLAGIARISM-FREE PAPER HERE
Sample entities: Sample relationships: E-R Diagram Symbols:
Patient Assigned
Physician Attend
Nurse Take
Drug Paid
Payment Associated
Staff Track
Treatment Record
Unit Treated
Nurses attend to the patients. There are a number of patients assigned to each unit. Usually each patient will have many nurses but only one primary physician. Conceptual Data Model For The Planned Database Discussion
What questions could we ask?
- Which nurses work on which units?
- How many patients are assigned to each unit?
- Which physician cared for the most patients?
- Which nurses cared for which patient?
Cardinality Examples:
Patient to nurses – One to Many (1:M) / Patient to primary physician – One to One (1:1)
Please reflect on your E-R Diagrams and data models. Make sure that you have considered everything and your diagram is a visual picture that is easy to interpret and represents your intended data structure.
REQUIREMENTS:
This 2 to 4 page paper presents a database plan for a nursing or healthcare problem dealt with in the past or active in the present. Explain the problem and the reason(s) a database is needed. Provide a conceptual data model for the planned database. Name all the entities planned for the database and justify their selection. In an appendix, provide an E-R diagram that shows each entity, names the identifier for each entity, and illustrates the relationships between each entity, noting the cardinality. In the paper, write a narrative explanation of key parts of the E-R diagram, including how you arrived at some of the decisions on relationships and cardinality. Include three questions planned for this database (the original questions from the discussion in week 1 may be used). Provide a recap of the paper and discuss insights on databases developed as a result of working on this assignment. Support all decisions from the scholarly literature. Conceptual Data Model For The Planned Database Discussion
PREPARING THE PAPER
Please Note: The database project will be developed in Microsoft Excel or Access
Criteria for Content:
- An introduction informs about the topic of the paper and how it is organized.
- Explanation of the selected problem and why it needs a database as an information-management solution
- Explanation of a conceptual data model for the planned database
- All entities planned for the database are named.
- A justification or rationale for each entity is provided.
- The E-R diagram for each entity is discussed briefly in the text and is found in an appendix. The E-R diagrams can be created for individual entities mapped to all other relevant entities or a single E-R diagram showing all entities and their relationships may be provided.
- The identifier for each entity is named. The identifier can be narrated in the paper or included with the E-R diagram in the appendix.
- The relationships between entities are discussed briefly in text and illustrated, including cardinality, in the E-R diagram in the appendix or in a separate appendix.
- Three questions planned for the database are provided. The original questions presented in week 1 discussion may be used, or revised questions may be presented. Conceptual Data Model For The Planned Database Discussion
- A conclusion that recaps the paper and discusses insights gained from working on this assignment is presented.
Criteria for Paper Format and Special Instructions:
- E-R diagrams will be in an appendix with your 3 questions on the document.
- Illustrations of entity relationships will be in an appendix
- Drawings can be done with Microsoft Office tools, or with third-party software
- The database project will be developed in Microsoft Excel or Access
- All aspects of the paper must be in current APA format
- Only scholarly literature is used to support decisions
- The paper (excluding the title page, references, and appendices) must be 2-4 pages.
- A minimum of 3 references are required. One of the course texts may be used as a reference.
- Grammar, spelling, punctuation, citations, and references are consistent with formal academic writing. Conceptual Data Model For The Planned Database Discussion