[solved]-Basics Balancing Profiling Thresholds Objectives Assignment Aimed Building Students Local Q39045143

Basics, Balancing, Profiling, and Thresholds

Objectives: This assignment is aimed atbuilding the students local database environment, as well asrefreshing students on database concepts that are foundational forthis course. By the end of this assignment, students will have alocal database running, have confirmed that the number of recordssupplied for each table matches the number of records they loaded,and be able to profile their table with the student some generateddata within it.

Prerequisites: Completion of Assignment 1A

Instructions:

Profiling the Data Data in your environment

1. Insert the Data into tables in your database using the codesupplied in the Module 1 Database Build Documents.
   1. Each Table has a supplied record count. On completion ofinserting into your environment, run counts on each table toconfirm the same number of records were loaded into yourenvironment. Here is a sample with the Department Table:
   2. 
2. Having inserted these tables into your database based on thecode given to you complete the following tasks:
   1. Using your understanding of SQL and the examples I sent, Insert5 additional rows into the Student and Section Table
3. Perform Basic Profiling of your data & Submit viaBlackboard
   1. Student Table
      1. Count of Distinct First Names
      2. Count of Distinct Last Names
      3. Count of Distinct Advisors
      4. Count of students per Major
      5. What percent of students fall into each category of gender
   2. Enrollment Table
      1. Count of Students by Grade
      2. What percent of students have each grade
   3. Course Table
      1. Count of Courses Offered by Department
   4. Number of Majors
      1. Count of Majors Offered
   5. Number of Faculty
      1. Count of Distinct First Names
      2. Count of Distinct Last Names
      3. Count of Faculty per job
      4. Percent of Faculty are in each job
4. Suggest a possible threshold based on the profiling in step3.iv to help use in the future to inform whether or not the databeing loaded appears to be valid. This would be represented as thepercentage of records by the distinct value that you believe makessense. Note there is no wrong answer here
   1. Faculty by job
   2. Enrollment by student grade

Submit in .docx or .pdf format screenshots and a yes or no foreach table on whether or not the counts match from question 1.a,and the results from your queries from Section 3 of theInstructions, and the suggested values in 4.

Expert Answer

---

Answer to Basics, Balancing, Profiling, and Thresholds Objectives: This assignment is aimed at building the students local databas… . . .