Question: Part 1: Conceptual business model. Construct a conceptual business model for an industry or business that you are familiar with or have interest in. Visually

 Part 1: Conceptual business model. Construct a conceptual business model for

Part 1: Conceptual business model. Construct a conceptual business model for an industry or business that you are familiar with or have interest in. Visually it should be similar to the one we illustrated in Module 1, Video 2. 0 Your model should represent at least 10 ideas it should visually represent one to one, many to one, or many to many relationships among ideas Part 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4 0 Your model should have at least 5 tables 0 You should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table) 0 Your model should be normalized 0 identify the primary key in each table, and state whether it is a natural or surrogate key 0 For each relationship between tables. identify any foreign keys needed to define the relationship 0 For each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6. Part 3: SQL queries. Using the data model you constructed in Part 2, come up with two data extracts you think would be interesting, then write SQL queries to provide each one. 0 For each query, state what data you are trying to get and why it would be interesting 0 Provide the SQL query using the commands and syntax we learned in Module 3 0 For maximum credit, at least one of your queries should involve ajoin across two or more tables. Part 4: Sensitive data and data quality issues. Consider the data privacy and data quality implications of the data model you constructed in Part 2. ' identify any fields you think might be Pll, lCFI, CPNI, or PHI as we defined in Module 4, Video 4 ' What data elements in your model will present the most significant data quality challenges? Explain your reasoning

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 Mathematics Questions!