Part A – Create a diagram or Table (be creative) of a medical records database,
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).
