Master in Data Science (SMS, TU) Database Management Systems Question Paper 2078 (Set First Assessment 2078, p18 (header prints 'MDS 503' but subject is Data Base Management System = MDS 505)) Nepal
This is the official Master in Data Science (SMS, TU) Database Management Systems question paper for 2078 Set First Assessment 2078, p18 (header prints 'MDS 503' but subject is Data Base Management System = MDS 505), as set in the First Assessment examination. It carries 45 full marks and a time allowance of 120 minutes, across 9 questions. On Kekkei you can attempt this Database Management Systems 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 Master in Data Science (SMS, TU) Database Management Systems exam or solving previous years' question papers, this 2078 paper is a great way to practise under real exam conditions.
| Level | Master in Data Science (SMS, TU) |
|---|---|
| Subject | Database Management Systems |
| Year | 2078 BS |
| Exam session | First Assessment · Set First Assessment 2078, p18 (header prints 'MDS 503' but subject is Data Base Management System = MDS 505) |
| Full marks | 45 |
| Time allowed | 120 minutes |
| Questions | 9, all with step-by-step solutions |
Group A
What is weak entity and weak relation? Explain with an example.
Differentiate between total participation and partial participation.
Why Normalization is carried out?
Differentiate between logical design and physical design.
Explain different types of cardinalities.
Group B
Justify why database management system is efficient than file management system.
Find Attribute Closure of the following relation
| STU_ID | NAME | Age | FACULTY | ADDRESS |
|---|---|---|---|---|
| 1 | Bikash | 20 | Computer | Kathmandu |
| 2 | Anju | 21 | Electronics | Patan |
| 3 | kiran | 22 | computer | Bhaktapur |
| 4 | Anju | 23 | Computer | Patan |
Convert the given relation to 3 NF.
| ID | ROLL | HOSTEL ROOM | FACULTY | PRICE |
|---|---|---|---|---|
| 1 | 1 | 112 | Computer | 1000 |
| 2 | 1 | 113 | Electronics | 2000 |
| 3 | 2 | 112 | Data Science | 1000 |
| 1 | 3 | 114 | Data Science | 5000 |
OR
Explain different types of Integrity constraints.
Draw ER diagram for online examination system. Make necessary assumptions.
OR
Assume attributes of CUSTOMER, ORDER, PRODUCT and Employee with required primary key. Convert the ER diagram to relational model.
(ER diagram shown: CUSTOMER --Places-- ORDER --Lists-- PRODUCT --Assembles-- EMPLOYEE)
Frequently asked questions
- Where can I find the Master in Data Science (SMS, TU) Database Management Systems question paper 2078?
- The full Master in Data Science (SMS, TU) Database Management Systems 2078 (First Assessment) question paper is available free on Kekkei. You can read every question online and attempt the paper under timed exam conditions.
- Does the Database Management Systems 2078 paper come with solutions?
- Yes. Every question on this Database Management Systems past paper includes a step-by-step solution, plus instant AI feedback when you attempt it on Kekkei.
- How many marks is the Master in Data Science (SMS, TU) Database Management Systems 2078 paper?
- The Master in Data Science (SMS, TU) Database Management Systems 2078 paper carries 45 full marks and is meant to be completed in 120 minutes, across 9 questions.
- Is practising this Database Management Systems past paper free?
- Yes — reading and attempting this Database Management Systems past paper on Kekkei is completely free.