Hello learners In this article we are going to discuss NPTEL Data Base Management System Assignment 1 Answers. All the Answers provided below to help the students as a reference, You must submit your assignment with your own knowledge and use this article as reference only.
About the course:-
Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain.
NPTEL Data Base Management System Assignment 1 Answers 2024:
1. A relation R has 2 candidate keys with 1 attribute each. There are 6 possible super keys of R.
What is the total number of attributes in R?
Answer :- Will update answers soon and update on our telegram channel so Join Click Here
2. Consider the following instances of the relation:
SEMESTER1 (Student, Marks) and SEMESTER2(Student, Marks)
Which of the following Relational Algebra produces the Name and SEMESTER1 Marks of only
those Students who did not appear in SEMESTER2?
Answer :-
3. Consider the following instance of the relation Counters(CNo, Item, Price, Category)
[CNo [ Twom | Pricc [ Catogory |
Identify the valid primary key for the relation Counters(CNo, Item, Price, Category) from
the given instance.
Answer :-
4. Consider the following instance of the relation Seating(SNo, Preference, Coach, Name)
[SNo [ Proference | Coach | Name |
1 [ WS | DI Hashs |
2 [ NP | DI [AmkiK
3 | WS | DI | Hashs |
| 4 [ WS | D2 | RaimaH |
[ 5 [ NWS [ D2 [ RaimaH |
Identifying the primary key from the given instance, select the tuple that can NOT be inserted
to Seating ?
Answer :-
5. Consider the following RA:
irack(Ccategory=:Pop (M usic))
‘Which of the following statements is true?
a) Displays the details of all Music from Pop Category
b) Displays the details of at least one Music from Pop Category
c) Displays at most one track from Pop Category
d) Displays all the tracks from Pop Category
Answer :-
6. Let R4 (X,Y) and Rp(A,B,C) be two relations in a schema. The primary keys are shown underlined.
Let C be a foreign key in Ry referring to Ry. Suppose, there is no violation of the above
referential integrity constraint in the corresponding relation instances ry and ro.
‘Which one of the following relational algebra expressions would necessarily produce an empty
relation?
Answer :-
7. Consider the following relations:
Parts(PartID, Name, Price ).
Supplier (SupID, Name, Location).
Order (SupID, PartID, Quantity) .
If SupID and PartID together are used to uniquely identify a row in Order table, which
of the following option is correct for describing such key in Order table?
Answer :-
8. Consider the following table:
[ StudName | Depthame | Address | Aes |
Ayush | CSE | Kolkata | 28 |
Priya | CSE | Wyderabad | 24 |
Amkush | T | Kolkata | 30 |
Rumki | T | Wyderabad | 25 |
[ Sujic | ECE | Bangalore | 24|
[Sayan | TEE | Wumbai | 28|
Identify the correct operation(s) which produces the following output from the above relation.
[ StudNane | Depthane | Address | Age |
Ayush | CSE | Kolkata| 26 |
[ukush | TT [ Kolkata | 30 |
[Sayen | TEE | Wunbai | 26 |
Answer :-
9. Consider the following tables:
Identify the correct operation(s) which will produce the following output from the above two
relations.
Answer :-
10. Which of the following can be a candidate key for the following instance?
hyush | CsE | Kolkata | 26
[Priya | CSE | Fydorabad | 26 |
[Ankush | IT | Kolkata | 30 ]
Ramki | T | fyderabed | 2 |
[Sujic | ECE | Bangalors | 24 |
[Sujic | TEE | Wumbai | 76 |
Answer:-
