MGMT PP SMARTS DATABASE REPORTING & ANALYTICS 1 TABLES (Data Sets / Entities / Relations) a) Identify three (3) primary Tables you would want to have based on the case background. b) Justify why each table is necessary for the developing system. 2. For EACH of the tables identified at (#1) above a) List 3–4 data elements that can be stored and explain the role/purpose of each in your developing database system. Indicate, with a brief explanation, what you would use as the primary keys. b) As part of your listed data elements, define the following metadata for each: Data/Field Type, Field Size, and any possible constraint/s or needed c) Identify and describe the relationship/s among the tables. Please provide an example to illustrate Referential Integrity and explain why it is essential for data credibility. 3. Since your boss desires several business reports, justify with an explanation three (3) queries you will likely make regarding the reports' creation. For one (1) report, indicate what type of business report it is (NB! Research Types of Business Reports), outline the layout and possible content relevant to the case scenario (NB! You can show it diagrammatically if desired), and which Management level and Functional area, with justification, would be best served by this report. 4. Design diagrammatically a Form layout with a Subform that facilitates data entry for your database system. Provide a brief description of the form's purpose and functionality
MGMT PP SMARTS DATABASE REPORTING & ANALYTICS
1 TABLES (Data Sets / Entities / Relations)
a) Identify three (3) primary Tables you would want to have based on the case background.
b) Justify why each table is necessary for the developing system.
2. For EACH of the tables identified at (#1) above
a) List 3–4 data elements that can be stored and explain the role/purpose of each in your developing database system. Indicate, with a brief explanation, what you would use as the primary keys.
b) As part of your listed data elements, define the following metadata for each: Data/Field
Type, Field Size, and any possible constraint/s or needed
c) Identify and describe the relationship/s among the tables. Please provide an example to illustrate Referential Integrity and explain why it is essential for data credibility.
3. Since your boss desires several business reports, justify with an explanation three (3) queries you will likely make regarding the reports' creation. For one (1) report, indicate what type of business report it is (NB! Research Types of Business Reports), outline the layout and possible content relevant to the case scenario (NB! You can show it diagrammatically if desired), and which Management level and Functional area, with justification, would be best served by this report.
4. Design diagrammatically a Form layout with a Subform that facilitates data entry for your database system. Provide a brief description of the form's purpose and functionality
Step by step
Solved in 2 steps
