database management system nptel week 3 assignment answers

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications You must be signed in to change notification settings

All 8 weeks answer for the Data base management and storage.

AVIGOYAL20/NPTEL-DBMS-

Folders and files.

Name		Name
1 Commit

Repository files navigation

Nptel-dbms-.

• Amazon Quiz
• Flipkart Quiz
• Play & Win 50,000 Coins
• Privacy Policy

NPTEL DataBase Management System ASSIGNMENT ANSWERS 2021

• by QuizXp Team
• August 1, 2021 September 22, 2021

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

• INTENDED AUDIENCE: ALL UG STUDENTS
• Requirements/Prerequisites:  NIL
• 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:-

Answer:- a,d

Answer:- b,c

DataBase Management System ASSIGNMENT WEEK 7 ANSWERS:-

Answer:- a,c

DataBase Management System ASSIGNMENT WEEK 5 ANSWERS:-

Answer:- ,c

DataBase Management System ASSIGNMENT WEEK 4 ANSWERS:-

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?

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.

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”?

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:

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”?

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.

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?

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

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

DataBase Management System ASSIGNMENT WEEK 2 ANSWERS:-

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

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

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

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

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

Q6. Consider the following CREATE statement

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

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

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

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

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

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?

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:

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.

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

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

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

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.

Data Base Management System Assignment 3 Answers 2023

NPTEL Data Base Management System Assignment 3 Answers: 2023:-  All the Answers provided below to help the students as a reference, You must submit your assignment to your own knowledge.

NPTEL Data Base Management System Week 3 Assignment Answers 2023

1. Consider the relation Payments as follows:

a) UPI b) Cash c) NEFT d) Card

2. Consider the relation Payments as follows:

Which of the TransactionIDs will NOT be present in the output of R1-R2? a) 42 b) 15 c) 14 d) 4

3. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes). Choose the correct Tuple Relational Calculus that represents the following statement: “Display the titles of those videos that are published on You Tube Channels and have more than 50,000 likes.”

4. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes). Choose the correct Domain Relational Calculus that is equivalent to the following SQL Query: SELECT Channel, VideoTitle FROM Content WHERE Dislikes<100; a) {< c,v > |31, d(< c,v, 1,d >€ Content ^ d < 100)} b) {c,v|3c,v, 1, d(< c,v, 1, d >€ Content ^ Dislikes < 100)} c) {< c,v > 3c,v,1,d € Content ^ d < 100} d) {c,v|3 < 1, >€ Content ^ Dislikes < 100}

5. A C program, with embedded SQL query, allows the users to enter a date and an amount to check the transactions that were made on that day. The entered date is stored in the variable Idate and the amount in variable amt. The SQL query returns the TransactionID and Amount of those payments from Payments (Mode, TransactionID, PaymentDate, Amount) whose PaymentDate match with the user’s entered date and the Amount is more than the entered amount. Which of the following SQL queries is correct for the purpose?

a) EXEC SQL DECLARE c CURSOR FOR SELECT TransactionID, Amount FROM Payments WHERE PaymentDate= :Tdate AND Amount>: amt END EXEC b) EXEC SOL DECLARE c CURSOR FOR SELECT * FROM Payments WHERE PaymentDate= Tdate AND Amount>amt END EXEC c) EXEC SOL DECLARE c CURSOR FOR SELECT * FROM Payments WHERE Tdate=PaymentDate AND amt>Amount d) EXEC SQL DECLARE c CURSOR FOR SELECT TransactionID, Amount FROM Payments WHERE : PaymentDate= :Tdate AND : Amount>: amt END EXEC

6. A cloth factory maintains a schema of manufactured Clothes where each clothing item is identified by a tag. The clothes are also associated with corresponding sizes and materials. However, each cloth can be designed by multiple designers. Which of the following schema correctly represents the Clothes entity set? a) Clothes (Tag, Size, Material, Designer) b) Clothes (Tag, Size, Material), Clothes_Designer (Tag, Designer) c) Clothes (Tag, Size, Material), Clothes_Designer (Tag, Designer) d) Clothes (Tag, Size, Material), Clothes Designer (Tag, Designer)

7. Consider the three relational schemas: Stories (Title, Author, Pages, StoryCount) Books (Title, Author, Pages) Educational (Title, Author, Pages, Subject) Which of the Entity Relationship diagrams correspond to the given schemas?

8. Consider the Entity Relationship Diagram:

Which of the following is/are true? a) The participation of Organizer in Org.Conf is partial. b) The participation of Conference in Org-Conf is partial. c) Presenter is a composite attribute of Presentation. d) Presenter is a multivalued attribute of Presentation.

9. Consider the entity relationship diagram.

10. Consider the following instance of organizer.

About Data Base 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. 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. CRITERIA TO GET A CERTIFICATE 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 score = Average assignment score + Exam score YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF YOUR AVERAGE ASSIGNMENT SCORE >=10/25 AND YOUR EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100. You can find Data Base Management System Assignment 3 Answers below.

NPTEL Data Base Management System Assignment 3 Answers 2022

1. Consider the following instance of the relation Gardens (Name, Location, OpensAt, ClosesAt, KnownFor) a) X=Name, Y=Location, M=Location, N=KnownFor b) X=Name, Y=Location, M=Name, N=KnownF or c) X=Name, Y=KnownFor, M=Location, N=KnovnFor d) X=Name, Y=KnownFor, M=Name, N=Location

2. Consider the following instance of the relation Gardens (Name, Location, OpensAt, ClosesAt, KnownFor) Which of the following Names will be produced by R1 R2? a) Treeland b) TreeLand, Bageecha c) Bageecha, FloralParadise d) FloralParadise

Answers will be Uploaded Shortly and it will be Notified on Telegram, So  JOIN NOW

3. A C program, with embedded SQL allows the users to enter their ticket number which is stored in the variables tno. With the help of an embedded SQL query, the program then displays the corresponding travel date and destination from a database with the following schema: TravelReg (TicketNo, Destination, TravelDate, ReservationName). Select the correct Embedded SQL query that should be present in this C program.

4. Consider the following instance of the relation Gardens (Name, Location, OpensAt, ClosesAt, KnownFor)

5. Consider the following Entity Relationship Diagram: Which of the following options is (are) true? a) Participation of Product is total is Prod_del. b) The primary key in the relational schema for Receipt is {Name, ItemName, ProductNo}. c) The primary key in the relational schema for Receipt will be {Name, ItemName, AgentPin}. d) Participation of Product is total in Prod rec.

6. Consider the relation Planets (pname, rank, satellites, diameter) What is the Domain Relational Calculus expression equivalent to the statement Select the names of those Planets uhich have a diameter of more than 50,000 kms”?

👇 For Week 04 Assignment Answers 👇

7. Consider the following scenario: A Natural resource management company keeps a record of different forests, identified by their names. A forest is associated with its location that contains the Country and area in which the forest is present. In each forest, there are different types of trees that are also recorded by the company. Which of the following schema correctly represents the Forest entity set? a) Forest (Name, Location, Trees) b) Forest (Name, Country, Area), Forest.trees (Name, Trees) c) Forest (Name, Trees), Forest Location (Name, Location, Country, Area) d) Forest (Name, Country, Area), Forest.trees (Name, Trees)

8. Consider the following Entity Relationship Diagram: Which of the following is (are) true? a) Participation of Author in Auth.pub is total. b) Participation of Publisher in Auth_pub is total. c) A Book can be written by multiple Authors. d) An Author can be associated with at most one Book.

9. Consider the instance of the relational schema Gallery (PaintingID, Artist, Theme) and Price (PaintingID, Cost): a) 3 b) 4 c) 8 d) 10

10. Consider the instance of the relational schema Gallery (PaintingID, Artist, Theme): Which of the following Relational Algebra expressions produce(s) exactly the same tuples as present in this instance of Gallery? a) IlpaintingID , Artist (Callery) x IIpaintingID, Theme (Callery) b) TIpaintingID , Artist (Callery) x IlArtist, Theme (Callery)) c) IIpaintingID, Theme (Gallery) x IIpaintingID, Theme (Gallery) d) TIpaintingID, Theme , Artist (Callery) « lITheme (Callery)

For More NPTEL Answers:-  CLICK HERE Join Our Telegram:-  CLICK HERE

Leave a Comment Cancel reply

You must be logged in to post a comment.

Please Enable JavaScript in your Browser to Visit this Site.

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. 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. While DBMS’s differ in the details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course examines data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.

--> --> --> --> --> --> --> --> --> --> --> --> --> --> --> --> --> -->

Note: This exam date is subject to change based on seat availability. You can check final exam date on your hall ticket.

Page Visits

Course layout, books and references, instructor bio.

DOWNLOAD APP

SWAYAM SUPPORT

Please choose the SWAYAM National Coordinator for support. * :

Data Base Management System | Week 1

Session: JAN-APR 2024

Course Name: Data Base Management System

Course Link: Click Here

For answers or latest updates join our telegram channel: Click here to join

These are Data Base Management System Week 1 Assignment Answers

Q1. 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? a) 2 b) 3 c) 4 d) 5

Answer: b) 3

Q2. 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? a) (II_Student (SEMESTER2) — II_Student (SEMESTER1)) >< SEMESTER1 b) (II_Student (SEMESTER2) — II_Student (SEMESTER1)) >< SEMESTER2 c) (II_Student (SEMESTER1) — II_Student (SEMESTER2)) >< SEMESTER2 d) (II_Student (SEMESTER1) — II_Student (SEMESTER2)) >< SEMESTER1

Answer: d) (II_Student (SEMESTER1) — II_Student (SEMESTER2)) >< SEMESTER1

Q3. Consider the following instance of the relation Counters(CNo, Item, Price, Category) Identify the valid primary key for the relation Counters(CNo, Item, Price, Category) from the given instance. a) {CNo, Item} b) {Item, Price} c) {Price, Category} d) {CNo, Item, Category}

Answer: b) {Item, Price}

Q4. Consider the following instance of the relation Seating(SNo, Preference, Coach, Name) Identifying the primary key from the given instance, select the tuple that can NOT be inserted to Seating. a) (11, WS, D1, Harsh S.) b) (2, NP, D2, Anukul K.) c) (6, NWS, D2, Raima H.) d) (6, NULL, NULL, NULL)

Answer: b) (2, NP, D2, Anukul K.)

Q5. Consider the following RA: II_track(ocategory=_’Pop’ (Music)) 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: d) Displays all the tracks from Pop Category

Q6. Let R1 ( X ,Y) and R2( A ,B,C) be two relations in a schema. The primary keys are shown underlined. Let C be a foreign key in R2 referring to R2. Suppose, there is no violation of the above referential integrity constraint in the corresponding relation instances r1 and r2. Which one of the following relational algebra expressions would necessarily produce an empty relation? a) II_X(r1) —II_C(r2) b) II_C(r2) —II_X(r1) c) II_X(r1><r2) d) II_C(r1><r2)

Answer: b) II_C(r2) —II_X(r1)

Q7. 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? a) Alternate key b) Composite key c) Compound key d) Surrogate key

Answer: c) Compound key

Q8. Consider the following table: Identify the correct operation(s) which produces the following output from the above relation. a) II_(Address=”Kolkata’) ^ _(Age>25)(StudentDetails) b) II_(Address=”Kolkata’) v _(Age>25)(StudentDetails) c) o-_(Address=”Kolkata’) ^ _(Age>25)(StudentDetails) d) o-_(Address=”Kolkata’) v _(Age>25)(StudentDetails)

Answer: d) o-_(Address=”Kolkata’) v _(Age>25)(StudentDetails)

Q9) Consider the following tables: Identify the correct operation(s) which will be produce the following output from the above two relations. a) (Student x Department) b) II_(StudName, Student.DeptName, Fees) (o-_Student.DeptName = Department.DeptName) (Student x Department) c) o-_(StudName, Student.DeptName, Fees)(Student >< Department) d) (Student >< Department)

Answer: b), d) b) II_(StudName, Student.DeptName, Fees) (o-_Student.DeptName = Department.DeptName) (Student x Department) d) (Student >< Department)

Q10. Which of the following can be a candidate key for the following instance? a) {StudName} b) {DeptName} c) {StudName, DeptName} d) {Address, Age}

Answer: c) {StudName, DeptName}

More Solutions of Data Base Management System: Click Here

More NPTEL Solutions: Click Here

Session: JAN-APR 2023

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. a) paper_id b) paper_id, corresponding Author c) conference_id, corresponding_Author d) paper_id, conference_id

Answer: a) paper_id

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}

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))

Q7) Consider the following tables: 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: Identify the correct operation(s) which will be produce the following output from the above relations. 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: Identify the correct operation(s) which will be produce the following output from the above two relations. 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)

Q10) Which of the following can be a candidate key for the following instance? a) {StateName} b) {#State Universities} c) {#Faculties} d) {StateName, #Central Universities, #State Universities}

Answer: a) {StateName}

Course Status :	Completed
Course Type :	Core
Duration :	8 weeks
Category :
Credit Points :	2
Undergraduate
Start Date :	29 Jul 2019
End Date :	20 Sep 2019
Exam Date :	29 Sep 2019 IST