Gurao_Adityavikram_Tutorial_Two

.docx

School

Worcester Polytechnic Institute *

*We aren’t endorsed by this school

Course

584

Subject

Information Systems

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by DrTitaniumRhinoceros

MIS - 502 Tutorial Two By Adityavikram Rajendra Gurao Column Profiling: Attribute: Lead_Key.LEADS.HMIS Type: INTEGER CONSTANT Domain: Numeric { 1 to 20539 } Pattern: Unique Increasing Numbers. # Records: 20,539 unique (none null) Dependencies: None Redundancies: None

Attribute: Entity_No.LEADS.HMIS Type: INTEGER Domain: Numeric { 2 to 100063557 } Pattern: Unique Increasing Numbers. # Records: 20,539 (none Null) 4003 Unique Values Median - 20,297 Mode - 2619 2621 22161 42056

Max - 100055263 Dependencies: Lead_Key, Name Redundancies: None

Attribute: Name.LEADS.HMIS Type: Text, Alphabetic (10 to 89), VARCHAR (50) Domain: { Hospital Names } Pattern: Repeats across hospitals similarly named in different cities across states; 3,699 hospitals have unique names # Records: 20,539 (none Null) 3,743 Unique Values Dependencies: Lead_Key, Entity_No Redundancies Entity_No

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help