homeworkstudyhelp

Our Services

Get 15% Discount on your First Order

Use a Lucid chart to Build a Logical Entity Relationship Diagram…

  1. Use a Lucid chart to Build a Logical Entity Relationship Diagram (ERD) and also Build a Physical ERD based on the data dictionary below.
  2. give at least three references and summary of the work
Field Name in Original Source Field Name in Your Database Data Type Short Description of Data Field Required Field? Accepts NULL Value?
ARREST_KEY Arrest_Key Integer Unique identifier for an arrest Yes No
ARREST_DATE Arrest_Date Date Date of the arrest Yes No
PD_CD PD_CD Integer Internal classification code for NYPD crime classification Yes No
PD_DESC PD_Desc Text Description of the internal classification code for NYPD crime classification Yes Yes
KY_CD KY_CD Integer Three digit internal classification code for NYPD crime classification Yes No
OFNS_DESC OFNS_Desc Text Description of the three digit internal classification code for NYPD crime classification Yes Yes
LAW_CODE LAW_Code Text Law code associated with the arrest charge Yes Yes
LAW_CAT_CD LAW_Cat_CD Text Level of offense classification (e.g., felony, misdemeanor, violation) Yes Yes
ARREST_BORO Arrest_Boro Text Borough of the arrest Yes Yes
ARREST_PRECINCT Arrest_Precinct Integer Precinct of the arrest Yes No
JURISDICTION_CODE Jurisdiction_Code Text Jurisdiction code associated with the arrest charge Yes Yes
AGE_GROUP Age_Group Text Age group of the person arrested Yes Yes
PERP_SEX Perp_Sex Text Gender of the person arrested Yes Yes
PERP_RACE Perp_Race Text Race of the person arrested Yes Yes
X_COORD_CD X_Coord_CD Integer X-coordinate of the arrest location in the New York State Plane Coordinate System Yes Yes
Y_COORD_CD Y_Coord_CD Integer Y-coordinate of the arrest location in the New York State Plane Coordinate System Yes Yes
Latitude Latitude Decimal Latitude of the arrest location Yes Yes
Longitude Longitude Decimal Longitude of the arrest location Yes Yes
New Georeferenced Column New_Georeferenced_Column Text Georeferenced data that includes the longitude and latitude of the arrest location No Yes

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

1. Review History of Project Management from Project Management 101…

1. Review History of Project Management from Project Management 101 2. Activities of Project Management 3, Terminology Matching on the test (Suggestion to go through Chapters and write down definitions) 4. What is project Management? 5. How software project management is different from other management projects (in Chapter 1)? 6.

What are the differences between Qualitative Versus Quantitative…

What are the differences between Qualitative Versus Quantitative Risk Management approaches? Please include examples. How would you decide the best approach to take? Are there times when one approach or the other does not make sense to use?   please list any links for further understanding

Healthcare API (Application Programming Interface) is used in…

Healthcare API (Application Programming Interface) is used in healthcare for interoperability between health information systems. Discuss what API is, why, and how it is used for health information exchange. What are API’s benefits for users?  What are different healthcare APIs and their functions’ similarities/differences? How to choose the correct one