NPTEL DataBase Management System ASSIGNMENT ANSWERS 2021

DataBase Management System

NPTEL DataBase Management System Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet-based, financial, social, administrative, and so on.

NPTEL Database Management System is a MOOC course offered by IIT Madras on the NPTEL platform. Through this DBMS course, 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. The course is developed by Prof. Partha Pratim Das received his BTech, MTech and PhD degrees in 1984, 1985 and 1988 respectively from IIT Kharagpur. He served as a faculty in Department of Computer Science and Engineering, IIT Kharagpur

  1. INTENDED AUDIENCE: ALL UG STUDENTS
  2. Requirements/Prerequisites: NIL
  3. INDUSTRY SUPPORT: All compaines or industry

CRITERIA TO GET A CERTIFICATE

Students have to score Average assignment score = 25% of the average of the best 6 assignments out of the total 8 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100 Final scores = Average assignment score + Exam score

Students will be eligible for CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If any of the 2 criteria are not met, the student will not get the certificate even if the Final score >= 40/100.

DataBase Management System ASSIGNMENT WEEK 8 ANSWERS:-

Q1.

Answer:- a,d

Q2.

Answer:- b

Q3.

Answer:- b

Q4.

Answer:- c

Q5.

Answer:- d

Q6.

Answer:- c

Q7.

Answer:- d

Q8.

Answer:- c

Q9.

Answer:- b,c

Q10.

Answer:- a,d

DataBase Management System ASSIGNMENT WEEK 7 ANSWERS:-

Q1.

Answer:- b

Q2.

Answer:- a,c

Q3.

Answer:- a

Q4.

Answer:- a

Q5.

Answer:- a,d

Q6.

Answer:- b

Q7.

Answer:- a,d

Q8.

Answer:- d

Q9.

Answer:- c

Q10.

Answer:- d

DataBase Management System ASSIGNMENT WEEK 5 ANSWERS:-

Q1.

Answer:- d

Q2.

Answer:- ,c

Q3.

Answer:- a

Q4.

Answer:- a

Q5.

Answer:- b

Q6.

Answer:- c

Q7.

Answer:-a

Q8.

Answer:- d

Q9.

Answer:- c

Q10.

Answer:- b

DataBase Management System ASSIGNMENT WEEK 4 ANSWERS:-

Q1.

Answer:- c

Q2.

Answer:- d

Q3.

Answer:- a

Q4.

Answer:- d

Q5.

Answer:- b

Q6.

Answer:- a

Q7.

Answer:- d

Q8.

Answer:- c

Q9.

Answer:- a,d

Q10.

Answer:- b

DataBase Management System ASSIGNMENT WEEK 3 ANSWERS:-

Q1. Consider the following instance of the relation MovieBooking (Movie Name, TheatrID, HallNo, Glasses 3D, MLanguage, Showtime ID, ShowDay)

Answer:- c,d

Q2. Consider the following two Relational Algebra expressions:
R1: IlMovieName, HallNo (MovieBooking)
R2: IIM2. HallNo (OM1.Theatr ID-M2. TheatrIDAM1.MLanguage/M2.MLanguage (PM1 (MovieBooking) x PM2 (MovieBooking)))
What is the output of R1 + R2?

Answer:- c

Q3. A C program, with embedded SQL allows the users to enter their username and password which are stored in the variables uname and pwd respectively. With the help of an embedded SQL query, the program then selects the user’s Rank and Marks from a database with the following schema: ChckRes (User, Passwd, Department, Year, Rank, Marks). Select the correct Embedded SQL query that should be present in this C program.

Answer:- d

quizxp telegram

Q4. Consider the relation TicTac (Player, Game, Mark, PositionFilled) What is the Tuple Relational Calculus expression equivalent to the statement “Select those games where Central position has been filled”?

Answer:- a

Note:- WE NEVER PROMOTE COPYING AND 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 to reference, so we urge do your assignment on your own.

Q5. Consider the following Entity Relationship Diagram:

Answer:- c,d

Q6. Consider the relation TicTac (Player, Game, Mark, PositionFilled) What is the Domain Relational Calculus equivalent to the statement “Select those players who are playing with Cross mark”?

Answer:- b

Q7. Choose the correct Entity Relationship Diagram representing the following scenario: In a game club, membership cards are issued to some of the visitors. A visitor can have only one membership card and that card cannot be shared with any other member. A membership card can be identified with its membership number. The card also has member type, validity and access zone that are available to the member. The access zone is composed of zone code and zone games. A visitor of this game club is identified by the visitor’s ID and name together. A visitor can have multiple email IDs which are also registered.

Answer:- b

Q8. If n [Payment] is the set of attributes present in the relational schema of Payment, n[In Cash] is the set of attributes present in the relational schema of In Cash and n[In_Cheque] is the set of attributes present in the relational schema of In Cheque, which of the following options can be true?

Answer:- a,d

Q9. How many tuples will be generated by the Relational Algebra expression equivalent to the following Domain Relational Calculus?

Answer:- a

Q10. Which of the following Relational Algebra expression produces exactly the same tuples as present in this instance of Presentation?

Answer:- c

DataBase Management System ASSIGNMENT WEEK 2 ANSWERS:-

Q1. Consider the following instance of the relation weather (day, year, month, temperature, city)

Answer:- b

Q2. Consider the following table Customer: Identify the correct SQL statement from the following options for creating the table Customer.

Answer:- d

quizxp telegram

Q3. Consider the following instance of the relation weather (day, year, month, temperature, city)

Answer:- a,c

Q4. Consider the following instance of the relation RankHolder (UnivID, Dept, Name, Roll, Rank)

Answer:- d

Q5. Consider the following instance of the relation RankHolder (UnivID, Dept, Name, Roll, Rank)

Answer:- c

Q6. Consider the following CREATE statement

Answer:- d

Q7. Consider the following two schema: Product (Product_id, Pname, Uprice), Department (Dno, Dname, Product_id, year). If we execute the following SQL statement:

Answer:- b

Q8. Consider the following instance of Student Details (StudName, Marks, Permanent Address, Correspondence Address) relation.

Answer:- b,d

Q9. Consider the following instance of Student Details (StudName, Marks, Permanent Address, Correspondence Address) relation.Student Details

Answer:- a

Q10. Consider the given relational schema: Student Details (Stud ID, StudName, Marks, Permanent Address, Correspondence Address).

Answer:- c

DataBase Management System ASSIGNMENT WEEK 1 ANSWERS:-

Q1. What is Physical Data Independence?

Answer:- D JOIN US ON TELEGRAM WE UPDATE ANSWERS AND NOTIFY THERE

quizxp telegram

Q2. what is a collection of data called that consists of roll number ,name, class and phone number of a student?

Answer:- B

Q3. Consider the relational schema Virtual Conf (Conf ID, Participants, Admin, Day, Subject). Which of the following is not a valid instance of VirtualConf?

Answer:- D JOIN US ON TELEGRAM ONCE WE UPDATE ANSWERS WILL NOTIFY THERE

Q4. Consider the following instance: Based on this instance of Storage, if RoomNo is one of the attributes of the primary key (composite in nature), which of the following attribute(s) complete the primary key?

Answer:- D

Q5. Consider the following instances: Which of the following tuples will not be present in bag1 x bag2?

Answer:- B,C

Q6.  Suppose there are two relations R and S as follows: After performing a relational expression involving ‘X’ on R and S, we get the following result:

Answer:- B

Q7.  Choose the incorrect statement(s) related to database languages.

Answer:- A,B,C,D

NOTE:- IF THERE IS ANY CHANGE IN ANSWERS OF NPTEL Database management system assignment answers WILL UPDATE BEFORE LAST DATE AND NOTIFY ON TELEGRAM OR WHATSAPP. SO KINDLY JOIN US, CLICK ON BELOW IMAGE AND JOIN US.

quizxp telegram

Q8. Consider the following table: Identify the correct operation(s) which produces the following output from the above relation.

Answer:- B

Q9. Consider the following table: Identify the correct operation(s) which produces the following output from the above relation.

Answer:- D

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

Answer:- C

quizxp telegram

Also check :- Internship oppurtinites

Note:- 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 you assignment own your own.