Are you looking for the Answers to NPTEL Data Base Management System Assignment 1 – IIT Delhi? This article will help you with the answer to the National Programme on Technology Enhanced Learning (NPTEL) Course “ Data Base Management System Assignment 1 “
What is 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.
While DBMS’s differ in the details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course examines data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation.
CRITERIA TO GET A CERTIFICATE
Average assignment score = 25% of the 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 THE 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.
Below you can find the answers for Data Base Management System Assignment 1
Data Base Management System Assignment 1 Answers:-
Q1. Identify the correct statement(s) from the following.
Answer:- a,b
Q2. Consider the following instance:
Answer:- a
Q3. Identify the incorrect statement(s).
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.
Answer:- b
???? Next Week Answers: Assignment 02 ????
Q5. Consider the following instance of ImageRec (31. DepthImage, Coordi, Coord2))
Answer:- c
Q6. Consider the following instances:
Answer:- b
Q7. Consider the two tables given below.
Answer:- d
Q8. Consider the following table:
Answer:- c
Q9. Consider the following tables:
Answer:- c
Q10. Which of the following can be a candidate key for the following instance?
Answer:- d
For other courses answers:- Visit
For Internship and job updates:- Visit
