Question: modify the spreadsheet to more closely show the data needed as well as begin to develop the spreadsheet to be converted to an SQL database

modify the spreadsheet to more closely show the data needed as well as begin to develop the spreadsheet to be converted to an SQL database that has good design aspects. Open the spreadsheet provided. Note at the bottom of sheet there are tabs for the following sheets: Patient Doctors Insurance company Schedule Look over each sheet to see how it is setup and then think about how you might improve the current design. To do this, think about how the data might be more meaningful. For example, perhaps separating the name into a First Name column and a Last Name column. If you decide to do this, then indicate by color code of the columns that this was changed. If you think you need to add a column or two, indicate those by color coding them. Also, think about repeat data. Notice that the address is in two places, on the Patient sheet and the Schedule sheet. Decide if this is a good design, if not then make the changes you think would be a better design and explain on the sheet why you changed it. Put notes below the spreadsheet about the changes that you have made and why you made the changes. Do not be vague. Explain as much as possible. Second, you need to develop the business rules that will be reflected in your design of the Excel database.modify the spreadsheet to more closely show the data needed as well as begin to develop the spreadsheet to be converted to an SQL database that has good design aspects. Open the spreadsheet provided. Note at the bottom of sheet there are tabs for the following sheets: Patient Doctors Insurance company Schedule Look over each sheet to see how it is setup and then think about how you might improve the current design. To do this, think about how the data might be more meaningful. For example, perhaps separating the name into a First Name column and a Last Name column. If you decide to do this, then indicate by color code of the columns that this was changed. If you think you need to add a column or two, indicate those by color coding them. Also, think about repeat data. Notice that the address is in two places, on the Patient sheet and the Schedule sheet. Decide if this is a good design, if not then make the changes you think would be a better design and explain on the sheet why you changed it. Put notes below the spreadsheet about the changes that you have made and why you made the changes. Do not be vague. Explain as much as possible. Second, you need to develop the business rules that will be reflected in your design of the Excel database.
submit the modified spreadsheet with updates to fields, add columns where you think it is necessary, drill down into data where appropriate. Add additional sheets if you see there is something missing

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!