BSc CSIT (TU) Science Database Management System (BSc CSIT, CSC260) Question Paper 2080
This is the official BSc CSIT (TU) (Science stream) Database Management System (BSc CSIT, CSC260) question paper for 2080, as set in the regular annual examination. It carries 60 full marks and a time allowance of 180 minutes, across 12 questions. On Kekkei you can attempt this Database Management System (BSc CSIT, CSC260) past paper online with a timer, get instant AI feedback and step-by-step solutions, and track the topics where you lose marks — completely free. Whether you are revising for your BSc CSIT (TU) Database Management System (BSc CSIT, CSC260) exam or solving previous years' question papers, this 2080 paper is a great way to practise under real exam conditions.
Section A: Long Answer Questions
Attempt any TWO questions.
Explain the Entity-Relationship (ER) model. Draw an ER diagram for a university database and explain different types of entities, attributes, and relationships.
How are the different types of entities and relationships of an ER diagram reduced into tables? Explain with examples for each type of entity and relationship.
What is normalization? Explain 1NF, 2NF, and 3NF with suitable examples, and discuss why normalization is necessary.
Section B: Short Answer Questions
Attempt any EIGHT questions.
What is data redundancy? How does normalization reduce it?
Explain the multivalued dependency and 4NF in brief.
What is a join? Explain inner join and outer join.
Explain the difference between a strong and a weak entity.
Differentiate between a file system and a DBMS.
Explain the roles of a Database Administrator (DBA).
What are the different types of database users?
Differentiate between primary key, candidate key, and foreign key.
Explain the concept of a weak entity set with an example.