Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
This is my attempt. Let me know if it makes sense, are PK/FK correct, and line notation.
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started