Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Taxation Of Individuals And Business Entities 2016

Authors: Brian Spilker, Benjamin Ayers, John Robinson, Edmund Outslay, Ronald Worsham, John Barrick, Connie Weaver

7th Edition

9781259425479, 125942121x, 1259334872, 1259425479, 9781259421211, 978-1259334870

More Books

Students also viewed these Databases questions

Question

What are some different types of leadership power? AppendixLO1

Answered: 1 week ago