Instructions

Part A – Create a diagram or Table (be creative) of a medical records database, to include the following:

• Database name
• Table Name
• The fields that would support each record in the database such as (Unique Identifier, Last Name, First Name, etc.) 
• Addressing the following questions:

A) Identify all of the database design steps and describe each.
B) Highlight the value of each step. Each step and description should be approximately 50+ words.
C) Use an illustration (picture, drawing, sketch, figure, graphic) to explain how the bottom-up design approach differs from the top-down design approach.
D) Which approach do you believe should be used to design a simple database with a relatively small number of attributes and why? 

Part B – Define and illustrate (picture, drawing, sketch, figure, graphic) an example for the different multiplicity relationships (one-to-one, one-to-many, many-to-many).

Assignment Guidelines

The submission should demonstrate your understanding of the assigned material. 

The content must be original, and include supporting sentences using the terms, concepts, and theories from the assigned readings and other material (optional). The submission must paraphrase the referenced material, restrict the use of direct quotes (copy and paste) to less than 15% of the submission (the grade will be impacted if this limit is exceeded).

• There are writing guidelines in the syllabus – use good judgement, the submission must be well organized. Provide citations and references in APA style.
• Name your document Last Name_Assignment4 (i.e. Smith_Assignment4).

According to Parker (2023), "Mind maps are…excellent [tools] for planning workflows, visualizing task dependencies, brainstorming new processes—and feeling creative while doing it! These diagrams typically start with one main idea or with an end goal in mind to branch out, and your diagram naturally takes shape from there. They are highly visual, and the best ones are also flexible, customizable, and collaborative"