Hello Learners, In this Post, you will find NPTEL Data Base Management System Assignment 1 Answers 2023. All the Answers are provided below to help the students as a reference don’t straight away look for the solutions.
NPTEL Data Base Management System Assignment 2 Answers Join Group👇
Note: First try to solve the questions by yourself. If you find any difficulty, then look for the solutions.
| COURSE NAME | ANSWER |
| NPTEL Data Base Management System Assignment 1 Answers | Click Here |
| NPTEL Data Base Management System Assignment 2 Answers | Click Here |
| NPTEL Data Base Management System Assignment 3 Answers | Click Here |
| NPTEL Data Base Management System Assignment 4 Answers | Click Here |
| NPTEL Data Base Management System Assignment 5 Answers | Click Here |
| NPTEL Data Base Management System Assignment 6 Answers | Click Here |
| NPTEL Data Base Management System Assignment 7 Answers | Click Here |
| NPTEL Data Base Management System Assignment 8 Answers | Click Here |
NPTEL Data Base Management System Assignment 1 Answers 2023:
We are updating answers soon Join Group for update: CLICK HERE
Q.1. Which level of abstraction describes types of data that are stored in the Database?
Q.2. Identify the valid primary key for the relation paper_info from the given instance.
- a) paper_id
- b) paper_id, corresponding Author
- c) conference_id, corresponding_Author
- d) paper_id, conference_id
Q.3. Identify the correct statement/s.
- a) Project (pCode, pName) is an instance of a relation schema.
- b) Project (pCode, pName) is an example of a physical schema.
- c) (2245, HardFort) is an instance of a relation schema.
- d) (2245, HardFort) is an example of a logical schema.
NPTEL Data Base Management System Assignment 2 Answers Join Group👇
Q.4. Consider a relation Vehicle (VID, Model, Speed, Color) where the superkeys are as follows: {VID}, {VID, Model}, {Speed, Color}, {Speed, Color, Model}. Select the possible candidate key(s).
- a) {VID}
- b) {Speed}
- c) {Color}
- d) {Speed, Color}
Q.5. Consider the following relations:
Book (ISBN, Title, Pages)
BookGenre (ISBN, Genre)
What does the following relational algebra expression represent? IIISBN((Pages>100 Book) (Genre-Fiction/BookGenre))
- a) Find the ISBN of all Book with more than 100 Pages.
- b) Find the ISBN of all Book with more than 100 Pages or are of Genre ‘Fiction’.
- c) Find the ISBN of all Book with more than 100 Pages but are not of Genre ‘Fiction’.
- d) Find the ISBN of all Book with more than 100 Pages and are of Genre ‘Fiction’
Q.6. Consider the following relational schema: ImageCode (ImageID, Name) ImageBook (BookID, Image ID, Page) What will be the Relational Algebra equivalent to the following statement? “Find the names of all Images on Page 100.”
- a) Name (ImageCode Page=100 (ImageBook)) X
- b) Name (Ipage=100 (ImageCode) ImageBook)
- c) IIName(IIpage=100 (ImageCode) ▷ ImageBook)
- d) IIName (Image Code Page=100 (ImageBook))
Q.7. Consider the following tables:
Which of the following operations will return S1 itself?
- a) S2-(S2-S1)
- b) S1-(S2-S1)
- c) S1-(S1-S2)
- d) S2-(S1-S2)
NPTEL Data Base Management System Week 1 Answers Join Group👇
CLICK HERE
Q.8. Consider the following tables:
Identify the correct operation(s) which will be produce the following output from the above relations.
- a) (#Faculties>=20000) (UniversitiesDetails)
- b) (#Faculties>20000) (Universities Details)
- c) IIStateName, #State Universities, #Faculties (#Faculties>=20000) (Universities Details)
- d) IlStateName, #State Universities, #Faculties (#Faculties> 20000) (UniversitiesDetails)
Q.9. Consider the following tables:
Identify the correct operation(s) which will be produce the following output from the above two relations.
- a) Details Details2
- b) Details – Details₁
- c) (Details₁ U Details ₂) n (Details₁ Details₂)
- d) (Details1 Details2) U (Details2 – Details 1)
Q.10. Which of the following can be a candidate key for the following instance?
- a) {StateName}
- b) {#State Universities}
- c) {#Faculties}
- d) {StateName, #Central Universities, #State Universities}
NPTEL Data Base Management System Assignment 1 Answers Join Group👇
Disclaimer: This answer is provided by us only for discussion purpose if any answer will be getting wrong don’t blame us. If any doubt or suggestions regarding any question kindly comment. The solution is provided by Brokenprogrammers. This tutorial is only for Discussion and Learning purpose.
About NPTEL Data Base Management System 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. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain.
Course Layout:
- 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.
CRITERIA TO GET A CERTIFICATE:
Average assignment score = 25% of average of best 8 assignments out of the total 12 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.
If you have not registered for exam kindly register Through https://examform.nptel.ac.in/
