android smart card id checker

Android Smart Card ID Checker

UHCL Capstone Team 6Michael WoodruffRaymond Nnodim

Faisal Moiz

Presentation Outline

• Background• Requirements• User interface• Data model• Communications model• Q and A

Background

• Johnson Space Center security access

• Goal – use smart card embedded in ID badge to verify appropriate access

• Tietronix Software sponsoring project

Common Access Cards

• NFC – Near Field Communication– ISO 14443 – operates at 13.56 MHz– Short range communication <= 10 cm– Newer smart phones have embedded NFC readers• Samsung Galaxy Nexus and S II, HTC Amaze 4G

– Android support with SDK 2.3• Personnel Data on card

Requirements

• Use Android smart phone to read NFC cards • Use ID number read to query remote database

and display digital replica of ID card• Display additional personnel details • Display warnings such as revoked or expired cards• Log time and location of scans• Log and photograph Guests• Should work offline

User Interface

Home Screen

Add Guest

Scanned ID Found In Database

Scanned ID Triggers Warnings

Scanned ID Not Found In Database

Data Model

Remotely Generated

PhoneGenerated

Database Tables - Card

Field Data Type

ID (PK) varchar(20)Flags tinyintExpiration_Date datetimeLast_Updated datetime

Database Tables – PersonField Data Type

EDI_ID (PK) varchar(20)FName nvarchar(50)LName nvarchar(50)Access_Level varchar(500)Class tinyintCompany varchar(50)Photo varchar(100)Flags varchar(500)Card_ID (FK) varchar(20)Last_Updated datetime

Database Tables - GuestField Data Type

ID (Auto) (PK) intName nvarchar(100)Company varchar(50)Address varchar(50)Photo varchar(100)Comment varchar(500)DateTime datetimeLatitude floatLongitude float

Database Tables - Scan

Field Data TypeID (Auto) (PK) bigintCard_ID varchar(20)DateTime datetimeLatitude floatLongitude float

Pull Personnel Records

Remote Database

Local Database

Request records

Send records

Save records to local database

Retrieve Personnel Data Locally

Remote Database

Local Database

Remote Database UnavailableUse local copy

Scan/Guest Log Data

Local Database

Save Scan/Guest Logs

Push Scan/Guest Logs

Remote database

Local database

Push Scan/Guest Logs

Logs Received Confirmation

Delete Logs from Local Database

Retrieve Logs to send from localdatabase

Questions