Reference no: EM133552344

As of now we cant have seem to update data

let picture it out for you

educ table
ID       fname       lname       dob     educ
1        test        test300             educ1
2        test        test100             educ2

observe table
ID       fname       lname       dob     observe
1        test        test500             observe data
2        new         new                 observe 2

 work table
 ID      fname       lname       dob     work
 1       test        test200             observe data
 2       new         new                 observe 2

if the user would search only data with fname = test: results:
    educ :      id:1
    observe:    id:1
    work:       id:1

Analysis:

based on the result any of this persons are all different

Questions?

1. what last name would we put in the information?(last name of educ table? of observe table? or work table?)

2. If all of theme has DOB who's dob will we used to?(work's)