Question: Normalize ERD Diagram in Crow Foot NotationT This is my attempt. Let me know if it makes sense, are PK/FK correct, and line notation. Applicant

Normalize ERD Diagram in Crow Foot NotationT

IPA 1(1).png


This is my attempt. Let me know if it makes sense, are PK/FK correct, and line notation.

IPA 2.png 

Applicant PK Applicant ID varchar(22) First Name varchar(22) Last Name varchar(22) SSN integer Driver's integer License Current Address varchar(22) Divided into Renewal Applicant Original Applicant DPS Gives Applicant info Gives location info PK Original ID PK Renewal ID FK Applicant ID FK varchar(22) Check Deposit Applicant ID Finger Prints Payment Confirmation integer varchar(22) Date Issued Type varchar(22) (1,10) date PK Location ID FK Service ID Scanner varchar(22) varchar(22) Bank Information varchar(22) Proof of Residency 3 PK FK Assigns Original ID Location ID Date of Finger date Check Deposit varchar(22) varchar(22) Print Service integer Payment varchar(22) Confirmation Bank Information varchar(22) Issues Receives License PK License ID FK Payment ID varchar(22) varchar(22) Generates Date Issued date Date of Expiration date Assigns Gives applicant Info- FK PK, FK License ID Service ID Renews Receives- PK HC varchar(22) varchar(22) Service Location PK Service ID FK Location ID Scanner varchar(22) varchar(22) Payment Confirmation Payment ID Payment varchar(22) Confirmation varchar(22) Creates HHHHHH FK Applicant ID FK Service ID Check Record Bank Information Amount Paid Date Paid varchar(22) varchar(22) varchar(22) varchar(22) integer date Gives location Info- Assigns

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!