NPTEL Data Base Management System Assignment 1 Answers 2023? This article will help you with the answer to the National Programme on Technology Enhanced Learning (NPTEL) Course “ Data Base Management System Assignment 1 “
Below you can find the answers for Data Base Management System Assignment 1 Answers 2023
NPTEL Data Base Management System Assignment 1 Answers 2023:-
Q1. Which level of abstraction describes types of data that are stored in the Database?
Answer:- b
For week 2 Answers:- Click Here
Q2. Identify the valid primary key for the relation paper_info from the given instance.
Answer:- a
Q3. Identify the correct statement/s.
a) Project(pCode, pName) is an instance of a relation schema.
b) Project(pCode, pName) is an example of a physical schema.
c) (2245, HardFort) is an instance of a relation schema.
d) (2245, HardFort) is an example of a logical schema.
Answer:- a
Q4. Consider a relation Vehicle(VID, Model, Speed, Color) where the superkeys are as follows:
{VID}, {VID, Model}, {Speed, Color}, {Speed, Color, Model}.
Select the possible candidate key(s).
Answer:- a
Next Week Answers: Assignment 02
Q5. Consider the following relations:
Book(ISBN,Title,Pages)
BookGenre (ISBN, Genre)
‘What does the following relational algebra expression represent?
HISBII((”’Pages> 100Bo0k) M (0eanre—:Fiction’BOOKGeNTe))
Answer:- d
Q6.Consider the following relational schema:
ImageCode (ImageID, Name)
ImageBook (BookID, ImageID, Page)
‘What will be the Relational Algebra equivalent to the following statement?
“Find the names of all Images on Page 100.”
Answer:- d
If there are any changes in answers will notify you on telegram so you can get 100% score, So Join
Q7.‘Which of the following operations will return S1 itself?
Answer:- b
Q8. Identify the correct operation(s) which produces the following output from the above relation.
Answer:- c
Q9. Identify the correct operation(s) which will be produce the following output from the above
two relatioms.
Answer:- d
Q10. ‘Which of the following can be a candidate key for the following instance?
Answer:- a
For other courses answers:- Visit
For Internship and job updates:- Visit
Disclaimer: We do not claim 100% surety of answers, these answers are based on our sole knowledge, and by posting these answers we are just trying to help students, so we urge do your assignment on your own.
if you have any suggestions then comment below or contact us at [email protected]
If you found this article Interesting and helpful, don’t forget to share it with your friends to get this information.
