Cscc research database

This is the third of a multi-part case study for a company called National Investments. Part of your work over the course of the semester will be to design and build a database for this fictional company. Though fictitious, the narrative and issues discussed are very real for many companies. You must read these case studies carefully and thoroughly to fully understand their business and their needs. This is part of the requirement for building effective and efficient databases.Your continued work is getting noticed! You have started the design for the new database (as rudimentary is it might be, at the moment), you have been thinking about requirements gathering, and about further questions that you believe need to be asked and answered for you to continue your work.

In one of your most recent emails you asked for a sample of the data currently being used that needs to be part of this new database design.

You have been supplied with Excel examples of data currently maintained by the organization. Thinking through the work you have already completed with these additional pieces of information your job now is to prepare a first-draft drawing of the database using Draw.io as your tool of choice.

This first-draft drawing and additional materials, as noted below, are in preparation for your next meeting with the partners.

Assignment
Purpose:
You begin reflecting back to the memo you wrote initially and then to the interview questions and answers and the proposal you most recently submitted. At that time, you had only a vague understanding of the business and you did a rough sketch of a few tables that you thought would be required for this database design. Now that you are reviewing some of the data provided to you that rough sketch needs to become a first-pass diagram of the new database solution. Your initial ideas for tables may or may not still hold in light of the data that you have now received.