Get Answer: Scenario Beginning Design Question Guide
Students often encounter this when studying fundamental concepts.
What This Question Is About
This question relates to scenario beginning design and requires a structured academic response.
How to Approach This Question
Structure your response with introduction, analysis, and conclusion.
Key Explanation
This topic involves scenario beginning design. A strong answer should include explanation, application, and examples.
Original Question
SCENARIO: You are beginning to design a database to store patient data. For each of the data elements in the database there should be a corresponding entry in the data dictionary. Create data dictionary entries by filling in the blank fields in the attached file. For each value you specify, also provide a brief explanation of your response in the space provided in the “Why?/Description” Column. There are multiple data types to consider in this assignment (Alphabetic, Text, Numeric, Drop Down, alpha-numeric, calculation, etc.). You should do additional research to understand the differences between these data types. Not all types may be used, but as you create your responses, keep them all in mind to select from. Where required by the assignment instructions, descriptions should be one brief sentence. Your answers should reflect that you are applying knowledge and skills learned from the reading materials and your additional online research. You will need to apply critical thinking about the data type, format, and field size, and other information needed. Data Dictionary Entry for LastName (fill in the table) – 6 points Field Name LastName (Example) Why? (Briefly Explain your responses) and Description Data Type Why? Description: Format Why? Description: Field Length (Name Number of Characters) Why? Range (Starting letter or number Ending letter of number) Why? Required? (Yes or No) Why? Data Dictionary Entry for FirstName (fill in the table) – 6 points Field Name FirstName (Example) Why? (Briefly Explain your responses) and Description Data Type Why? Description: Format Why? Description: Field Length (Name Number of Characters) Why? Range (Starting letter or number Ending letter of number) Why? Required? (Yes or No) Why? Data Dictionary Entry for MiddleName (fill in the table) – 6 points Field Name MiddleName (Example) Why? (Briefly Explain your responses) and Description Data Type Why? Description: Format Why? Description: Field Length (Name Number of Characters) Why? Range (Starting letter or number Ending letter of number) Why? Required? (Yes or No) Why? Data Dictionary Entry for Social Security Number (fill in the table) – 6 points Field Name Social Security Number (Example) Why? (Briefly Explain your responses) and Description Data Type Why? Description: Format Why? Description: Field Length (Name Number of Characters) Why? Range (Starting letter or number and Ending letter of number) Why? Required? (Yes or No) Why? Data Dictionary Entry for Telephone Number (fill in the table) – 6 points Field Name TelephoneNumber (Example) Why? (Briefly Explain your responses) and Description Data Type Why? Description: Format Why? Description: Field Length (Name Number of Characters) Why? Range (Starting letter or number Ending letter of number) Why? Required? (Yes or No) Why? Data Dictionary Entry for Date of Birth (fill in the table) – 6 points Field Name Date of Birth (Example) Why? (Briefly Explain your responses) and Description Data Type Why? Description: Format Why? Description: Field Length (Name Number of Characters) Why? Range (Starting letter or number Ending letter of number) Why? Required? (Yes or No) Why? Short answer question – 4 points: What data type should a Zip Code be? Why? PLEASE PROVIDE ALL SOURCES USED PLEASE, THANK YOU There are multiple possible correct answers, as long as you provide an appropriate explanation.
******CLICK ORDER NOW BELOW AND OUR WRITERS WILL WRITE AN ANSWER TO THIS ASSIGNMENT OR ANY OTHER ASSIGNMENT, DISCUSSION, ESSAY, HOMEWORK OR QUESTION YOU MAY HAVE. OUR PAPERS ARE PLAGIARISM FREE*******."
