Posts by debasisdas

174

174

178

182

186

you are not passing date in proper format.

190

yes, it can be if it a combination of more than one field and may be one filed is enough to uniquely identify the records.

in your case super key is not (12,harry) or (13,harry)

it is (emp_ID, firstname)

and since data in firstname column is exactly same , that is not going to help in uniquely identifying the records.

So only the emp_id is enough for the unique identification of record.

The more I think about it, the more I realize there is nothing more artistic than to love others.

194

198

Given table: EMPLOYEES{employee_id, firstname, surname, sal}

Possible superkeys are:

{employee_id}
{employee_id, firstname}
...
(employee_id, firstname, surname, sal}

Only the the minimal superkey - {employee_id} - will be considered as a candidate key.

read more here.

202

206

as i have already suggested, continue loading till your counter reaches 30.

exit after that.

Superkey - A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set.

please read more here, here, here .

210

214

226

234

238

242

246

262

That's why i suggested to read books.

If you don't have it, go and purchase it.

Else go for e-books.
If you do not know where to find, search for it in the net, you will find many.

And all these for your information only.

264

every tool I found in the internet you have to buy it first to use it.

Let me tell you something, free lunch is a myth.

and i have a few questions for you.

1. you said you are a tester not a develop right ?
2. what language you are going to use for your tool development.
3. do you know how to write code / what code to write to create an application.
and the most important question
4. Why you want to create a free toll for everyone ?

272

276

280

post your code here, will try to fix that.

what is the code that you are using ?

what is the error ?

go and collect all the code i have thrown in trash :twisted:

Forget to mention the trash can is in my back yard and i will be happy if you completely clean that.

Please find some sample here.

284

298

302

306

310

314.

314

318

322

326

330

334

338

342

346

350