Create multiple records of the application and related entities and then insert them with some different values of Affiliation, funding sources.

Assignment Question

Given the use case of a long form application, the goal is to:

1) Build a data model relationship diagram (with visio and/or lucid charts) . The data model should be extremely clear for cardinality, as many attributes as possible with primary key and foreign key relationships.

2) After the data model, use the data model to create tables and assign privileges to the application owner. Add another user who has only access to the say Funding tables and not all of the application tables.

3) DDL’s should be used, then use DML statements to update one of the tables. DCL are used to assign user privilege’s.

4) Create multiple records of the application and related entities and then insert them with some different values of Affiliation, funding sources.

5) Run a query to find out if there is affiliation risk or funding concentration risk (defined as when the company has more than 3 countries associated with listed countries of concern or if more than 60% of their funding is from countries of concern)

6) The power point should consist of atleast 4 slides ideally 5 to 6:

i) Data Model with clear cardinality relationships and attributes with relationships

ii) Normalization (3rd Normal form) with confirmation query tests of insert Anamoly, update Anamoly etc demonstrating removal of all depandancies.

iii) Query plan with explanation of query plan to understand where the query spends its most time and how we can improve query with indexing and other techniques

iv) Queries to get the financial and affiliation risks

v) Putting all of this together – Why the team think this Datamodel will work with the application very well.

Last Completed Projects