Answer Posted / mona

A set of fields that uniquely identifies a tuple according
to a key constraint is called candidate key for the relation.
(1)No two values of keys are same
(2)the set of fields{sid,sname} is not a key for
students,because this set properly contains the key{sid}.
The set {sid,sname} is an example of a super key,which is a
set of fields that contains a key.
EX:
create table customer(customer_name char(20),street
char(30),city char(30),primary key(customer_name));

What is data modeling with example?

902

---

Which data type cannot be used as a parameter in a udf?

909

---

explain detail about ftp in datastage?

2181

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

947

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2099

---

How is data stored in dbms?

883

---

What is a database development?

901

---

Explain about normal forms?

985

---

Explain about a primary key?

928

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3945

---

What is the database development process?

1148

---

What is dbms explain in brief?

953

---

Explain about the database management systems.

917

---

Explain about relational operator join?

978

---

What are the key features of dbms?

941

---