Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the following information provided below, design a simple database and its cardinality),between tables. I need an sql file lead_id,account_id,date_created,date_modified,date_fronted,date_converted,vendor_id,status_id,fronter_id,agent_id,first_name,last_name,address,address2,city,state,zipcode,county,country,email,email2,phone,phone2,phone3,gender,heightft,heightin,weight,dob,age,sob,ssn,time_zone,contact_time,contact_preference,language,budget,annual_income,conditions,medications,occupation,smoker,married,insured,insured_premium,insured_carrier,insured_intent,cost,reference_id,campaign_id,tracking_id,ip_address,referrer,page,marketing,newsletter,modified,touched,lmb,vendor,status,lmb_id,lmb_name,agent,agent_name,fronter,fronter_name 7032476,18,1/6/2017 14:30,1/6/2017 14.35.,1/6/2017_14.33_.248 2 ,1448

Using the following information provided below, design a simple database and its cardinality),between tables. I need an sql file

lead_id,account_id,date_created,date_modified,date_fronted,date_converted,vendor_id,status_id,fronter_id,agent_id,first_name,last_name,address,address2,city,state,zipcode,county,country,email,email2,phone,phone2,phone3,gender,heightft,heightin,weight,dob,age,sob,ssn,time_zone,contact_time,contact_preference,language,budget,annual_income,conditions,medications,occupation,smoker,married,insured,insured_premium,insured_carrier,insured_intent,cost,reference_id,campaign_id,tracking_id,ip_address,referrer,page,marketing,newsletter,modified,touched,lmb,vendor,status,lmb_id,lmb_name,agent,agent_name,fronter,fronter_name

7032476,18,1/6/2017 14:30,1/6/2017 14.35.,1/6/2017_14.33_.248 2 ,1448 Sheng.Kim,29B NW 117th Way,.pompano d.733,"Williams. Donovan,'.sGphaniewaggoner SfRCtO-Wrggon"i, Si"pnrri";,,

7032476,18,1/6/2017 14:30,1/6/2017 14:35,,1/6/2017 14:33,248,2,,1448,Sheng,Kim,298 NW 117th Way,,Pompano Beach,FL,33071,,US,jkskim@ymail.com,,9542542177,,,M,5,10,170,6/29/1986,30,,591801063,,,,,,,,,,0,0,0,,,,0,,,,,,,0,0,9,1,d.williams,GENERAL,Converted,733,"Williams, Donovan",stephanie.waggoner,"SERGIO-Waggoner, Stephanie",,

7032420,18,1/6/2017 13:16,1/6/2017 13:20,,1/6/2017 13:20,248,2,,1448,Leticia,Meza,31200 Arbol real,,1000 Palms ,CA,92276,,US,letymeza@verizon.net,,7602851597,,,F,5,4,170,5/22/1957,59,,548393346,,,,,,,,,,0,0,0,,,,0,,,,,,,0,0,3,1,stephanie.waggoner,GENERAL,Converted,1448,"SERGIO-Waggoner, Stephanie",stephanie.waggoner,"SERGIO-Waggoner, Stephanie",,

7032360,18,1/6/2017 12:14,1/6/2017 12:30,,1/6/2017 12:22,248,2,,1389,Earl M.,Manahan,27800 McBean Parkway Apt 246,,Valencia,CA,91354,,US,em125@ymail.com,,6612315547,,,M,5',,157,1/25/1967,49,CA,216-31-3155,,,,,,,,,,0,0,0,,,,0,,,,,,,0,0,6,1,ghc.jose,GENERAL,Converted,1389,"GHC - Ordonez, Jose",ghc.jose,"GHC - Ordonez, Jose",,

7032291,18,1/6/2017 11:25,1/6/2017 11:25,,,248,20,,,Willie , Solomon,1148 Santa Fe Trail,,Macon,GA,31220,,US,Joy5445@ad.com,,4784742466,,,F,5,5,204,2/12/1954,62,,257881614,,,,,,,,n/a,,0,0,0,,,,0,,,,,,,0,0,1,1,health.choice,GENERAL,Manual Insert,1416,"Choice, Health",,,,

7032288,18,1/6/2017 11:21,1/6/2017 11:36,,1/6/2017 11:36,248,2,,1521,Shivashanker,Veeranna,8131 N new bug rd. apt 103,,west land ,MI,48185,,US,shiva0023@ymail.com,,7346209574,,,M,5,7,62,12/23/1979,37,,845776405,,,,,,,,,,0,0,0,,,,0,,,,,,,0,0,6,1,t.johnson,GENERAL,Converted,1521,"GHC - Johnson, Terrance",t.johnson,"GHC - Johnson, Terrance",,

7032269,18,1/6/2017 10:56,1/6/2017 11:12,,1/6/2017 11:12,248,2,,1395,willie,avery,1211 B sandford place,,Opelika,AL,36801,,US,cidavery@ymail.com,,3346631194,3347044212,,M,5,2,195,4/14/1962,54,AL,418-02-7100,,,,,350,,diabetic,jentodueto,truck driver,0,0,0,,,,0,,,,,,,0,0,4,1,joel.bernstein,GENERAL,Converted,1395,"SERGIO - bernsten, joel",joel.bernstein,"SERGIO - bernsten, joel",,

7032267,18,1/6/2017 10:55,1/6/2017 10:56,,1/6/2017 10:56,248,2,,1409,Chakendra P,Cooper,3585 Hemingway Hwy,,Hemingway,SC,29554,,US,aunt_gee@hotmail.com,,8033975119,,,F,5,3,160,2/24/1975,41,,247594074,,,,,,,,,,0,0,0,,,,0,,,,,,,0,0,1,1,customer.service,GENERAL,Converted,1409,"Service, customer",customer.service,"Service, customer",,

7032261,18,1/6/2017 10:51,1/6/2017 10:52,,1/6/2017 10:52,248,2,,1409,Carma L,Russell,10805 Tall Oak Dr,,Fort Worth,TX,76108,,US,creativeoldpro@ymail.com,,8173670379,,,F,5,3,160,9/4/1960,56,,455331522,,,,,,,,,,0,0,0,,,,0,,,,,,,0,0,1,1,customer.service,GENERAL,Converted,1409,"Service, customer",customer.service,"Service, customer",,

7032246,18,1/6/2017 10:34,1/6/2017 10:41,,1/6/2017 10:40,248,2,,1428,tina m,hill,8504 old ham rd,,kansas city,MO,64138,,US,rayray146_3@hotmail.com,,8168303563,8163524595,,F,5,,145,5/6/1956,60,MO,493-66-7320,,,,,,,,,,0,0,0,,,,0,,,,,,,0,0,3,1,s.smalls,GENERAL,Converted,1428,"GHC - Smalls, Sidney",s.smalls,"GHC - Smalls, Sidney",,

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

Database Processing Fundamentals Design And Implementation

Authors: KROENKE DAVID M.

1st Edition

8120322258, 978-8120322257

More Books

Students also viewed these Databases questions

Question

4. Does mind reading help or hinder communication?

Answered: 1 week ago