MCS 207 Solved Assignment 2021-22

 

MCS 207 Solved Assignment 2021-22

Database Management Systems

MCS 207 Solved Assignment 2021-22 : All assignments are in PDF format which would be send on email/WhatsApp (9958676204) just after payment.

Course Code : MCS 207

Course Title : Database Management Systems

Assignment Number : PGDCA(2)/207/Assignment/2021-22

Maximum Marks : 100

Weightage : 25%

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

AMedicine 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

Related Links :

MCS 206 Solved Assignment 2021-22

BPVI 004 Solved Assignment 2021-22

MCSL 025 Solved Assignment 2021-22

BPVI 003 Solved Assignment 2021-22

MCS 207 Solved Assignment 2021-22 : All assignments are in PDF format which would be send on email/WhatsApp (9958676204) just after payment.

POST GRADUATE DIPLOMA IN AUDIO PROGRAMME PRODUCTION P.G. Diploma Programmes (PGDCA) ASSIGNMENTS

Dear Learner,

You have to submit one assignment in each course, i.e. MCS 207, MCS 207 and MCS 208. All these are Tutor Marked Assignments (TMAs). Before attempting the assignments, please read the instructions provided in the Programme Guide carefully.

Kindly note, you have to submit these assignments to the Coordinator of your Study Centre within the stipulated time for being eligible to appear in the term-end examination. You must mention your Enrolment Number, Name, Address, Assignment Code and Study Centre Code on the first page of the assignment. You must obtain a receipt from the Study Centre for the assignments submitted and retain it. Keep photocopies of the assignments with you.

After evaluation, the assignments have to be returned to you by the Study Centre. Please insist on this and keep a record with you. The marks obtained by you will be sent by the Study Centre to the Student Evaluation Division at IGNOU, New Delhi.

Guidelines for Doing Assignments

There are five questions in each assignment, all carry equal marks. Attempt all the questions in not more than 500 words (each). You will find it useful to keep the following points in mind:

Planning: Read the assignments carefully. Go through the units on which they are based, make some points regarding each question and then rearrange them in a logical order

Organization and Presentation: Be analytical in your selection of the information for your answer. Give adequate attention to the introduction and the conclusion. Make sure that your answer is logical and coherent; has a proper flow of information.

For IGNOU Solved Assignment PDF & Hand Written

Subscribe YOUTUBE : ASSIGNMENT SOLUTION

WhatsApp Contact : 9958676204