MCS 207 Solved Assignment 2021-22
Course Code : MCS 207
Course Title : Database Management Systems
Assignment Number : PGDCA(2)/207/Assignment/2021-22
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th
November, 2021 (for July session)
MCS
207 Solved Assignment 2021-22 : All assignments are in PDF format which would
be send on email/WhatsApp (9958676204) just after payment.
There are four questions in this assignment, which
carries 80 marks. Rest 20 marks are for viva voce. You may use illustrations
and diagrams to enhance the explanations. Please go through the guidelines
regarding assignments given in the Programme Guide for the format of
presentation. Answer to each part of the question should be confined to about
300 words. Make suitable assumption, if any.
Question 1:
20
(a) Explain the three level DBMS architecture with the
help of an example. What is data independence? How can it be related to the
three-level architecture?
(b) Explain the different types of constraints that can
be defined in a relational database system with the help of examples. Why these
constraints should be defined in a database system?
(c) What is a transaction? What are the problems of
concurrent transactions? Explain with the help of examples.
(d) What is locking? Explain with the help of examples,
how locking solves the problems relating to concurrent execution of
transactions.
(e) Explain the concept of database recovery with the
help of an example. Also, explain the concept of query optimisation with the
help of an example.
Question 2:
20
A Medicine Store needs to maintain a database system
for maintaining its inventory of items. The database is needed for the
following requirements:
· To find
the medicine name, medicine code, date of manufacture, date of expiry, present
stock of medicine etc.
· To find
the information about various suppliers of different medicines. A suppliermay
not supply all the medicines. Some of the information that is needed about
supplier is: the Supplier Code, supplier name, address, the medicines that can
be supplied by the supplier etc.
· To find
the information of various purchase orders of medicines purchase from various
suppliers. Please note that one purchase order may include several medicines.
· To keep
track of current stock of medicines, the quantity of medicines received and
sold etc.
(a) Draw an ER diagram for the departmental store.
Specify key attributes and constraints of each entity type and on each
relationship type. Note any unspecified requirements, and make appropriate
assumptions to make the specification complete.
(b) Design normalized tables in 3NFfrom the ER diagram
drawn in part (a), with the required integrity constraints.
Question 3
20
Consider a “Software Management System” that maintains
the database using the following tables:
Project (p-id, p-title, start-date, duration,
proj-cost, c-id)
Clients (c-id, c-name, c-address, c-phone)
Employee (e-id, e-name, e-address, e-phone)
Project-person (p-id, e-id)
Please note that an employee may be working on more
than one projects in the organization at a time. Write and run the following
SQL queries on the tables:
a. Find the c-id and c-name of the clients who have
given the project with maximum project cost.
b. List the employee id and name of all the employees
and the project titles on which they have worked from time to time.
c. Find the list of employees who are working on at
least two projects.
d. Find the names of all those employees who have
worked on all the projects of client whose cname is “XYZ”.
e. Find the projects which have been completed between
31st Dec, 2020 and 31st Dec. 2021
f. Find the employees who are NOT working on any
project.
g. List the project titles along with their p_id in the
order of project cost.
h. List the Client details of the clients who have
given a project after 31st Dec, 2021.
i. List the pairs of p-id’s of the employees, who are
working on the same project.
j. List all the employees whose name starts with
alphabet ‘S’.
Note: Make suitable assumptions, if any.
Question 4:
20
(a) Consider the Relation R={A, B, C, D, E, F} and the
set of functional dependencies.
A→ BC B→E
C→DF
What is the key of R? Decompose R into 2NF and 3NF
relations.
(b) Differentiate between the following:
i. Object oriented database management systems and
relational database management system
ii. Data mining and data warehousing
iii. NOSQL database and relational databases
MCS 207 Solved Assignment 2021-22, MCS 207 Solved
Assignment 2021-22, MCS 207 Solved Assignment 2021-22, MCS 207
Assignment, IGNOU Assignment MCS 207 2021-22- Gandhi National
Open University had recently uploaded the assignments of the present
session for Programme for the year 2021-22. MCS 207 Solved Assignment 2021-22
Students are recommended to download their Assignments from this web page itself.
They don’t got to go anywhere else when everything regarding the Assignments
are available during this article only.
MCS
207 Solved Assignment 2021-22 : All assignments are in PDF format which would
be send on email/WhatsApp (9958676204) just after payment.
For Students - MCS 207 Solved Assignment 2021-22
Students are advised that after successfully downloading their Assignments,
you'll find each and each course assignments of your downloaded Programme. MCS
207 Solved Assignment 2021-22 Candidates need to create separate assignment for
the IGNOU Master Course, in order that it's easy for Evaluators to see your
assignments.
IGNOU Assignment Status 2021-22
MCS 207 Solved Assignment 2021-22 Those students who
had successfully submitted their Assignments to their allocated study centres
can now check their Assignment Status. MCS 207 Solved Assignment 2021-22
Alongside assignment status, they will also checkout their assignment marks
& result. All this is often available in a web mode. MCS 207 Solved Assignment
2021-22 after submitting the assignment, you'll check you
IGNOU Assignment Status only after 3-4 weeks. it'd take 40 days to
declare.
MCS 207 Solved Assignment 2021-22 once the TEE
assignments are submitted to the Centres, it's send to the evaluation
department. After which the evaluation of IGNOU Assignment Solutions takes
place.
Related Links :
MCS 206 Solved Assignment 2021-22
MSD 016 Solved Assignment 2021-22
MDCE 006 Solved Assignment 2021-22
MSD 015 Solved Assignment 2021-22
MCS 207 Solved Assignment 2021-22 :- Those
students who had successfully submitted their Assignments to their allocated
study centers can now check their Assignment Status. Alongside --assignment
status, they will also checkout their assignment marks & result. All this
is often available in a web mode. After submitting the assignment, you'll check
you MCS 207 Solved Assignment 2021-22 only after 3-4 weeks. MCS 207 Solved
Assignment 2021-22 it'd take 40 days to declare MCS 207 Solved Assignment
2021-22
For IGNOU Solved Assignment PDF & Hand Written
Subscribe YouTube : My IGNOU Solutions
WhatsApp Contact : 9958676204
