#1 Best Selling IGNOU Assignments in All Available in Market
Bought By: 5588 Students
Rating: 4.1
Get IGNOU MCS-23 Assignments Soft Copy ready for Download in PDF for (July 2024 - January 2025) in English Language.
Are you looking to download a PDF soft copy of the Solved Assignment MCS-23 - Introduction to Database Management Systems? Then GullyBaba is the right place for you. We have the Assignment available in English language.
This particular Assignment references the syllabus chosen for the subject of Computer Application, for the July 2024 - January 2025 session. The code for the assignment is MCS-23 and it is often used by students who are enrolled in the MCA, BCA Degree.
Once students have paid for the Assignment, they can Instantly Download to their PC, Laptop or Mobile Devices in soft copy as a PDF format. After studying the contents of this Assignment, students will have a better grasp of the subject and will be able to prepare for their upcoming tests.
Q1: a) Give the limitations of file based system. How can they be overcome using DBMS?
b) Discuss the 3-level architecture of DBMS. Explain how it leads to data independence.
c) What are integrity constraints? Discuss the various types of integrity constraints that can be imposed on database.
d) What is the two phase locking protocol? How does it guarantee Serializability? Explain.
e) Discuss the anomalies due to insertion, updation and deletion in a relation that is not in QNF. Illustrate with the help of an example.f) List and explain the 4 basic properties of a Transaction with the help of appropriate examples.
g) Explain the Log-based recovery scheme with the help of an example.
h) Explain the need of Distributed DBMS over Centralized DBMS. Also give the structure of Distributed DBMS.
i) Write SQL commands for each of the following. Also illustrate the usage of each command through suitable example.
(i) Creation of views
(ii) Creation of sequences
(iii) Outer join
(iv) To give access permission to any user
Q2: A bookshop has a huge collection of books to sell them online and therefore requires a database to track its sales. For each book they store the Title, Author(s), name, Publisher, Volume, ISBN No., Price, Stock (no. of copies), Year of publication, etc. To help the customers to search the book, they require that each book is assigned to one or more categories such as Engineering, Sciences, Fiction, Literature, Applications, etc. If at all, any discounts that are there for certain books, need to be notified on the site (best-buy offer). To buy a book, a customer needs to register on the site. Also it maintains the profile of the user and also their earlier purchases. The bookshop also sends "Newsletter" to all the registered users to update them about the publications.
Identify the entities, relationships, constraints and cardinality and construct an ER diagram for the above mentioned specifications. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram.
Q3: Consider the following tables:
WORKS(Pname, Cname, Salary)
LIVES(Pname, Street, City)
LOCATED(Cname, City)
MANAGER(Pname, Mname)
Write a query in SQL for the following:
(i) List the names of the people who work for the company Wipro' along with the cities they live in.
(ii) Find the people who work for the company `Infosys' having salary greater than 50,000.
(iii)List the names of the people, along with the street and city addresses.
(iv) Find the persons whose salaries are more than that of all of the 'Oracle' employees.
(v) Find the names of the persons who do not work in `Infosys'.
Make suitable assumptions, if any.
Q4: (a) Compute the closure of the following set F of functional dependencies for relation schema
R = (A, B, C, D, E).
A → BC
CD → E
B → D
E → A
List the candidate keys for R.
(b) Consider the relation R (A, B, C, D, E) and the set of functional dependencies :-
F(A → D, {A,B} → C, D → E)
Assume that the decomposition of R into {R1 (A, B, C) and R2 (A, D, E)}.
Is this decomposition lossless? Justify?
Q1:
a) Give the limitations of file based system. How can they be overcome using DBMS?
b) Discuss the 3-level architecture of DBMS. Explain how it leads to data independence.
c) What are integrity constraints? Discuss the various types of integrity constraints that can be imposed on database.
d) What is the two phase locking protocol? How does it guarantee Serializability? Explain.
e) Discuss the anomalies due to insertion, updation and deletion in a relation that is not in QNF. Illustrate with the help of an example.
f) List and explain the 4 basic properties of a Transaction with the help of appropriate examples.
g) Explain the Log-based recovery scheme with the help of an example.
h) Explain the need of Distributed DBMS over Centralized DBMS. Also give the structure of Distributed DBMS.
i) Write SQL commands for each of the following. Also illustrate the usage of each command through suitable example.
(i) Creation of views
(ii) Creation of sequences
(iii) Outer join
(iv) To give access permission to any user
Q2:
A bookshop has a huge collection of books to sell them online and therefore requires a database to track its sales. For each book they store the Title, Author(s), name, Publisher, Volume, ISBN No., Price, Stock (no. of copies), Year of publication, etc. To help the customers to search the book, they require that each book is assigned to one or more categories such as Engineering, Sciences, Fiction, Literature, Applications, etc. If at all, any discounts that are there for certain books, need to be notified on the site (best-buy offer). To buy a book, a customer needs to register on the site. Also it maintains the profile of the user and also their earlier purchases. The bookshop also sends "Newsletter" to all the registered users to update them about the publications.
Identify the entities, relationships, constraints and cardinality and construct an ER diagram for the above mentioned specifications. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram.
Q3:
Consider the following tables:
WORKS(Pname, Cname, Salary)
LIVES(Pname, Street, City)
LOCATED(Cname, City)
MANAGER(Pname, Mname)
Write a query in SQL for the following:
(i) List the names of the people who work for the company Wipro' along with the cities they live in.
(ii) Find the people who work for the company `Infosys' having salary greater than 50,000.
(iii)List the names of the people, along with the street and city addresses.
(iv) Find the persons whose salaries are more than that of all of the 'Oracle' employees.
(v) Find the names of the persons who do not work in `Infosys'.
Make suitable assumptions, if any.
Q4:
(a) Compute the closure of the following set F of functional dependencies for relation schema
R = (A, B, C, D, E).
A → BC
CD → E
B → D
E → A
List the candidate keys for R.
(b) Consider the relation R (A, B, C, D, E) and the set of functional dependencies :-
F(A → D, {A,B} → C, D → E)
Assume that the decomposition of R into {R1 (A, B, C) and R2 (A, D, E)}.
Is this decomposition lossless? Justify?
The IGNOU open learning format requires students to submit study Assignments. Here is the final end date of the submission of this particular assignment according to the university calendar.
Here are the PDF files that you can Download for this Assignment. You can pick the language of your choice and see other relevant information such as the Session, File Size and Format.
In this section you can find other relevant information related to the Assignment you are looking at. It will give you an idea of what to expect when downloading a PDF soft copy from GullyBaba.
In addition to this Assignment, there are also other Assignments related to the BCA Computer Application you are preparing for. Here we have listed other Assignments that were bought along with this one.