1. Engineering
  2. Computer Science
  3. in a company database details of the customers the products...

Question: in a company database details of the customers the products...

Question details

In a company database, details of the customers, the products sold and the orders made by customers are stored in the relations Customer, Product and Order, respectively: Customer Product cid c001 Jones c002 Smith c003 Green c004 Williams county Essex Surrey Kent Kent pid pname county stockprice 1114 0.50 2030 0.50 1506 1.00 1.00 2214 1.00 cname Sussex Kent Surrey p02 1253 p04 hammer p05 screws Essex Order ordno month cidpid quantity 1011 jan c00 p01 100 1012janc0p2 100 40 80 1015 ja034 120 1021 fe04p 100 1023| mar c001 роз 50 100 102603 120 y c002 1014 jan 003 p02 1. Explain the following terms in the context of the relational model. (e) Candidate key (b) Primary key (c) Altenate key (d) Foreign kesy
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution