Uncategorized

(i) What will be the degree of student table?a) 30b) 1c) 3d) 4Ans: 3 (degree means columns and total no of columns are 3) (ii) What does ‘name’ represent in the above code snippet?a) A tableb) A rowc) A columnd) A databaseAns: A column (iii) What is true about the following SQL statement?SelecT * fROM […]

a) Name primary key of each table.b) Find foreign key(s) in table PROJECT-ASSIGNED.c) Is there any alternate key in table STUDENT? Give justification for your answer.d) Can a user assign duplicate value to the field RollNo of STUDENT table? Justify. Ans:(a) Table Primary key Student Registration_ID Project ProjectNo Project_assigned – (b) Registration_ID and ProjectNo(c) Yes,

(a) Can they insert the following tuples to the UNIFORM Relation? Give reasons in support of your answer.(i) 7, Handkerchief, NULLAns: Yes, it can be inserted as UColor does not have Not Null constraint.(ii) 4, Ribbon, RedAns: No, it cannot be inserted as UCode is Primary key and 4 is already existing and so we

a) Name the attributes of EMPLOYEE, which can be used as candidate keys.b) The company wants to retrieve details of dependent of a particular employee. Name the tables and the key which are required to retrieve this detail.c) What is the degree of EMPLOYEE and DEPENDENT relation? Ans: (a) AadharNumber, EmployeeID (b) To retrieve the

a) To store each item name along with its price, what relation should be used?Decide appropriate attribute names along with their data type. Each item and its price should be stored only once. What restriction should be used while defining the relation?Ans: We will create new relation BILL to keep bill details as per the

a) Roll no 24 may not be interested in sports. Can a NULL value be assigned to that student’s preferences field? Ans: Yes, a NULL value can be assigned. b) Roll no 17 has given two preferences sports. Which property of relational DBMS is violated here? Can we use any constraint or key in the

The limitation if file systems that can be overcome by a relational DBMS are: Data Redundancy: redundancy means repetition of same data in different tables. Redundancy leads to excess data storage and may cause data inconsistency. Data Inconsistency: When same data is managed differently in different places leads to data inconsistency. Data inconsistency creates unreliable

By storing data in different tables which are logically related, a database management system avoids redundancy in data through a database.

Degree Cardinality Total no of columns(attribute) in table Total no of rows (tuple) in a table Degree of multiple tables are always added Cardinality of multiple tables are always multiplied.