(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
Leave a comment Cancel reply
Save my name, email, and website in this browser for the next time I comment.
Course Name: Data Base Management System
- About Course
- Certificate Type
- Toppers list
- Registration
Course abstract
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 details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course would examine 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. It would also introduce 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 will also be introduced.
Course Instructor
Prof. Partha Pratim Das
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 from 1988 to 1998. In 1998, he joined Alumnus Software Ltd as a Business Development Manager. From 2001 to 2011, he worked for Interra Systems, Inc. as a Senior Director and headed its Kolkata Center. In 2011, he joined back to Department of Computer Science and Engineering, IIT Kharagpur as Professor. Dr. Das has also served as a Visiting Professor with Institute of Radio Physics and Electronics, Calcutta University from 2003 to 2013.
Teaching Assistant(s)
Amrita Chatterjee
B.tech, Information Technology
Smruti Rekha Das
M.Tech, Computer Science and Engineering
Himadri Bhuyan
PhD, IIT Kharagpur
Srijoni Majumdar
Research Scholar
RAJ KUMAR MOHANTA
M.TECH, COMPUTER SCIENCE
Munmun Bhattacharya
I am not a student
Course Duration : Feb-Apr 2019
view course, syllabus, enrollment : 15-nov-2018 to 25-feb-2019, exam registration : 25-feb-2019 to 19-apr-2019, exam date : 27-apr-2019, course statistics will be published shortly, certificate eligible, certified category count, successfully completed, participation.
Category : Successfully Completed
Category : Elite
Category : Silver
Category : Gold
>=90 - Elite + Gold 75-89 -Elite + Silver >=60 - Elite 40-59 - Successfully Completed <40 - No Certificate
Final Score Calculation Logic
- Assignment Score = Average of best 6 out of 8 assignments.
- Final Score(Score on Certificate)= 75% of Exam Score + 25% of Assignment Score
KSHITIJ PATHAK 98%
GOVERNMENT POLYTECHNIC COLLEGE MANDSAUR
KHWAJA BILKHIS 97%
SREENIDHI INSTITUTE OF SCIENCE AND TECHNOLOGY
KARTHIK.S 97%
RATHNAVEL SUBRAMANIAM COLLEGE OF ARTS AND SCEINCE
BIPLAB MAL 97%
NETAJI SUBHASH ENGINEERING COLLEGE
SAI KRISHNA MOTHE 97%
DIVYANK PRATAP TIWARI 96%
HALDIA INSTITUTE OF TECHNOLOGY
ATUL PRATAP SINGH 95%
FUTURE INSTITUTE OF ENGINEERING & TECHNOLOGY
PRIADARSINI M 95%
GOVERNMENT COLLEGE OF ENGINEERING, DHARMAPURI
BHASKAR BANERJEE 95%
GOVT. COLLEGE OF ENGINEERING & TEXTILE TECHNOLOGY SERAMPORE
ROSHAL SURESH MORAES 94%
ST.FRANCIS INSTITUTE OF TECHNOLGY
KANDULA DAMODHAR RAO 94%
NEJIYA A K 94%
COLLEGE OF ENGINEERING PATHANAPURAM
ABHISHEK RAJ 94%
TECHNO INDIA, SALT LAKE, WEST BENGAL
SUMIRAN NAMAN 94%
INSTITUTE OF ENGINEERING & MANAGEMENT
SARADIA SAMANTA 94%
TECHNO INTERNATIONAL NEW TOWN
K VINAY KUMAR 94%
SRI INDU COLLEGE OF ENGINEERING & TECHNOLOGY
SHIVANI SHAKYA 94%
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, BHOPAL
AVESH KUMAR AGRAWAL 94%
KIET GROUP OF INSTITUTIONS
GAUTAM SHARMA 94%
COOCHBEHAR GOVERNMENT ENGINEERING COLLEGE
SUBATHRA S 94%
VELALAR COLLEGE OF ENGINEERING AND TECHNOLOGY
VYAS SAHIL HIRALKUMAR 94%
DWARKADAS J.SANGHVI COLLEGE OF ENGINEERING
NARENDRA PAL SINGH RATHORE 93%
ACROPOLIS INSTITUTE OF TECHNOLOGY & RESEARCH
RITAM CHATTOPADHYAY 93%
KALYANI GOVT. ENGINEERING COLLEGE
RAKESH SINGH SAMBYAL 93%
COLLEGE OF ENGINEERING AND TECHNOLOGY, BABA GHULAM SHAH BADSHAH UNIVERSITY
PRIYANSH UPADHYAY 93%
BIRLA INSTITUTE OF APPLIED SCIENCES
ARAVINDA KASUKURTHI 93%
R.V.R. & J.C. COLLEGE OF ENGINEERING
NAINCY SAHU 93%
TANYA MAHTANI 93%
FUTURE INSTITUTE OF ENGINEERING AND MANAGEMENT
VIVEK KUMAR YADAV 93%
COLLEGE OF ENGINEERING & MANAGEMENT, KOLAGHAT
ABBURI VENKATESH 93%
QIS COLLEGE OF ENGINEERING AND TECHNOLOGY
SIBASIS BHATTACHARJEE 93%
ST.THOMAS COLLEGE OF ENGINEERING AND TECHNOLOGY
VUPPALA LALITH KIRAN 93%
RAHUL BISWAS 93%
TECHNO INDIA UNIVERSITY, WEST BENGAL
KIRTI JAIN 93%
INDERPRASTHA ENGINEERING COLLEGE
LAVANYA D 93%
MEGHA SAHA 93%
SUDIP DAS 93%
REBELLI DHAVALA RISHITHA 92%
K. MONIKA SREE SAANKHYA 92%
JULURI SAMATHA 92%
MATRUSRI ENGINEERING COLLEGE
VISHAL AGRAWAL 92%
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE
AARTHY B 92%
VV COLLEGE OF ENGINEERING
SHIVAM KUMAR CHAUDHARY 92%
DURGAPUR INSTITUTE OF ADVANCED TECHNOLOGY & MANAGEMENT
BIVIN VARKEY VARGHESE 92%
RAJIV GANDHI INSTITUTE OF TECHNOLOGY, KOTTAYAM, KERALA
ANKIT KUMAR SINHA 92%
SWAGATAM CHAKRABORTY 92%
VARTIKA KEDIA 92%
ASANSOL ENGINEERING COLLEGE
SUDARSHAN KUMAR PRAJAPATI 92%
RAJ KUMAR GOEL INSTITUTE OF TECHNOLOGY
ARINDAM CHATTOPADHYAY 92%
GOVERNMENT COLLEGE OF ENGINEERING AND TEXTILE TECHNOLOGY,SERAMPORE
AVNISH KUMAR 92%
SOUMO SUVRA NASKAR 91%
JALPAIGURI GOVT. ENGINEERING COLLEGE
AADITYA GARG 91%
CHIRAG GUPTA 91%
M B M ENGINEERING COLLEGE
BIKUMALLA SAIKIRAN 91%
SUMANTA NAG 91%
TALAPALLI VINEETH KUMAR 91%
N.KAVISANKAR 91%
SRI RAMAKRISHNA INSTITUTE OF TECHNOLOGY
SANGEETA GUPTA 91%
VARDHAMAN COLLEGE OF ENGINEERING
SHAKEEL AHMAD DAR 91%
DEPTT OF TECHNICAL EDUCATION ,J&K GOVT
RABI NARAYAN PANDA 91%
SUBHATAV DHALI 91%
YOGITA KHATRI 91%
JSS ACADEMY OF TECHNICAL EDUCATION
REEMA BANERJEE 91%
KHITISH KUMAR GADNAYAK 91%
GANDHI ENGINEERING COLLEGE
ARJUN RUPAVATIA 91%
CHAROTAR UNIVERSITY OF SCIENCE AND TECHNOLOGY
ANISHA GUPTA 91%
BABU BANARSI DAS ENGINEERING COLLEGE
MANKU KUMAR PATHAK 91%
NIT AGARTALA
CHAITANYA VAISHAMPAYAN 91%
DEBJANI MONDAL 91%
RCC INSTITUTE OF INFORMATION TECHNOLOGY
BETHINENI SARITHA 91%
VAAGDEVI COLLEGE OF ENGINEERING
RIYA GHOSH 91%
S USHA KIRUTHIKA 91%
S.R.M. INSTITUTE OF SCIENCE AND TECHNOLOGY
DR. KAMAL SETHI 90%
PALASH GOLE 90%
JABALPUR ENGINEERING COLLEGE, JABALPUR
SUMAN RANA 90%
MANALI CHANDRAKANT SETH 90%
ANUP BURNWAL 90%
RIYA B. GEORGE 90%
KUNAL KUMAR 90%
SHRUTI WASNIK 90%
MIRYALA SUPRAJA 90%
MANASA REDDY 90%
BASANI AISHWARYA 90%
RAJALAKSHMI D 90%
R.M.D. ENGINEERING COLLEGE
MAHESHWARI.G 90%
PONDICHERRY UNIVERSITY
CHIRADIP BHATTACHARYA 90%
M REVATHI 90%
HINDUSTHAN COLLEGE OF ENGINEERING & TECHNOLOGY
LATHA R 90%
THE OXFORD COLLEGE OF ENGINEERING
ANWESHA KAR 90%
SAYANTI DEY 90%
GOVERNMENT COLLEGE OF ENGINEERING & TEXTILE TECHNOLOGY , SERAMPORE
MADADI SAISREE 90%
SNEHA KEDIA 90%
SAYYADA HAJERA BEGUM 90%
MUFFAKHAM JAH COLLEGE OF ENGINEERING AND TECHNOLOGY
MANSI BHATT 90%
SUBHAM VERMA 90%
DONTHULA VIKAS 90%
ANIRUDDHA MAITY 89%
GOVT. COLLEGE OF ENGINEERING & TEXTILE TECHNOLOGY BERHAMPORE
K V SAI SNEHA 89%
B SURAJ 89%
SLESHA SANGHVI 89%
CHHOTUBHAI GOPALBHAI PATEL INSTITUTE OF TECHNOLOGY
RITU AGARWAL 89%
MANJEEMA GHOSH 89%
A. REGITA THANGAM 89%
ST.XAVIERS COLLEGE, PALAYAMKOTTAI
RITU VERMA 89%
HARCOURT BUTLER TECHNICAL UNIVERSITY
ROHIT KUNDU 89%
ASHISH GUNJAN 89%
PRIYANKA SAHA 89%
LEELAKRISHNA THIYAGARAJAN 89%
CHENNAI INSTITUTE OF TECHNOLOGY
RITU KUMARI SINGH 89%
RAVINDRA KUMAR MEHTA 89%
MEGHA MUKUNDRAO CHAITANYA 89%
PURANMAL LAHOTI GOVT POLY LATUR
YADLAPALLI.NAVYA 89%
OINDRILA DAS 89%
MUKESH SONI 89%
SMT. S R PATEL ENGINEERING COLLEGE
DIPTI PAWAR 89%
BHARATI VIDYAPEETH (DU) COLLEGE OF ENGINEERING, PUNE
PALAK AMIN 89%
SHILPA KUMARI 89%
SHREYA KUMARI 89%
PALIKA JAJOO 89%
KAUTILYA INSTITUTE OF TECHNOLOGY & ENGINEERING
A.R.MUHILRAAJ 89%
SONA COLLEGE OF TECHNOLOGY
ANKIT SHARMA 89%
MADAPANA JYOTSHNA 89%
AJIT KUMAR 89%
ABACUS INSTITUTE OF ENGINEERING AND MANAGEMENT
JAYANT KUMAR 88%
DRONACHARYA GROUP OF INSTITUTIONS
BIPIN BIHARI LAL 88%
PRATEEK TRIPATHI 88%
DEWAN V.S. INSTITUTE OF ENGINEERING AND TECHNOLOGY
KAVYAPONNAPATI 88%
GUDLAVALLERU ENGINEERING COLLEGE
P.PRANEETH 88%
NATIONAL INSTITUTE OF TECHNOLOGY ANDHRA PRADESH
ASHOK KUMAR 88%
SIVA NAGA PRASAD MANNEM 88%
BISHAL SHARMA 88%
JOYNATH BARMAN 88%
ASSAM UNIVERSITY
ESHANI GHOSH 88%
JULIE KUMARI 88%
MADHAV INSTITUTE OF TECHNOLOGY & SCIENCE
SNEHA GARG 88%
BHAGYA LAXMI K 88%
AKANKSHA PRIYADARSHNI 88%
T.ARUNA JYOTHI 88%
AASTHA MISHRA 88%
PALAK GUPTA 88%
JAGANNATH INTERNATIONAL MANAGEMENT SCHOOL
ANAND KUMAR SHUKLA 88%
PANKAJ KUMAR 88%
RAJKIYA ENGINEERING COLLEGE , SONBHADRA
BALU THOTA 88%
NAMRATA NIDHI 88%
BISWOJIT NAYAK 88%
UTKAL UNIVERSITY
DODDI SRILATHA 88%
HASEEB AHMAD QUADRI 88%
SRM INSITUTE OF SCIENCE AND TECHNOLOGY, DELHI-NCR CAMPUS
PRADHYUMNA KILEDAR 88%
SHEETAL KUMARI 88%
SHAHINA ANJUM 88%
ACCURATE INSTITUTE OF MANAGEMENT & TECHNOLOGY
GIBIN GEORGE 88%
SANTHIGIRI COLLEGE OF COMPUTER SCIENCES
ALKA PRASAD 88%
BHARGAVI CHEVVA 88%
AMAN SAHU 88%
MEDI-CAPS UNIVERSITY,INDORE
VILESH AGARWAL 88%
VISHWAKARMA INSTITUTE OF TECHNOLOGY
PRASHANT KUMAR SHARMA 88%
HINDUSTAN INSTITUTE OF MANAGEMENT AND COMPUTER STUDIES
DR. ABINASH TRIPATHY 88%
RAGHU ENGINEERING COLLEGE
PRIYANKA CHITLANGIA 88%
ALOK KUMAR GUPTA 88%
HEMANTH GADARLA 88%
A SAI RAM 88%
ITTE LAVANYA 88%
SRI VASAVI ENGINEERING COLLEGE
CHERUKU PRIYANKA 88%
MOTAPOTHULA JYOTHI PRIYA 87%
YAJUSHI DEY 87%
VIGNESH S 87%
REDDY SAISINDHUTHEJA 87%
SANGEETHA B 87%
PSG COLLEGE OF TECHNOLOGY
PRINCE KUMAR SINGH 87%
MCKV INSTITUTE OF ENGINEERING
MANSI KULKARNI 87%
ABHINAV RAJ 87%
SIR M. VISVESVARAYA INSTITUTE OF TECHNOLOGY
RITIKA KUMARI 87%
PRIYA SONI 87%
DR. D V LALITA PARAMESWARI 87%
G. NARAYANAMMA INSTITUTE OF TECHNOLOGY AND SCIENCE (FOR WOMEN)
SURBHI SHARMA 87%
GLA UNIVERSITY, MATHURA
ARADHI SUDHIR SADRANI 87%
SUCHITHRA VS 87%
GOVERNMENT ENGINEERING COLLEGE, PALAKKAD
MAYANK SHUKLA 87%
UNITED COLLEGE OF ENGINEERING AND MANAGEMENT
VIJAYALAKSHMI CHERUKU 87%
CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY,HYDERABAD
UJWALA BHOGA 87%
ANURAG GROUPS OF INSTITUTIONS
SHASHANK RAI 87%
DUDUKU VARUN 87%
CHAUHAN DHARMESH 87%
THANGADIPELLI APOORVA 87%
LAKSHMI BHASKARLA 87%
VELAGAPUDI RAMAKRISHNA SIDDHARTHA ENGINEERING COLLEGE
PIYUSH GUPTA 87%
NIVETHA B 87%
VINAY KUMAR GUPTA 87%
GUNJAN BHARADWAJ 87%
L. PRABAHAR 87%
KAMARAJ COLLEGE OF ENGINEERING AND TECHNOLOGY
SANJEEV KUMAR MISHRA 87%
GYANESH SHARMA 87%
NITIN PRASHANT 87%
ARYA COLLEGE OF ENGINEERING & INFORMATION TECHNOLOGY
JOYDEEP BISWAS 87%
RAMKRISHNA MAHATO GOVERNMENT ENGINEERING COLLEGE PURULIA
PRANAV PRAKASH 87%
SUBHRA GHATAK 86%
INSTITUTE OF ENGINEERING & MANAGEMENT (ASHRAM CAMPUS)
MANIKONDA VYSHNAVI 86%
ABHISHEK CHANDRA JHA 86%
GAURI DIPAK PATNE 86%
GOVERNMENT POLYTECHNIC OSMANABAD
SADAF R. SURYAWANSHI 86%
GOVERNMENT POLYTECHNIC, THANE
VENUGOPAL S 86%
ACE ENGINEERING COLLEGE
MD SIRAJUL HUQUE 86%
GURU NANAK INSTITUTIONS TECHNICAL CAMPUS
NITISH KUMAR SHARMA 86%
SHAIK MAHAMMAD IQBAL 86%
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY,KAKINADA
PARCHURI PAVAN SAI KRISHNA 86%
MALKAPURAM NIKHITHA 86%
PRITHWIJIT BHATTACHARYA 86%
UNIVERSITY OF ENGINEERING & MANAGEMENT (UEM)
GUNTUKU RAMYA 86%
PENUMAKA RAMA BHARGAVI 86%
VISHNU INSTITUTE OF TECHNOLOGY
VINAYAK SONI 86%
SUCHITH REDDY 86%
RADHIKA RATHI 86%
PANKAJ MITHANI 86%
EKTA GUPTA 86%
PRANVEER SINGH INSTITUTE OF TECHNOLOGY
ALAMPALLY SREEDEVI 86%
SRAVAN KUMAR G 86%
SPHOORTHY ENGINEERING COLLEGE
ABHISEK DAS 86%
B.P. PODDAR INSTITUTE OF MANAGEMENT AND TECHNOLOGY
SARIKONDA SACHIN GOUD 86%
THRISHA BANDI 86%
JNTU HYDERBAD COLLEGE OF ENGINEERING,JAGTIAL
ARCHANA K M 86%
GOVERNMENT ENGINEERING COLLEGE, THRISSUR
JHALAK GOYAL 86%
KORADA ABHISHEK 86%
MAHARAJ VIJAYARAM GAJAPATHI RAJ COLLEGE OF ENGINEERING
SUSHOBHAN GHOSH 86%
DR. B. C. ROY ENGINEERING COLLEGE
RUTVIK RUPAPARA 86%
SINDHURA BANDARU 86%
T.LALIT ADITYA 86%
THILAGU M 86%
AVINASHILINGAM INSTITUTE FOR HOME SCIENCE AND HIGHER EDUCATION FOR WOMEN
DEBDUTTA PAL 86%
CALCUTTA INSTITUTE OF ENGINEERING AND MANAGEMENT
RAVINDER SINGH 86%
LOVELY PROFESSIONAL UNIVERSITY
SUBHAM AGARWALLA 86%
MERUGUMALA DIVYA SRI 86%
K SAI SIDDHARTHA 86%
VASAVI COLLEGE OF ENGINEERING
NABONITA DEBNATH 86%
NATIONAL INSTITUTE OF TECHNOLOGY AGARTALA
SHAILZA KUMARI 86%
J. GEETHA PRIYA 86%
THALLURI VENKATA UMA MAHESWARA RAO 86%
PANKAJ KUMAR MUNDHRA 86%
ARUNA KUMARI BODALA 86%
SUSHANT KUMAR 86%
SWAMI KESHVANAND INSTITUTE OF TECHNOLOGY MANAGEMENT & GRAMOTHAN
SHIVANGI GARG 86%
GAURAB ROY 86%
INDRANIL CHOWDHURY 86%
KAKARLA DIVYA 86%
INSTITUTE OF AERONAUTICAL ENGINEERING
PREETIKA PRAKASH 86%
ABHISEK SAHA 86%
JONY SAHA 86%
TAMOJIT MITRA 86%
AYUSH KUMAR RAI 86%
Enrollment Statistics
Total enrollment: 42626, registration statistics, total registration : 6297, assignment statistics, score distribution graph - legend, assignment score: distribution of average scores garnered by students per assignment., exam score : distribution of the final exam score of students., final score : distribution of the combined score of assignments and final exam, based on the score logic..
Data Base Management System | NPTEL 2022 | Week 1 Assignment Solutions
This set of MCQ(multiple choice questions) focuses on the Data Base Management System NPTEL 2022 Week 1 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 1 Assignment Solution” contains 20 questions.
Now, start attempting the quiz.
Data Base Management System NPTEL 2022 Week 1 Assignment Solutions
Q1. Identify the correct statement(s) from the following.
a) The overall physical structure of the database is called physical schema. b) The actual content of the database at a particular point in time is called an instance. c) Data dictionary does not contain any database schema. d) Physical schema describes how data is stored in the database and the relationships among the data
Answer: a), b)
Q2. Consider the following instance: MLDatabase
Identify the correct representation of MLDatabase schema.
a) MLDatabase( Model , Accuracy, Dataset , TrainingData) b) MLDatabase(Model, Accuracy, Dataset, TrainingData ) c) MLDatabase( Model, Accuracy , Dataset, TrainingData) d) MLDatabase( Model, Accuracy, Dataset , TrainingData)
Q3. Identify the incorrect statement(s).
a) A Super Key is a set of one or more attributes that, taken collectively, allows us to uniquely identify an entity in the entity set. b) A proper subset of a candidate key is called a Super Key. c) The minimal set of attributes that allows us to uniquely identify an entity in the entity set is called a candidate key. d) A proper subset of a Super Key is not always a Candidate Key.
Q4. Consider two relations below. The primary keys are underlined. Identify all possible foreign key(s) from the options. Employee( EmpID , Ename, Salary) where EmpID is of type integer, Ename is of type string, and Salary is of type decimal number. Project( EmpID, Pnumber ) where EmpID is of type integer, and Pnumber is of type string.
a) Ename b) EmpID c) Pnumber d) EmpID, Pnumber
Q5. Consider the following instance of ImageRec( Sl , DepthImage, Coord1, Coord2).
Which of the following is a Secondary Key in ImageRec?
a) {Sl, DepthImage} b) {Coord1, Coord2} c) {Coord2, DepthImage} d) {Coord1, DepthImage}
Data Base Management System NPTEL Week 1 Assignment Solutions
Q6. Consider the following instances:
How many tuples will be selected by σPlayer = Gamer(Game1 x Game2)?
a) 3 b) 4 c) 8 d) 9
Answer: b) 4
Q7. Consider the two tables given below:
Identify the correct statement from the following.
a) Cartesian product of Student and Teacher has six tuples. b) Cartesian product of Student and Teacher is not possible. c) There will be three tuples in the result of the natural join between Student and Teacher. d) Natural join between Student and Teacher is not possible.
Q8. Consider the following table:
a) II (Branch=Address) Λ (Salary>10000) (EmployeeDetails) b) II (Branch=Address) v (Salary>10000) (EmployeeDetails) c) σ (Branch=Address) Λ (Salary>10000) (EmployeeDetails) d) σ (Branch=Address) v (Salary>10000) (EmployeeDetails)
Q9. Consider the following tables:
a) R 1 — R 2 b) R 2 — R 1 c)( R 1 U R 2 ) ∩ ( R 1 ∩ R 2 ) d) (R 1 — R 2 ) U (R 2 — R 1 )
Q10. Which of the following can be a candidate key for the following instance?
a) {EmpName} b) {Branch} c) {EmpName, Address} d) {EmpName, Branch}
<< Prev- Data Base Management System Week 0 Assignment Solutions
>> Next- Data Base Management System Week 2 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.
- 1st Central Law Reviews: Expert Legal Analysis & Insights
- 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.
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 .
nptel-solutions
Here are 47 public repositories matching this topic..., kishanrajput23 / nptel-the-joy-of-computing-using-python.
Study materials related to this course.
- Updated Oct 27, 2023
kishanrajput23 / NPTEL-Programming-In-java
- Updated Apr 14, 2022
kadeep47 / NPTEL-Getting-Started-With-Competitive-Programming
[Aug - Oct 2023] Solutions for NPTEL Course Getting started with competitive programming weekly assignment.
- Updated Sep 6, 2023
omunite215 / NPTEL-Programming-in-Java-Ultimate-Guide
I am sharing my journey of studying a course on Programming in Java taught by Prof.Debasis Samanta Sir IIT Kharagpur
- Updated Dec 4, 2023
Md-Awaf / NPTEL-Course-Getting-started-with-Competitive-Programming
Solutions for NPTEL Course Getting started with competitive programming weekly assignment.
- Updated Apr 20, 2023
rvutd / NPTEL-Joy-of-Computing-2020
Programming Assignment Solutions
- Updated May 5, 2020
guru-shreyansh / NPTEL-Programming-in-Java
The sole intention behind this repository is to help the beginners in Java with the course contents.
- Updated Aug 1, 2021
gunjanmimo / NPTEL-The-Joy-of-Computing-using-Python
- Updated Jan 26, 2020
AdishiSood / The-Joy-of-Computing-using-Python
- Updated Apr 28, 2021
avinashyadav16 / The-Joy-of-Computing-Using-Pyhton
12 Weeks long NPTEL Elective MOOC Course's codes, assignments and solutions.
- Updated Oct 30, 2023
- Jupyter Notebook
NPTEL-Course / Programming-Data-Structures-And-Algorithms-Using-Python
Nptel Course Solutions : Programming, Data Structures And Algorithms Using Python
- Updated Nov 30, 2020
tdishant / NPTEL-Joy-of-Computing-Using-Python
Python code from week-3 to week-12 for the NPTEL course The Joy of Computing using Python
- Updated Oct 26, 2021
TarunSehgal27 / NPTEL-JAVA-2020
this is a repo about the java program headed by Debasis Samantha during 2020
- Updated Apr 23, 2020
gxuxhxm / NPTEL-The-Joy-of-Computing-using-Python
NPTEL-The-Joy-of-Computing-using-Python with NOTES and Weekly quizes Answers
- Updated Dec 31, 2023
NPTEL-Course / Google-Cloud-Computing-Foundations
Nptel Course Solution : Google Cloud Computing Foundations
- Updated Nov 19, 2020
Anmol-PROgrammar / SWAYAM-Programming_In_Java-NPTEL
This site contains the weekly( i.e. 1-9) questions and their solution of NPTEL-SWAYAM course "Programming in Java".
- Updated Aug 19, 2021
lonebots / python-programming-joc-nptel
Python programming repository for NPTEL joy of computing course
- Updated Dec 21, 2020
Gangaduraie / Introduction-to-IoT-and-Industry-4.0
NPTEL- Introduction to IoT and Industry 4.0
- Updated Jan 27, 2024
CGreenP / NPTEL-Programming-Assignment-Road-Trips-and-Museums
NPTEL Programming Assignment: Road Trips and Museums.
- Updated Mar 3, 2024
CGreenP / NPTEL-Programming-Assignment-T1-Q2
NPTEL Programming Assignment: T1-Q2
- Updated Mar 7, 2024
Improve this page
Add a description, image, and links to the nptel-solutions topic page so that developers can more easily learn about it.
Curate this topic
Add this topic to your repo
To associate your repository with the nptel-solutions topic, visit your repo's landing page and select "manage topics."
NPTEL Data Base Management System Assignment 1 Answers 2023
NPTEL Data Base Management System Assignment 1 Answers: 2023 – All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.
NPTEL Data Base Management System Week 1 Assignment Answers 2023
1. Which of the following statements is (are) correct?
- a) Phsical level abstraction describes how a record is stored.
- b) View level abstraction hides details of data types.
- c) Physical level abstraction describ e s data stored in a database and their relationships.
- d) Logical level abstraction defines the physical schema.
2. Consider the following relations:
Subject (sid, sn a me, credit) Faculty (fid, sid) Which of the following is correct?
- a) RA 1 C RAz
- b) RAg C RAg
- c) RAI C RA g
- d) RA1 = RAg
3. What does the following Relational Algebra expression return?
- a) All heights except the maximum height from Mountain relation.
- b) All heights except the minimum height from Mountain relation.
- c) Minimum height from Mountain relation.
- d) Maximum height from Mountain relation.
4. Consider the relational schema PhoneBook (Name, PhoneNo, Location, LastCalled)
- Ankit 3222265783 Kolkata 15 Ju l
- Shreya 3222265783 Delhi 16 Jul
- Ankit 2222586110 Delhi 16 Jul
- Shreya 2222586110 K olkata 15 Jul
5. Consider the relation Flight (FlightNo, Source, Destination, Duration) where {FlightNo} and {Source, Destination, Duration} are the 2 candidate keys. What is the possible num- ber of superke y s of Flight?
6. Consider a truth table having the following columns P Q R= ((P V Q) – -P) S= ( (P V Q) – P) If the truth table, with all the values, is represented as a relational instance, which column(s) (attribute(s)) should be chosen as candidate keys?
7. Consider the following instance of ChatBox (SenderID, ReceiverID).
8. Consider the following table:
9. Consider the following table:
10. Which of the following can be a candidate k e y for the following instance?
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 average of 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 AVERAGE ASSIGNMENT SCORE >=10/25 AND 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 1 Answers below.
NPTEL Data Base Management System Assignment 1 Answers July 2022
1. Identify the correct statement (s).
2. A relation R has 2 candidate keys withl and 2 attributes respectively. There are 40 super keys of R. What is the total number of attributes in R? a) 3 b) 4 c) 5 d) 6
Answers will be Uploaded Shortly and it will be Notified on Telegram, So JOIN NOW
3. Which of the following relational operations will produce the following tuple only? a) (QB1 U QB2) x (QB2 U QB1) b) (QB1-QB2) n (QB2 QB1) c) (QB1 QB2) x (QB2 QB1) d) (QB1 n QB2) – (QB2 n QB1)
4. Which of the following is a Secondary Key in CelestialReport? a) {ReportBy, ReportScore}. b) {ReportBy, GroupLead}. c) {CroupLead, Celestial0bject}. d) {ReportScore, GroupLead}
5. Consider the following relational schema for a university: student (roll.no, name, dob) dept (deptNo, dName, location) project (proj-no, deptNo, rOllno, pName) What is the type of the key(s) that will be used to uniquely identify an entity of the project relation? a) simple key b) Alternate Key C)Composite Key d) Compound key
6. ldentity the correct relational algebraic expression for the following query: Find the names of students uho have selected any project offered by the department “CSE”. a) ||name ( (student a project) bM lHdeptNo dName= “CSE” (dept) )) b) ||name (aName=” “CSE” (dept project)) ) c) ||name (o dName=* “CSE” (student ba dept) ba (project) ) d) ||name (student ba (aName= “CSE” (project) ))
👇 For Week 02 Assignment Answers 👇
7. ldentify the correct operation(s) which will produce the following output from the above two relations. a) R1 R2 b) R2- -R1 c) (R1 UR2) n (Ri n Ra) d) (R1-R2) U (Ra- R)
8. ldentity the correct operation(s) which produces the following output from the above relation. a) ||(YEAR_PUB=2010) v (TOTAL SOLD_COPIES >15000) (BookDetalls) b) ||YEARPUB=2010) A (TOTAL.SOLD.cOPIES > 15000) (BookDetails) c) (YEAR_PUB=2010) v (TOTAL SOLD COPIES > 15000) (BookDetails) d) (YEARPUB=2010) (TOTAL SOLD.COPIES > 15000) (BookDetails)
9. Consider the following instannce:
10. Which of the following can be a candidate key for the following instance? a) (BOOKID, YEAR PUB} b) {BOOK_ID, BOOK TITLE} c) {BOOKTITLE, AUTHOR NAME} d) {B0OK_ID}
NPTEL Data Base Management System Assignment 1 Answers 2022: All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.
For More NPTEL Answers:- CLICK HERE Join Our Telegram:- CLICK HERE
NPTEL Data Base Management System Assignment 1 Answers Jan 2022
Q1. Identify the correct statement(s) from the following.
a) The overall physical structure of the database is called physical schema. b) The actual content of the database at a particular point in time is called an instance. c) Data dictionary does not contain any database schema. d) Physical schema describes how data is stored in the database and the relationships among the data.
Answer:- (A), (B)
Q2. Consider the following instance:
Identify the correct representation of MLDatabase schema.
a) MLDatabase (Model, Accuracy. Dataset, TrainingData). b) MLDatabase (Model, Accuracy, Datanet, TrainingData). c) MLDatabase (Model, Accuracy, Dataset, TrainingData). d) MLDatabase (Model, Accuracy, Dataset, TrainingData).
Answer:- (A)
Q3. Identify the incorrect statement(s).
a) A Super Key is a set of one or more attributes that, taken collectively, allows us to uniquely identify an entity in the entity set. b) A proper subset of a candidate key is called a Super Key. c) The minimal set of attributes that allows us to uniquely identify an entity in the entity set is called a candidate key. d) A proper subset of a Super Key is not always a Candidate Key.
Answer:- (B)
Q4. Consider two relations below. The primary keys are underlined. Identify all possible foreign key (s) from the options. Employee (EmpID, Enano, Salary) where EmpID is of type integer, Ename is of type string. and Salary is of type decimal number. Project (EmpID, Pnumber) where ExpID is of type integer, and Pnumber is of type string.
a) Ename b) EmpID c) Paunber d) EmpID, Pnumber
Q5. Consider the following instance of ImageRec (31. DepthImage, Coordi, Coord2))
Which of the following is a Secondary Key in InageRec?
a) (S1. Depth Image). b) (Coord1, Coord2). c) (Coord2, DepthImage). d) (Coord1. DepthImage).
Answer:- (C)
Q6. Consider the following instances:
How many tuples will be selected by aplayer=Gamer (Game1 x Game2) ?
a) 3 b) 4 c) 8 d) 9
Q7. Consider the two tables given below.
Identify the correct statement from the following.
a) Cartesian product of Student and Teacher has six tuples b) Cartesian product of Student and Teacher is not possible. c) There will be three tuples in the result of the natural join between Student and Teacher. d) Natural Join between Student and Teacher is not possible.
Answer:- (D)
Q8. Consider the following table:
Identify the correct operation(s) which produces the following output from the above relation.
a) II (Branch-Address) (Salary>10000) (EmployeeDetails) b) II (Branch-Address) v (Salary>10000) (EmployeeDetails) c) (Branch-Address) (Salary>10000) (EmployeeDetails) d) (Branch-Address) v (Salary>10000) (EmployeeDetails)
Q9. Consider the following tables:
Identify the correct operation(s) which will produce the following output from the above two relations.
a) R₁-R₂ b) R 2 -R 1 c) (R 1 UR₂) ∩ (R 1 ∩R₂) d) (R 1 -R₂) U (R₂-R₁)
Q10. Which of the following can be a candidate key for the following instance?
a) {EmpName} b) (Branch) c) (EmpName, Address) d) (Emplame, Branch)
Answer:-(D)
READ IT ALSO:-
NPTEL English Literature for competitive exams Assignment 1 Answers
NPTEL Data Analytics with Python Assignment 1 Answers 2022
NPTEL Introduction To Internet Of Things Assignment 1 Answers
NPTEL Cloud Computing Week 1 Assignment Answers 2022
NPTEL Python for Data Science Assignment 1 Answers 2022
NPTEL The Joy of Computing using Python Assignment 1 Answers
NPTEL Data Base Management System Assignment 1 Answers:- All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.
Leave a Comment Cancel reply
You must be logged in to post a comment.
- Review Assignment
- Announcements
- About the Course
- Explore Courses
NPTEL: Exam Registration is open now for July 2022 courses!
Dear Candidate, Here is a golden opportunity for those who had previously enrolled in this course during the July 2021 semester, but could not participate in the exams or were absent/did not pass the exam for this course. This course is being reoffered in July 2022 and we are giving you another chance to write the exam in October 2022 and obtain a certificate based on NPTEL norms. Do not let go of this unique opportunity to earn a certificate from the IITs/IISc. IMPORTANT instructions for learners - Please read this carefully 1. The exam date for this course: October 29 2022 2. CLICK HERE to register for the exam. Please fill the exam form using the same Enrolled email id & make fee payment via the form, as before. 3. Choose from the Cities where exam will be conducted: Exam Cities 4. You DO NOT have to re-enroll in the courses. 5. You DO NOT have to resubmit Assignments OR participate in the non-proctored programming exams in the previous semester 6. If you do enroll to July 2022 course, we will take the best average assignment scores/non-proctored programming exam score across the two semesters NOTE: Please check once if you have >= 40/100 in average assignment score and also participated and satisfied the criteria in the non-proctored programming exams that were conducted in July 2021 to become eligible for the e-certificate, wherever applicable. If not, please submit assignments again in the July 2022 course & and also participate in the non-proctored programming exams to become eligible for the e-certificate. We will not be having new assignments or unproctored exams in the previous semester's(July 2021) course. You can also submit assignments again and participate in the non-proctored programming exams if you want to take fresh assignments or need to improve your previous scores. RECOMMENDATION: If you want to take new assignments and an unproctored exam or brush up on your lessons for the exam, please enroll in the July 2022 course. LINK to enroll in the current course: https://onlinecourses.nptel.ac.in/noc22_cs91/preview 7. Exam fees: If you register for the exam and pay before Sep 12, 2022, 10:00 AM , Exam fees will be Rs. 1000/- per exam. If you register for exam before Sep 12, 2022, 10:00 AM and have not paid or if you register between Sep 12, 2022, 10:00 AM & Sep 16, 2022, 10:00 AM , Exam fees will be Rs. 1500/- per exam 8. 50% fee waiver for the following categories: Students belonging to the SC/ST category: please select Yes for the SC/ST option and upload the correct Community certificate. Students belonging to the PwD category with more than 40% disability: please select Yes for the option and upload the relevant Disability certificate. 9. Last date for exam registration: Sep 16, 2022, 10:00 AM (Friday). 10. Mode of payment: Online payment - debit card/credit card/net banking/UPI. 11. HALL TICKET: The hall ticket will be available for download tentatively by 2 weeks prior to the exam date . We will confirm the same through an announcement once it is published. 12. FOR CANDIDATES WHO WOULD LIKE TO WRITE MORE THAN 1 COURSE EXAM:- you can add or delete courses and pay separately till the date when the exam form closes. Same day of exam you can write exams for 2 courses in the 2 sessions. Same exam center will be allocated for both the sessions. 13. Data changes: Last date for data changes: Sep 16, 2022, 10:00 AM: All the fields in the Exam form except for the following ones can be changed until the form closes. The following 6 fields can be changed ONLY when there are NO courses in the course cart. And you will be able to edit the following fields only if you: - REMOVE unpaid courses from the cart And/or - CANCEL paid courses 1. Do you come under the SC/ST category? * 2. SC/ST Proof 3. Are you a person with disabilities? * 4. Are you a person with disabilities above 40%? 5. Disabilities Proof 6. What is your role ? Note: Once you remove or cancel a course, you will be able to edit these fields immediately. But, for cancelled courses, refund of fees will be initiated only after 2 weeks. 14. LAST DATE FOR CANCELLING EXAMS and getting a refund: Sep 16, 2022, 10:00 AM 15. Click here to view Timeline and Guideline : Guideline Domain Certification Domain Certification helps learners to gain expertise in a specific Area/Domain. This can be helpful for learners who wish to work in a particular area as part of their job or research or for those appearing for some competitive exam or becoming job ready or specialising in an area of study. Every domain will comprise Core courses and Elective courses. Once a learner completes the requisite courses per the mentioned criteria, you will receive a Domain Certificate showcasing your scores and the domain of expertise. Kindly refer to the following link for the list of courses available under each domain: https://nptel.ac.in/domains Outside India Candidates Candidates who are residing outside India may also fill the exam form and pay the fees. Mode of exam and other details will be communicated to you separately. Thanks & Regards, NPTEL TEAM
NPTEL: Exam Registration is open now for Jan 2022 courses!
Dear Candidate,
Here is a golden opportunity for those who had previously enrolled in this course during the July 2021 semester, but could not participate in the exams or were absent/did not pass the exam for this course. This course is being reoffered in Jan 2022 and we are giving you another chance to write the exam in March 2022 and obtain a certificate based on NPTEL norms. Do not let go of this unique opportunity to earn a certificate from the IITs/IISc.
IMPORTANT instructions for learners - Please read this carefully
1. The exam date for this course: March 27, 2022
2. Certification exam registration URL is: CLICK HERE
Please fill the exam form using the same Enrolled email id & make fee payment via the form, as before.
3. Choose from the Cities where exam will be conducted: Exam Cities
4. You DO NOT have to re-enroll in the courses.
5. You DO NOT have to resubmit Assignments OR participate in the non-proctored
programming exams.
6. If you do enroll to Jan 2022 course, we will take the best average assignment scores/non-proctored programming exam score across the two semesters
Our suggestion:
- Please check once if you have >= 40/100 in average assignment score and also participate in the non-proctored programming exams that will be conducted during this semester in the course to become eligible for the e-certificate, wherever applicable.
- If not, please submit Assignments again in the Jan 2022 course & and also participate in the non-proctored programming exams to become eligible for the e-certificate.
- You can also submit Assignments again and participate in the non-proctored programming exams if you want to better your previous scores.
RECOMMENDATION: Please enroll to the Jan 2022 course and brush up your lessons for the exam.
7. Exam fees:
If you register for the exam and pay before Feb 14, 2022, 10:00 AM, Exam fees will be Rs. 1000/- per exam .
If you register for exam before Feb 14, 2022, 10:00 AM and have not paid or if you register between Feb 14, 2022, 10:00 AM & Feb 18, 2022, 10:00 AM, Exam fees will be Rs. 1500/- per exam
8. 50% fee waiver for the following categories:
Students belonging to the SC/ST category: please select Yes for the SC/ST option and upload the correct Community certificate.
Students belonging to the PwD category with more than 40% disability: please select Yes for the option and upload the relevant Disability certificate.
9. Last date for exam registration: Feb 18, 2022 10:00 AM (Friday).
10. Mode of payment: Online payment - debit card/credit card/net banking.
11. HALL TICKET:
The hall ticket will be available for download tentatively by 2 weeks prior to the exam date . We will confirm the same through an announcement once it is published.
12. FOR CANDIDATES WHO WOULD LIKE TO WRITE MORE THAN 1 COURSE EXAM:- you can add or delete courses and pay separately – till the date when the exam form closes. Same day of exam – you can write exams for 2 courses in the 2 sessions. Same exam center will be allocated for both the sessions.
13. Data changes:
Last date for data changes: Feb 18, 2022 10:00 AM :
All the fields in the Exam form except for the following ones can be changed until the form closes.
The following 6 fields can be changed ONLY when there are NO courses in the course cart. And you will be able to edit the following fields only if you: -
REMOVE unpaid courses from the cart And/or - CANCEL paid courses
1. Do you come under the SC/ST category? *
2. SC/ST Proof
3. Are you a person with disabilities? *
4. Are you a person with disabilities above 40%?
5. Disabilities Proof
6. What is your role ?
Note: Once you remove or cancel a course, you will be able to edit these fields immediately.
But, for cancelled courses, refund of fees will be initiated only after 2 weeks.
14. LAST DATE FOR CANCELLING EXAMS and getting a refund: Feb 18, 2022 10:00 AM
15. Click here to view Timeline and Guideline : Guideline
Domain Certification
Domain Certification helps learners to gain expertise in a specific Area/Domain. This can be helpful for learners who wish to work in a particular area as part of their job or research or for those appearing for some competitive exam or becoming job ready or specialising in an area of study.
Every domain will comprise Core courses and Elective courses. Once a learner completes the requisite courses per the mentioned criteria, you will receive a Domain Certificate showcasing your scores and the domain of expertise. Kindly refer to the following link for the list of courses available under each domain: https://nptel.ac.in/noc/Domain/discipline.html
Outside India Candidates
Candidates who are residing outside India may also fill the exam form and pay the fees. Mode of exam and other details will be communicated to you separately.
Thanks & Regards,
Thank you for learning with NPTEL!!
Dear Learner, Thank you for taking the course with NPTEL!! Hope you enjoyed the journey with us. The results for this course have been published and we are closing this course now. You will still have access to the contents and assignments of this course, if you click on the course name from the "Mycourses" tab on swayam.gov.in. The discussion forum is being closed though and you cannot ask questions here. For any further queries please write to [email protected] . - Team NPTEL
Data Base Management System : Results Published !!
- Hard copies of certificates will not be dispatched.
- The duration shown in the certificate will be based on the timeline of offering of the course in 2021, irrespective of which Assignment score that will be considered.
Reminder: Feedback for Data Base Management System
Dear student, We are glad that you have attended the NPTEL online certification course. We hope you found the NPTEL Online course useful and have started using NPTEL extensively. In this regard, we would like to have feedback from you regarding our course and whether there are any improvements, you would like to suggest. We are enclosing an online feedback form and would request you to spare some of your valuable time to input your observations. Your esteemed input will help us in serving you better. The link to give your feedback is: https://docs.google.com/forms/d/1_a3bNLC9BNjx4LL-I1_KAa50WIfTyA56YglH0mnSxkY/viewform We thank you for your valuable time and feedback. Thanks & Regards, -NPTEL Team
Feedback for Data Base Management System
Best of luck for your exam.
Dear Learners,
Best of luck for your examination!
Data Base Management System - Assignment-8 Solution Released
Dear Participants,
The Assignment-8 of Week- 8 Solution for the course Data Base Management System has been released in the portal. Please go through the solution and in case of any doubt post your queries in the forum.
Link: https://drive.google.com/file/d/1MWjN5zLGpkLk6Z9epWDALDjj7wEgWGK3/view
Happy Learning!
Thanks & Regards,
Hall Ticket for September 26,2021 has been released!!
- Please come to the exam centre with the printout of the same hall ticket, along with a valid govt. approved photo id card.
- Please read the instructions that are given on the hall ticket before coming to the exam.
- Requests for changes in exam city, exam center, session, or course will NOT be entertained.
- Please write to [email protected] for any further queries.
Data Base Management System : Video recording on Interactive session 2
There was an interaction session with some of the students for the course Data Base Management System .
The video recording is now available in the portal under the last unit "Live Interactive session"
Those who are interested can take a look.
Youtube link : https://youtu.be/TkZDAW_8xKA
-NPTEL Team
Data Base Management System : Live Interactive session - 2
Dear Learner,
You can interact LIVE with the Course Instructor Prof. Samiran Chattopadhyay , IIT Kharagpur – " Data Base Management System" .
Date: 21 .09.2021
Time: 4 :00 PM
Link to login to: https://youtu.be/TkZDAW_8xKA
Enter your questions you want
You can interact LIVE with the Course Instructor Prof. Samiran Chattopadhyay , to answer at : https://docs.google.com/forms/d/e/1FAIpQLSehgXezHi8euUosaFY_-fXVfryk7GKdOgH0FFtPOvYNyXq9LQ/viewform
You can also ask your doubts during the session through the chat window...
We would also like to hear from you after the session. Request you to share your thoughts in the forum. Learners are encouraged to visit bit.ly/NPTELLIVE
for updates on the live sessions.
Data Base Management System - Assignment-7 Solution Released
The Assignment-7 of Week- 7 Solution for the course Data Base Management System has been released in the portal. Please go through the solution and in case of any doubt post your queries in the forum.
Link: https://drive.google.com/file/d/1_Kk8Q-Otthx0EtLaG6Y8-A-1fLKiNlLV/view
Data Base Management System - Week 8 Feedback Form
Thank you for enrolling to this NPTEL course and we hope you have gone through the contents for this week and also attempted the assignment.
We value your feedback and wish to know how you found the videos and the questions asked - whether they were easy, difficult, as per your expectations, etc
We shall use this to make the course better and we can also know from the feedback which concepts need more explanation, etc.
Please do spare some time to give your feedback - comprises just 5 questions - should not take more than a minute, but makes a lot of difference for us as we know what the Learners feel.
Here is the link to the form: https://docs.google.com/forms/d/e/1FAIpQLScWDg5TzGq43UVGZbbB_pOQk25ZqLcM5RpIcDM2EDtXbr-VNw/viewform
Data Base Management System - Week 8 is live now!!
The lecture videos for Week 8 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=74&lesson=75
The other lectures of this week are accessible from the navigation bar to the left. Please remember to login into the website to view contents (if you aren't logged in already).
Assignment 8 for Week 8 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=74&assessment=113
The assignment has to be submitted on or before Wednesday, [22/09/2021], 23:59 IST.
As we have done so far, please use the discussion forums if you have any questions on this module.
Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately.
Thanks and Regards,
--NPTEL Team
Data Base Management System - Assignment-6 Solution Released
The Assignment-6 of Week- 6 Solution for the course Data Base Management System has been released in the portal. Please go through the solution and in case of any doubt post your queries in the forum.
Link: https://drive.google.com/file/d/1ugE2uvPsw6n9Ro2x4H6O_34wR8-3Dj9J/view?usp=sharing
Data Base Management System - Week 7 Feedback Form
Data base management system - week 7 is live now.
The lecture videos for Week 7 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=66&lesson=67
Assignment 7 for Week 7 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=66&assessment=112
The assignment has to be submitted on or before Wednesday, [15/09/2021], 23:59 IST.
Data Base Management System : Video recording on Interactive session 1
Youtube link : https://youtu.be/qtqmdlHJJ9M
Data Base Management System - Assignments-4 & 5 Solution Released
Dear Participants, The Assignments- 4 & 5 of Week- 4 & 5 Solution for the course " Data Base Management System " have been released in the portal. Please go through the solution and in case of any doubt post your queries in the forum. Link for assignment 4 solution: https://drive.google.com/file/d/1kGvzIbExDhd6S7pOSiLLmn8dEsQcnc4o/view Link for assignment 5 solution: https://drive.google.com/file/d/19_K3XiDDxi85xCKcIfAZAa-V-LvqdCn0/view Happy Learning! Thanks & Regards, NPTEL Team
Data Base Management System - Week 6 Feedback Form
Exam format - sep 26, 2021.
Dear Candidate, ****This is applicable only for the exam registered candidates**** Type of exam will be available in the list: Click Here You will have to appear at the allotted exam center and produce your Hall ticket and Government Photo Identification Card (Example: Driving License, Passport, PAN card, Voter ID, Aadhaar-ID with your Name, date of birth, photograph and signature) for verification and take the exam in person. You can find the final allotted exam center details in the hall ticket. The hall ticket is yet to be released . We will notify the same through email and SMS. Type of exam: Computer based exam (Please check in the above list corresponding to your course name) The questions will be on the computer and the answers will have to be entered on the computer; type of questions may include multiple choice questions, fill in the blanks, essay-type answers, etc. Type of exam: Paper and pen Exam (Please check in the above list corresponding to your course name) The questions will be on the computer. You will have to write your answers on sheets of paper and submit the answer sheets. Papers will be sent to the faculty for evaluation. On-Screen Calculator Demo Link: Kindly use the below link to get an idea of how the On-screen calculator will work during the exam. https://tcsion.com/ OnlineAssessment/ ScientificCalculator/ Calculator.html NOTE: Physical calculators are not allowed inside the exam hall. -NPTEL Team
Data Base Management System - Assignments-1 & 2 Solution Released
Dear Participants, The Assignments- 1 & 2 of Week- 1 & 2 Solution for the course " Data Base Management System " have been released in the portal. Please go through the solution and in case of any doubt post your queries in the forum. Link for assignment 1 solution: https://drive.google.com/file/d/1EIqZ6ELms55riIyw0IWqR761PaEhlSdY/view Link for assignment 2 solution: https://drive.google.com/file/d/1FLKdrldIcLLMcTXuKqAa2oDiQOuIqU-j/view Happy Learning! Thanks & Regards, NPTEL Team
Data Base Management System : Live Interactive session - 1
Date: 30 .08.2021
Link to login to: https://youtu.be/qtqmdlHJJ9M
You can interact LIVE with the Course Instructor Prof. Samiran Chattopadhyay , to answer at : https://docs.google.com/forms/d/e/1FAIpQLSf9NDEEFFc_WeIra8s1C7iZWPwYZKdi-72nslZEV1jlh-dCsw/viewform
Today is the last date to register for September 26 exam !!!
Read below for more details: 1. The registration for the certification exam is open only to those learners who have enrolled in the course. 2. If you want to register for the exam for this course, login here using the same email id which you had used to enroll to the course in the Swayam portal. Please note that Assignments submitted through the exam registered email id ALONE will be taken into consideration towards final consolidated score & certification. 3 . Date of exam: September 26, 2021. Certification exam registration URL is: https://examform.nptel.ac. in/ Choose from the Cities where exam will be conducted: Exam cities 4. Last date for exam registration : August 29, 2021, 23:59 PM (Sunday).
Exam fees will be Rs. 1000/- per exam.
(We are not changing it to Rs 1500/- this time due to covid exemption ; it will be Rs 1000/- till August 29,2021)
Data Base Management System - Week 6 is live now!!
The lecture videos for Week 6 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=58&lesson=59
Assignment 6 for Week 6 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=58&assessment=111
The assignment has to be submitted on or before Wednesday, [08/09/2021], 23:59 IST.
Exam Registration for September exams is Extended till Aug 29 - Register Today!!
Read below for more details: 1. The registration for the certification exam is open only to those learners who have enrolled in the course. 2. If you want to register for the exam for this course, login here using the same email id which you had used to enroll to the course in the Swayam portal. Please note that Assignments submitted through the exam registered email id ALONE will be taken into consideration towards final consolidated score & certification. 3 . Date of exam: September 26, 2021. Certification exam registration URL is: https://examform.nptel.ac. in/ Choose from the Cities where exam will be conducted: Exam cities 4. Last date for exam registration extended till : August 29, 2021, 23:59 PM (Sunday). EXAM FEES:
Data Base Management System - Assignment-3 Solution Released
The Assignment-3 of Week- 3 Solution for the course Data Base Management System has been released in the portal. Please go through the solution and in case of any doubt post your queries in the forum.
Link: https://drive.google.com/file/d/15J_VVwuD7-EdSdmUp2EYDbdt8MoWFK93/view
Data Base Management System - Week 5 Feedback Form
Data base management system - week 5 is live now.
The lecture videos for Week 5 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=50&lesson=51
Assignment 5 for Week 5 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=50&assessment=110
The assignment has to be submitted on or before Wednesday, [01/09/2021], 23:59 IST.
Data Base Management System - Week 4 Feedback Form
Exam registration for september exams is extended- register today.
Read below for more details: 1. The registration for the certification exam is open only to those learners who have enrolled in the course. 2. If you want to register for the exam for this course, login here using the same email id which you had used to enroll to the course in the Swayam portal. Please note that Assignments submitted through the exam registered email id ALONE will be taken into consideration towards final consolidated score & certification. 3 . Date of exam: September 26, 2021. Certification exam registration URL is: https://examform.nptel.ac. in/ Choose from the Cities where exam will be conducted: Exam cities 4. Last date for exam registration extended till : August 27, 2021, 5:00 PM (Friday). EXAM FEES:
(We are not changing it to Rs 1500/- this time due to covid exemption ; it will be Rs 1000/- till August 27,2021)
Data Base Management System - Week 4 is live now!!
The lecture videos for Week 4 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=41&lesson=42
Assignment 4 for Week 4 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=41&assessment=109
The assignment has to be submitted on or before Wednesday, [01/09/2021] , 23:59 IST.
Data Base Management System - Week 3 is live now!!
The lecture videos for Week 3 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=33&lesson=34
Assignment 3 for Week 3 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=33&assessment=108
The assignment has to be submitted on or before Wednesday, [25/08/2021] , 23:59 IST.
Data Base Management System - Week 2 is live now!!
The lecture videos for Week 2 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=25&lesson=26
Assignment 2 for Week 2 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=25&assessment=107
The assignment has to be submitted on or before Wednesday, [18/08/2021] , 23:59 IST.
Data Base Management System - Week 1 is live now!!
The lecture videos for Week 1 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=17&lesson=18
Assignment 1 for Week 1 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc21_cs58/unit?unit=17&assessment=106
The due date of Assignment 1 for Week 1 has been extended and it can be submitted on or before Wednesday, 18-08-2021 , 23:59 IST.
Data Base Management System - Week 3 Feedback Form
Data base management system - week 2 feedback form, data base management system - week 1 feedback form, data base management system - assignment-0 solution released.
The Assignment-0 of Week- 0 Solution for the course " Data Base Management System" has been released in the portal. Please go through the solution and in case of any doubt post your queries in the forum.
Link: https://drive.google.com/file/d/1_u3yrGoaDhR8V9jIEjvmG5YokP99Tvn6/view
Data Base Management System - Download video links are available now!!
The download video links for the course Data Base Management System are available now in the course outline. Please check the download video link: https://nptel.ac.in/courses/106/105/106105175/
NPTEL: Exam Registration is open now for July 2021 courses!
April 2021 exams: Due to the continued pandemic situation, April course exams for the Jan - April 2021 semester stand postponed until further notice. We will announce the exam dates once they are confirmed.
July 2021 exams: As per our calendar, the exams for the July 2021 semester are being planned as mentioned in the Timelines document; and so we have opened the exam registration form for the same. As of now, the exam dates stay the same; if there is any change in the future we will announce it.
1. The registration for the certification exam is open only to those learners who have enrolled in the course.
2. If you want to register for the exam for this course, login here using the same email id which you had used to enroll to the course in Swayam portal. Please note that Assignments submitted through the exam registered email id ALONE will be taken into consideration towards final consolidated score & certification.
3 . Date of exam: September 26, 2021
Certification exam registration URL is: https://examform.nptel.ac.in/
Choose from the Cities where exam will be conducted: Exam Cities
4. Exam fees:
If you register for the exam and pay before August 16, 2021, 10:00 AM, Exam fees will be Rs. 1000/- per exam .
If you register for exam before August 16, 2021, 10:00 AM and have not paid or if you register between August 16, 2021, 10:00 AM & August 20, 2021, 5:00 PM, Exam fees will be Rs. 1500/- per exam
5. 50% fee waiver for the following categories:
6. Last date for exam registration: August 20, 2021, 5:00 PM (Friday).
7. Mode of payment: Online payment - debit card/credit card/net banking.
8. HALL TICKET:
9. FOR CANDIDATES WHO WOULD LIKE TO WRITE MORE THAN 1 COURSE EXAM:- you can add or delete courses and pay separately – till the date when the exam form closes. Same day of exam – you can write exams for 2 courses in the 2 sessions. Same exam center will be allocated for both the sessions.
10. Data changes:
Last date for data changes: August 20, 2021, 5:00 PM:
11. LAST DATE FOR CANCELLING EXAMS and getting a refund: August 20, 2021, 5:00 PM
12. Click here to view Timeline and Guideline : Guideline
NPTEL TEAM.
Data Base Management System - Assignment-0-RELEASED
We welcome you all to this course. The assignment 0 for the course Data Base Management System has been released. This assignment is based on a prerequisite of the course. Kindly note that marks obtained in this assignment will not be considered for the final assessment. You can find the assignment under Week 0 unit on the left-hand side of your screen You can submit the assignment multiple times before the due date. All the best !!
The due date of Assignment 0 is on or before 26-07-2021 , 23:59 IST.
Welcome to NPTEL Online Course - July 2021!!
- Every week, about 2.5 to 4 hours of videos containing content by the Course instructor will be released along with an assignment based on this. Please watch the lectures, follow the course regularly and submit all assessments and assignments before the due date. Your regular participation is vital for learning and doing well in the course. This will be done week on week through the duration of the course.
- Please do the assignments yourself and even if you take help, kindly try to learn from it. These assignments will help you prepare for the final exams. Plagiarism and violating the Honor code will be taken very seriously if detected during the submission of assignments.
- The announcement group - will only have messages from course instructors and teaching assistants - regarding the lessons, assignments, exam registration, hall tickets etc.
- The discussion forum (Ask a question tab on the portal) - is for everyone to ask questions and interact.Anyone who knows the answers can reply to anyone's post and the course instructor/TA will also respond to your queries.
- Please make maximum use of this feature as this will help you learn much better.
- If you have any questions regarding the exam, registration, hall tickets, results, queries related to the technical content in the lectures, any doubts in the assignments, etc can be posted in the forum section
- The course is free to enroll and learn from. But if you want a certificate, you have to register and write the proctored exam conducted by us in person at any of the designated exam centres.
- The exam is optional for a fee of Rs 1000/- (Rupees one thousand only).
- Date and Time of Exams: 26 September 2021 Morning session 9am to 12 noon; Afternoon Session 2pm to 5pm.
- Registration url: Announcements will be made when the registration form is open for registrations.
- The online registration form has to be filled and the certification exam fee needs to be paid. More details will be made available when the exam registration form is published. If there are any changes, it will be mentioned then.
- Please check the form for more details on the cities where the exams will be held, the conditions you agree to when you fill the form etc.
- Once again, thanks for your interest in our online courses and certification. Happy learning.
A project of
In association with
NPTEL Info Base Management System Assignment 1 Answers 2023
NPTEL Data Base Managerial System Assignment 1 Answers: 2023 – All who Response submitted down to help who collegiate as a reference, You must submit your subscription at your own understanding.
NPTEL Data Rear Management System Week 1 Assignment Finding 2023
1. Which of the following statements is (are) correct?
- a) Phsical level abstraction describes select a record is stored.
- b) View level accuracy hides details of data types.
- c) Physical level abstraction describ e s data stored inches ampere database and their relationships.
- d) Logical level abstraction establishes the physical schema.
2. Consider the following relations:
Subject (sid, sn a me, credit) Faculty (fid, sid) Which of the following is correct?
- a) RA 1 C RAz
- b) RAg C RAg
- c) RAI C RA g
- d) RA1 = Taunt
3. What shall the following Relational Algebra expression returnable?
- a) All heights except the maximum heights off Mountain relation.
- b) All heights besides the minimum height since Mountain relation.
- c) Minimum high from Mountain relation.
- d) Maximum height from Mountain relation.
4. Consider one relational schema PhoneBook (Name, PhoneNo, Location, LastCalled)
- Ankit 3222265783 Cube 15 In l
- Shreya 3222265783 Dharamsala 16 Jul
- Ankit 2222586110 Delhi 16 Jul
- Shreya 2222586110 THOUSAND olkata 15 Jul
5. Study the connection Flight (FlightNo, Source, Destination, Duration) where {FlightNo} and {Source, Destination, Duration} are the 2 candidate keys. What is the possible num- ber of superke y s of Flight?
6. Consider a truth table having the following columns P Q R= ((P FIVE Q) – -P) S= ( (P V Q) – P) If the veracity table, with all one values, is represented while a relational instance, which column(s) (attribute(s)) should live chosen as candidate keys?
7. Consider the following instance for ChatBox (SenderID, ReceiverID).
8. Consider the following table:
9. Take the following table:
10. Which for the following can be a candidate k east year for who following instance?
About Data Mean Management System
Databases form the backbone of all major applications today – tightly or loosely coupled, intranet button internet based, financial, social, administrative, and so set. Structured Database Management Systems (DBMS) based on relational and different patterns need prolonged formed the basis since such databases. Consequently, Orphan, Microsoft SQL Host, Sybase etc. have emerged as leading commercial systems when MySQL, PostgreSQL etc. lead in open source press free region. CRITERIA TO GET A CERTIFICATE Average assignation score = 25% regarding average of best 6 assignments output of the total 8 assignments given in which course. Final score = 75% of the proctored certification exam score go of 100 Final notch = Avg assignment score + Exam note YOU WILL BE ELIGIBLE FOR A CERTIFIED ONLY IF AVERAGE ASSIGN SCORE >=10/25 PLUS EXAM SCORE >= 30/75. If one of the 2 criteria is no met, you will nope get the certificate even whenever the Final score >= 40/100. You can find Product Baseline Management System Assignment 1 Answers below.
NPTEL Data Base Management System Assignment 1 Answers July 2022
1. Identify the correct statement (s).
2. A relation R had 2 candidate keys withl and 2 attributes respectively. There are 40 super keys of R. Something is the total number of attributes includes ROENTGEN? a) 3 b) 4 c) 5 d) 6
Answers willingness be Uploaded Briefly press it will be Notified on Telegram, So JOIN NOW
3. Which of the following relational operations willing manufacturing the following tuple only? a) (QB1 U QB2) x (QB2 UPPER-CLASS QB1) b) (QB1-QB2) nitrogen (QB2 QB1) c) (QB1 QB2) x (QB2 QB1) d) (QB1 n QB2) – (QB2 n QB1)
4. Which of the following will a Secondary Key in CelestialReport? a) {ReportBy, ReportScore}. b) {ReportBy, GroupLead}. c) {CroupLead, Celestial0bject}. d) {ReportScore, GroupLead}
5. Check who following relational schema for an university: student (roll.no, name, dob) division (deptNo, dName, location) project (proj-no, deptNo, rOllno, pName) About is the type of the key(s) that will be used to uniquely identify an entity of the project relation? a) simple key b) Alternate Key C)Composite Key d) Compound key
6. ldentity the correct relational algebraic expression forward the following search: Find that names a scholars uho have selected anywhere design offered by the department “CSE”. a) ||name ( (student a project) bM lHdeptNo dName= “CSE” (dept) )) b) ||name (aName=” “CSE” (dept project)) ) c) ||name (o dName=* “CSE” (student ba dept) ba (project) ) d) ||name (student ba (aName= “CSE” (project) ))
👇 By Week 02 Assignment Answers 👇
7. ldentify the correct operation(s) which will hervorzubringen the following output from the above two relations. a) R1 R2 b) R2- -R1 c) (R1 UR2) n (Ri n Ra) d) (R1-R2) U (Ra- R)
8. ldentity the right operation(s) which produces one following output from the over relation. a) ||(YEAR_PUB=2010) five (TOTAL SOLD_COPIES >15000) (BookDetalls) b) ||YEARPUB=2010) A (TOTAL.SOLD.cOPIES > 15000) (BookDetails) c) (YEAR_PUB=2010) phoebe (TOTAL SOLD COPIES > 15000) (BookDetails) d) (YEARPUB=2010) (TOTAL SOLD.COPIES > 15000) (BookDetails)
9. Consider the following instannce:
10. This of the follow-up can be a candidate key for the later instance? a) (BOOKID, YEAR PUB} b) {BOOK_ID, BOOK TITLE} c) {BOOKTITLE, AUTHOR NAME} d) {B0OK_ID}
NPTEL Data Mean Management System Assignment 1 Answers 2022: Choose the Answers when below to help to students as a reference, You must submit your assignation at your own knowledge.
For More NPTEL Answers:- CLICK HERE Get Our Telegram:- CLICK HER
NPTEL Data Base Management System Assignment 1 Answers Jan 2022
Q1. Identify the correct statement(s) from the following.
a) The overall physical setup of the database is calls physical schema. b) The real content of the database by a particular point in period is mentioned an instance. c) Data dictionary does not contain random databank schema. d) Bodily schema narrates how intelligence is stored in the database and of relationships among who data.
Answer:- (A), (B)
Q2. Remember the tracking instance:
Identify this correct representation of MLDatabase schema.
a) MLDatabase (Model, Accuracy. Dataset, TrainingData). b) MLDatabase (Model, Accuracy, Datanet, TrainingData). c) MLDatabase (Model, Accuracy, Dataset, TrainingData). d) MLDatabase (Model, Accuracy, Dataset, TrainingData). Dates Base Management Systems Week 1 Assignment 1 | Jan-Apr ...
Answer:- (A)
Q3. Identify the incorrect statement(s).
a) A Super Key is a set of one or more attributes that, accepted collectively, allows us to uniquely identify an entity in the unit firm. b) AMPERE proper subsets of a candidate key is rang a Super Key. c) The minor set about merkmale that allows us to uniquely identify an entity in the item set is called a nominee key. d) A proper subgroup of a Super Key shall not always a Job Select.
Answer:- (B)
Q4. Consider two relations below. The primary keys are underlined. Identify all possible foreign key (s) from the options. Employee (EmpID, Enano, Salary) find EmpID is from make integer, Ename is of type contents. and Salary is of type decimal number. Project (EmpID, Pnumber) where ExpID is of enter integer, and Pnumber lives of type string.
a) Ename b) EmpID c) Paunber d) EmpID, Pnumber
Q5. Consider the following instancing of ImageRec (31. DepthImage, Coordi, Coord2))
Whatever of the following is a Secondary Key is InageRec?
a) (S1. Depth Image). b) (Coord1, Coord2). c) (Coord2, DepthImage). d) (Coord1. DepthImage).
Answer:- (C)
Q6. Consider the following instances:
How many tuples will be selected by aplayer=Gamer (Game1 expunge Game2) ?
a) 3 b) 4 c) 8 d) 9
Q7. Consider the two tables given under.
Name the correct statement from the following.
a) Cartesian choose of Student and Your has six tuples b) Cartesian product about Student and Teacher the not feasible. c) Go will be three tuples included aforementioned result of the natural join among Students and Teacher. d) Natural Join between Student and Teacher is not possible. Data Base Management System Week 7 Assignment Fill || Jan 2024 || NPTEL 1. Join telegram Gutter -- https://t.me/doubttown Welcome to ...
Answer:- (D)
Q8. Consider that tracking table:
Identify the correct operation(s) which produces the following output upon the higher relation.
a) DOUBLE (Branch-Address) (Salary>10000) (EmployeeDetails) b) IIS (Branch-Address) v (Salary>10000) (EmployeeDetails) c) (Branch-Address) (Salary>10000) (EmployeeDetails) d) (Branch-Address) v (Salary>10000) (EmployeeDetails) Session: JAN-APR 2024
Q9. Consider the later tables:
Identify of correct operation(s) which will produce the following output from the above two relations.
a) R₁-R₂ b) R 2 -R 1 c) (R 1 UR₂) ∩ (R 1 ∩R₂) d) (R 1 -R₂) UPPER (R₂-R₁)
Q10. Which of the following can be a candidate push for the following instance?
a) {EmpName} b) (Branch) c) (EmpName, Address) d) (Emplame, Branch)
Answer:-(D)
READ IT ALSO:-
NPTEL English Literature for competitive trials Mission 1 Answers
NPTEL Data Analytics with Python Assignment 1 Answers 2022
NPTEL Begin To Internet Regarding Things Assignment 1 Answers
NPTEL Cloud Computing Week 1 Assignment Returns 2022
NPTEL Python for Data Physics Assignment 1 Answers 2022
NPTEL The Joy of Computing using Python Assignment 1 Answers
NPTEL English Literature required competitive exams Assignment 1 Answers
NPTEL Datas Analytics with Python Assignment 1 Answers 2022
NPTEL Introduction To Internet Of Things Assignment 1 Answers
NPTEL Cloud Computing Per 1 Assignments Answers 2022
NPTEL Data Base Management System Assignment 1 Answers:- All the Answers provided below to help the student as adenine reference, You must submit your assignment at your our knowledge.
Leave a Commentary Cancel reply
You must may recording in to post a observation.
You must be chronicled in to post one comment.
IMAGES
VIDEO
COMMENTS
#DBMS,#NPTEL,#swayam,#NPTEL_AnswersIn this video I have discussed about the solution of week 4 assignment 4 of database management system for the July 2022 s...
Databases form the backbone of all major applications today - tightly or loosely coupled, intranet or internet based, financial, social, administrative, and ...
Databases form the backbone of all major applications today - tightly or loosely coupled, intranet or internet based, financial, social, administrative, and ...
The questions will be on the computer and the answers will have to be entered on the computer; type of questions may include multiple choice questions, fill in the blanks, essay-type answers, etc. ... Data Base Management System - Assignment-4 Solution Released ... Here is the much-awaited announcement on registering for the Jan 2022 NPTEL ...
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 ...
noc19 cs46 assignment Week 4. swayam NPTEL » Database Management System Unit 6 - Week 4 Announcements About the Course [email protected] Mentor Ask a Question Progress Course outline How to access the portal Week O : Assignment week 1 week 2 week 3 week 4 Lecture 16 : Relational Database Design 11 Lecture 17 Relational Database Design ...
Data Base Management System. ABOUT THE COURSE : 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.
This set of MCQ (multiple choice questions) focuses on the Data Base Management System NPTEL 2023 Week 4 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 ...
Leave a Comment / NPTEL assignment solutions. This set of MCQ (multiple choice questions) focuses on the Data Base Management System NPTEL 2022 Week 0 Assignment Solutions. Databases form the backbone of all major applications today - tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on.
As per our records you have not submitted this assignment. 1) Storing data and meta-data separately makes RDBMS general-purpose and flexible. True False No, the answer is incorrect. Score: 0 Accepted Answers: 2) "Data Model" is nothing but a data structure where data is stored. True False No, the answer is incorrect.
Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases...
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 ...
The questions will be on the computer and the answers will have to be entered on the computer; type of questions may include multiple choice questions, fill in the blanks, essay-type answers, etc. ... Data Base Management System - Assignment-4 Solution Released ... Here is the much-awaited announcement on registering for the July 2022 NPTEL ...
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 ...
Data Base Management System NPTEL 2022 Week 1 Assignment Solutions. Q1. Identify the correct statement (s) from the following. a) The overall physical structure of the database is called physical schema. b) The actual content of the database at a particular point in time is called an instance. c) Data dictionary does not contain any database ...
Database Management System: Assignment 1. Total Marks : 20. June 7, 2022 Question 1. Consider the following table: student student roll name dept code dept name project group CS121 Rohit D01 CSE Image Processing CS432 Sidra D03 IT Computer Architecture CS432 Sidra D03 IT Ethical Hacking CS133 Reeta D02 ECE Signal Processing CS133 Reeta D02 ECE Image Processing EE134 Rina D04 EE Image Processing
Nptel july-2022 || Database Management System week 4 assignment answers
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.
To associate your repository with the nptel-solutions topic, visit your repo's landing page and select "manage topics." GitHub is where people build software. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects.
NPTEL Data Base Management System Assignment 1 Answers Jan 2022. Q1. Identify the correct statement (s) from the following. a) The overall physical structure of the database is called physical schema. b) The actual content of the database at a particular point in time is called an instance. c) Data dictionary does not contain any database ...
Week 1: Course Overview. Introduction to RDBMSWeek 2: Structured Query Language (SQL)Week 3: Relational Algebra. Entity-Relationship Model Week 4: Relational Database DesignWeek 5: Application Development. Case Studies. Storage and File StructureWeek 6: Indexing and Hashing.
This course is being reoffered in July 2022 and we are giving you another chance to write the exam in October 2022 and obtain a certificate based on NPTEL norms. Do not let go of this unique opportunity to earn a certificate from the IITs/IISc. ... Data Base Management System - Week 4 Feedback Form ... Data Base Management System - Assignment-0 ...
NPTEL Data Mean Management System Appointment 1 Claims: 2022 - All the Answers provided below to helping the students as a reference, You must submit your assignment at your own know. About Data Base Management Systems. Databases form the backbone of all major software right - tightly conversely loosely coupled, intranet either internet based, financial, public, administrative, furthermore ...