SQL

Insert 5 rows into the Student and Section Table the values here can be of your design. At this time there are no keys so you can reuse ID numbers if youd like.

Perform Basic Profiling of your data & Submit via BlackboardEach Table

Count of values in each of the ID fields

Count of Distinct values in each of the ID fields

Each Column

Check to see whether or not there are Null values in the columns (hint you will need to use a where clause like where column_name is null)

Student Table

Count of Distinct First Names

Count of Distinct Last Names

Count of Distinct Advisors

Count of students per Major

Enrollment Table

Count of Students by Grade

Course Table

Count of Courses Offered by Department

Number of Majors

Count of Majors Offered

Number of Faculty

Count of Distinct First Names

Count of Distinct Last Names

Count of Faculty per job