dbms week 2 assignment

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

NPTEL Data Base Management System Assignment 2 Answers 2023

• by QuizXp Team
• February 8, 2023 February 8, 2023

NPTEL Data Base Management System Assignment 2 Answers 2023? This article will help you with the answer to the  Nation al Programme on Technology Enhanced Learning  ( NPTEL )  Course “ Data Base Management System Assignment 2 “

Below you can find the answers for Data Base Management System Assignment 2 Answers 2023

NPTEL Data Base Management System Assignment 2 Answers 2023:-

Q.1. Table ACCOUNT is created using the following SQL query :

CREATE TABLE ACCOUNT(AcNo INTEGER, NAME VARCHAR (20), PRIMARY KEY (AcNo), CHECK (NAME LIKE ‘%Y’)); Which of the following SQL command(s) will result in an error?

• a) INSERT INTO ACCOUNT VALUES (1, ‘AKSHAY’);
• b) INSERT INTO ACCOUNT VALUES (NULL, ‘BIJAY’);
• c) INSERT INTO ACCOUNT VALUES (3, ‘ABHAY’);
• d) INSERT INTO ACCOUNT VALUES (4, ‘ANANDI’);

For week 1 Answers:- Click Here

Q.2. A designer maintains the following relations:

• StyleName (Element, Style)

• PrintStyle (Element, Color)

Which of the following option(s) is/are correct to find the names of the Element that has Style without having any color? Primary keys are underlined in the schemas.

Q.3. Consider two relations Table1 (A1,A2) and Table2 (A1, A3) as following :

Suppose Table3 (A1, A2, A3) is the output of natural full outer join of Table1 and Table2. Which of the following statement(s) is/are correct?

• a) Table3 does not contain (5, 7, null) and (2, 3, 7)
• b) Table3 contains (5, 7, 4), (3, null, 7) and (2, 3, null)
• c) Table3 contains (5, 7, 4) but not (2, 3, null) and (3, null, 7)
• d) Table3 contains (2, 3, 7) and (5, 7, null)

Answer:- A,c

Next Week Answers: Assignment 03

Q.4. A designer maintains the following instances:

What is a possible output if the following SQL Query is executed? SELECT COUNT(LOC) FROM Project, Module GROUP BY LOC;

Q.5. Consider the following instance:

What is the output of the following SQL statement? select distinct Experiment Location from Experiment where Participant Count in( select ParticipantCount from Experiment where Experiment Location=’Lab2′ );

• a) Lab2, Lab7, Lab5
• b) Lab1, Lab7, Lab5
• c) Lab1, Lab2, Lab5
• d) Lab1, Lab2, Lab7

Q.6. Given the schema (primary key is underlined) budget (month, expense) describe the result obtained by the following query. SELECT MAX(expense) AS exp FROM budget WHERE expense < (SELECT MAX (expense) FROM budget);

• a) Finds the highest expense from budget.
• b) Finds second highest expense from budget.
• c) Finds all expenses from budget that are less than the highest expense.
• d) Finds all expenses from budget that are equal to the highest expense.

Q.7. Consider the following instance:

Which of the following output (s) is (are) displayed by the following SQL query? select NAME from Student where NAME like ‘%A%’ AND NAME NOT like ‘%Rathod’;

• a) Abhay Singh, Roshan Singh
• b) Abhay Singh, Roshan Singh, Smriti
• c) Smriti, Akshay Rathod
• d) Arijit Ray, Abhay Singh, Roshan Singh

Q.8. Consider the following instance of Universities Details (StateName, #Central Universities, #State Universities, #Faculties) relation.

Identify the correct statement(s) to get the following output :

• a) SELECT * FROM UniversitiesDetails WHERE #Faculties>=20000;
• b) SELECT StateName, #State Universities, #Faculties FROM Universities Details WHERE #Faculties>=20000;
• c) SELECT StateName, #State Universities, #Faculties FROM UniversitiesDetails WHERE #Faculties>=20000 AND #Central Universities=1;
• d) SELECT StateName, #State Universities, #Faculties FROM UniversitiesDetails WHERE #Faculties>=20000 OR #Central Universities=1;

Q.9. Consider the following instance of Universities Details (StateName, #Central Universities, #State Universities, #Faculties) relation.

Q.10. Consider the following instance of UniversitiesDetails (StateName, #Central Universities, #State Universities, #Faculties) relation.

Answer: B C

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.

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

This repository contains solutions to the weekly assignments (2 & 3) of the Database Management Systems (DBMS) course offered by the Indian Institute of Technology Madras (IITM) as part of the Diploma in Programming program. Additionally, it also contains past OPPE solutions for the course.

NebulaTris/DBMS_IITM

Name already in use.

Use Git or checkout with SVN using the web URL.

Work fast with our official CLI. Learn more about the CLI .

• Open with GitHub Desktop
• Download ZIP

Sign In Required

Please sign in to use Codespaces.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Dbms_iitm ✨, course overview.

The DBMS course covers the fundamental concepts of database management systems, including the relational data model, SQL, transaction management, concurrency control, and database design.

Folder Structure

The repository is structured as follows:

How to Use this Repository

• Clone the repository
• The Practice.md files contain practice queries for each week, while the Graded.md files contain graded queries.
• The OPPE practice questions for Week 7 are stored in separate files named Ques1.md through Ques6.md.
• The OPPE Python-PostgreSQL questions are stored in separate files named Q1.md and Q2.md.
• To use this repository, navigate to the desired folder and open the relevant markdown file in a text editor or browser.
• Use the solutions as a reference to check your own work and to learn more about the concepts covered in the course.
• The solutions provided in this repository are meant to be used as a reference only. It is recommended that you try to solve the assignments on your own before referring to the solutions.
• The solutions provided may not be the most optimal or efficient solutions. They are intended to serve as a starting point for your own work.
• This repository is not affiliated with the Indian Institute of Technology Madras or the Diploma in Programming program. The solutions provided are the work of the repository owner and contributors.

Contributing

Contributions to this repository are welcome. If you find any errors or would like to add more queries, feel free to create a pull request. Please ensure that your queries are organized according to the folder structure above.

Meme Time 😎

This repository is licensed under the MIT License. See the LICENSE file for more details

• Markdown 100.0%

Data Base Management System | NPTEL 2022 | Week 2 Assignment Solutions

This set of MCQ(multiple choice questions) focuses on the  Data Base Management System NPTEL 2022 Week 2 Assignment Solutions .

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.

Course layout (Answers link)

Answers COMING SOON! Kindly Wait!

Week 0: Assignment answers Week 1:  Course Overview. Introduction to RDBMS Week 2: Structured Query Language (SQL)  Week 3: Relational Algebra. Entity-Relationship Model   Week 4: Relational Database Design Week 5:  Application Development. Case Studies. Storage and File Structure   Week 6: Indexing and Hashing. Query Processing   Week 7:  Query Optimization. Transactions (Serializability and Recoverability) Week 8:  Concurrency Control. Recovery Systems. Course Summarization.

NOTE:  You can check your answer immediately by clicking show answer button. Data Base Management System NPTEL 2022 Week 2 Assignment Solution” contains 10 questions.

Now, start attempting the quiz.

Data Base Management System NPTEL 2022 Week 2 Assignment Solutions

Q1. Consider the following instance of the relation PAPER(ID, TYPE, AREA, CITATION)

Which of the following values will be present in all the tuples selected by the following query: SELECT ‘CITATION’ FROM PAPER WHERE CITATION>200

a) 567 b) CITATION c) 43 d) 167

Answer: b) CITATION

Q2. Consider the following instance of the relation PAPER(ID, TYPE, AREA, CITATION)

Select the correct query that displays the following output:

a) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “% %” b) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “%” c) SELECT ID-73 AS ID FROM PAPER WHERE AREA LIKE “%_%” d) SELECT ID-73 AS ID FROM PAPER WHERE AREA LIKE “%%”

Answer: a) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “% %”

Q3. Consider the following instance of the relation MAINTENANCE(WORK, DAYS, CHARGE, TEAM)

How many tuples will be returned by the following query: SELECT AVG(CHARGE) FROM MAINTENANCE GROUP BY DAYS

a) 1 b) 2 c) 3 d) 4

Answer: c) 3

Q4. Consider the following instance of the relation MAINTENANCE (WORK, DAYS, CHARGE, TEAM).

Which of the following queries will produce the following output (ordered):

a) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM b) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM DESC c) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS, TEAM d) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS, TEAM DESC

Answer: a) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM

Q5. Consider the following schema. Primary keys are underlined. Employees( E_name , E_street, E_city) BankAccount( Ac_number , Branch_name, Balance) AccountUser( E_name , Ac_number ) Which is the correct SQL command to create the table AccountUser having two foreign keys E_name and Ac_number

a) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name, Ac_number), FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); b) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name), FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); c) CREATE TABLE AccountUser { E_name VARCHAR(20) PRIMARY KEY, Ac_number NUMERIC(12, 2) PRIMARY KEY, FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); d) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name, Ac_number), FOREIGN KEY Employees(E_name), FOREIGN KEY BankAccount(Ac_number));

Data Base Management System NPTEL Week 2 Assignment Solutions

Q6. Identify the correct SQL command(s) to create a new record for the Faculty table as given below. Primary key is underlined in the schema.

a) INSERT INTO FACULTY VALUES(‘Charline B’, ‘English’, ‘M.A.’); b) INSERT INTO FACULTY VALUE(”Charline B”, ”English”, ”M.A.”); c) INSERT INTO FACULTY VALUE(‘Charline B’, ‘English’, ‘M.A.’); d) INSERT INTO FACULTY (Faculty_name, Department, Degree) VALUES(‘Charline B’, ‘English’, ‘M.A.’);

Answer: a), d)

Q7. A role Admin has the privilege of select, insert, update and delete on all tables of database. A new role Users is created and the following statement is executed. grant Admin to Users; Which rights will Users inherit?

a) Only select b) Only select and delete c) Only select, and update but not delete d) All rights – select, insert, delete, and update

Answer: d) All rights – select, insert, delete, and update

Q8. Consider the following instance of EmployeeDetails(EmpName, Branch, Address, Salary) relation.

Identify the correct statement(s) to get the following output:

a) SELECT * FROM EmployeeDetails WHERE Branch=Address OR Salary>=15000; b) SELECT * FROM EmployeeDetails WHERE Branch=Address AND Salary>=15000; c) (SELECT * FROM EmployeeDetails WHERE Branch=Address) UNION (SELECT * FROM EmployeeDetails WHERE Salary>=15000); d) (SELECT * FROM EmployeeDetails WHERE Branch=Address) INTERSECT (SELECT * FROM EmployeeDetails WHERE Salary>=15000);

Answer: a), c)

Q9. Consider the following instance of EmployeeDetails(EmpName, Branch, Address, Salary) relation.

Identify the correct SQL command that creates a view as EmployeeSalaryDetails in which columns EmpName and Salary for the tuples where the second character of EmpName is ‘r’ and the Salary is atleast 15000.

a) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) ON SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘%r%’ AND Salary>=15000; b) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) ON SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>15000; c) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) AS SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>=15000; d) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) AS SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>15000;

Q10. Consider the given relational schema: EmployeeDetails(EmpName, Branch, Address, Salary) Identify the correct statement to find the EmpName, Branch and Salary of all tuples in which Salary is greater than or equal to the average Salary of all employees or Salary is between 15000 and 20000 including 15000 and 20000.

a) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary LIKE(15000, 20000); b) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary IN(15000, 20000); c) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary AS(15000, 20000); d) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary BETWEEN 15000 AND 20000;

<< Prev- Data Base Management System Week 1 Assignment Solutions

>> Next- Data Base Management System Week 3 Assignment Solutions

NPTEL answers: Problem solving through programming in C

NPTEL answers: Principles of Management

Programming in Java NPTEL week 1 quiz answers

NPTEL – Python for Data Science assignment solutions

Nptel – Deep Learning assignment solutions

The above question set contains all the correct answers. But in any case, you find any typographical, grammatical or any other error in our site then kindly  inform us . Don’t forget to provide the appropriate URL along with error description. So that we can easily correct it.

Thanks in advance.

For discussion about any question, join the below comment section. And get the solution of your query. Also, try to share your thoughts about the topics covered in this particular quiz.

Related Posts

Operating system fundamentals | nptel | week 0 assignment 0 solution, nptel operating system fundamentals week 1 assignment solutions, nptel operating system fundamentals week 10 answers, nptel operating system fundamentals week 2 assignment solutions, nptel operating system fundamentals week 3 assignment solutions, nptel operating system fundamentals week 4 assignment solutions, leave a comment cancel reply.

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

(DBMS) NPTEL Data Base Management System Week 4 Assignment Answers 2023

NPTEL Data Base Management System Week 4 Assignment Solutions

NPTEL Data Base Management System Week 4 Assignment Answers 2023

1. Consider the relational schema OfficeList (Sector, C o mpany, Building, Floor, Employees)with the following Functional Dependency set: {Sector, Company} -> Building, Floor} {Company, B u ilding} – {Employees, Sector} Building > Floor Which attribute is present in all the composite candi d ate kevs of OfficeList? a) Sector b) Com p any c) Building d) Floor

2. Consider the relational schema: DeviceLogs (Device, OperatingSystem, Logins, DateOfRecord, DeviceLocation) with the following Functional Dependency set: {Device, OperatingSystem} -› DeviceL o cation {Logins, Date0fRecord] – OperatingSystem DeviceLocation -› DateOfRecord If X is the number of candidate keys of DeviceLogs and Y is its highest N ormal Form, find the values of X and Y. a) X=1, Y=2 b) X=2, Y=1 c) X=3, Y = 3 d) X=2, Y=3

3. Consider the relational schema DataLabelling (DataSetName, DataFeatu r e1, DataFeature2, Label, Confidence, Annotators) with the following Functional Dependency set:

4. Consider the relational schema LuckyDraw (Box, Item, Price, Picked, WinningPrize). Which of the following set of functional dependencies should be chosen so that LuckyDraw can be in 2NF but not in 3NF?

5. Consider the relational schema Tournament (Champion, Category, Participants, Judges, Day) with the following Functional Dependency set F.

6. Consider the relational schema Gallery (GallerySection, ArtistID, ArtID, Sold, Theme) with the following Functional Dependency set:

7. Consider the relational schema Gallery (GallerySection, ArtistID, ArtID, Sold, Theme) with the following Functional Dependency sets:

8. Consider the relational schema Gallery (GallerySection, A rtistID, ArtID, Sold, Theme) with the following Functional Dependency set:

9. In a relation FurnitureStore (FurnitureNo, FurnitureType, Price, Width, Height, Weight, DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Width, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent on Furnitu r eNo and Weight together. Which of the following are the non-prime attributes of FurnitureStore? a) FurnitureNo b) Height c) Weight d) DeliveryChar g e

10. In a relation FurnitureStore (FurnitureNo, FurnitureType, Price, Width, Height, Weig DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Wid t h, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent on FurnitureNo and Weight together. The highest normal form of FurnitureStore is n. If the highest normal form of the relation has to be increased to n+1, which of the following changes should be made in its current functional dependency set? a) FurnitureNo and Weight together, should identify FurnitureType and Price b) Only Width, Height and Weight should identify the DeliveryCharge c) Only FurnitureType, Height and Weight should identify the DeliveryCharge d) Only Weight should identify the Width and Hei g ht

Important Links

Leave a comment cancel reply.

Save my name, email, and website in this browser for the next time I comment.