Marks:8 Answer: a) An attribute or set of attributes which are used to identify a tuple uniquely is known as Primary Key. For Example: let us consider a table Dept with following tuples and data. Table: Dept Deptno Dname LOC 101 Computers Ist Floor 102 English II Floor 104 Biology III Floor 109 Physics IV Floor 105 Chemistry V Floor 103 Maths VI Floor From above table Deptno is the Primary Key. b) b1) i) SELECT * FROM STOCK ORDER BY StockDate;
Marks:8 Answer: a) An attribute or set of attributes which are used to identify a tuple uniquely is known as Primary Key. For Example: let us consider a table Dept with following tuples and data. Table: Dept Deptno Dname LOC 101 102 104 109 105 103 Computers English Biology Physics Chemistry Maths Ist Floor II Floor III Floor IV Floor V Floor VI Floor From above table Deptno is the Primary Key. b) b1) i) SELECT * FROM STOCK ORDER BY StockDate;
1329804769qno_5,6,7.docx