Data Base Management System | Week 1

Course Name: Data Base Management System

Course Link: Click Here

These are Data Base Management System Week 1 Assignment Answers


Q1) Which level of abstraction describes types of data that are stored in the Database?
a) Physical level
b) Logical level
c) View level
d) Abstraction level

Answer: a) Physical level


Q2) Identify the valid primary key for the relation paper_info from the given instance.

image 29

a) paper_id
b) paper_id, corresponding Author
c) conference_id, corresponding_Author
d) paper_id, conference_id

Answer: a) paper_id


These are Data Base Management System Week 1 Assignment Answers


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) Project (pCode, pName) is an instance of a relation schema.


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).
a) {VID}
b) {Speed}
c) {Color}
d) {Speed, Color}

Answer: a) {VID}


These are Data Base Management System Week 1 Assignment Answers


Q5) Consider the following relations:
Book (ISBN, Title, Pages)
BookGenre (ISBN, Genre)
What does the following relational algebra expression represent?
IIISBN((Pages>100 Book) (Genre-Fiction/BookGenre))
a) Find the ISBN of all Book with more than 100 Pages.
b) Find the ISBN of all Book with more than 100 Pages or are of Genre ‘Fiction’.
c) Find the ISBN of all Book with more than 100 Pages but are not of Genre ‘Fiction’.
d) Find the ISBN of all Book with more than 100 Pages and are of Genre ‘Fiction’.

Answer: d) Find the ISBN of all Book with more than 100 Pages and are of Genre ‘Fiction’.


Q6) Consider the following relational schema:
ImageCode (ImageID, Name)
ImageBook (BookID, Image ID, Page)
What will be the Relational Algebra equivalent to the following statement?
“Find the names of all Images on Page 100.”
a) Name (ImageCode Page=100 (ImageBook)) X
b) Name (Ipage=100 (ImageCode) ImageBook)
c) IIName(IIpage=100 (ImageCode) ▷ ImageBook)
d) IIName (Image Code Page=100 (ImageBook))

Answer: d) IIName (Image Code Page=100 (ImageBook))


These are Data Base Management System Week 1 Assignment Answers


Q7) Consider the following tables:

image 30

Which of the following operations will return S1 itself?
a) S2-(S2-S1)
b) S1-(S2-S1)
c) S1-(S1-S2)
d) S2-(S1-S2)

Answer: c) S1-(S1-S2)


Q8) Consider the following tables:

image 31

Identify the correct operation(s) which will be produce the following output from the above relations.

image 32

a) (#Faculties>=20000) (UniversitiesDetails)
b) (#Faculties>20000) (Universities Details)
c) IIStateName, #State Universities, #Faculties (#Faculties>=20000) (Universities Details)
d) IlStateName, #State Universities, #Faculties (#Faculties> 20000) (UniversitiesDetails)

Answer: c) IIStateName, #State Universities, #Faculties (#Faculties>=20000) (Universities Details)


Q9) Consider the following tables:

image 33
image 34

Identify the correct operation(s) which will be produce the following output from the above two relations.

image 35

a) Details Details2
b) Details – Details₁
c) (Details₁ U Details ₂) n (Details₁ Details₂)
d) (Details1 Details2) U (Details2 – Details 1)

Answer: d) (Details1 Details2) U (Details2 – Details 1)


These are Data Base Management System Week 1 Assignment Answers


Q10) Which of the following can be a candidate key for the following instance?

image 36

a) {StateName}
b) {#State Universities}
c) {#Faculties}
d) {StateName, #Central Universities, #State Universities}

Answer: a) {StateName}



These are Data Base Management System Week 1 Assignment Answers

More Solutions of Data Base Management System: Click Here

More NPTEL Solutions: https://progiez.com/answers/nptel/


These are Data Base Management System Week 1 Assignment Answers
These are Data Base Management System Week 1 Assignment Answers

This content is uploaded for study, general information, and reference purpose only.