Fri. May 24th, 2024

MCS-023 Solved Assignment 2021-22

MCS-023 Solved Assignment 2021-22

Subject Name Introduction to Database Management Systems
Assignment Code MCS-023
Session 2021-2022 (July – January)
File Type PDF
Number of Pages 101
Price Rs. 45

To get the PDF click on the button below.

Pay Now

 

Note:

  1. After the successful payment you will receive download link via an email very shortly.
  2. You can also place your order over WhatsApp (+91-7980608289).

Introduction to Database Management Systems (MCS-023) 2021-2022 (July-January)

Note : This assignment has five questions. Answer all questions of total 80 marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance 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. 

Question 1: (20 Marks)
a. What are the advantages of having three-level database architecture? How are they related to Data Independence? Explain with the help of an example.

b. What are the different forms of integrity control in database management system? Describe with the help of examples.

c. What is a Transaction? What are the problems of concurrent transactions? Describe with the help of examples.

d. What is locking? How does it solve the problem of concurrent transaction execution? Describe with the help of examples.

e. What is a distributed database management system? How is it different to that of client server database systems?

MCS-023 Solved Assignment 2021-22

IGNOU BCA 3rd Sem Solved Assignment 2021-22

IGNOU BCA 3rd Sem Assignment 2021-22 Question PDF Download 

Question 2: (10 Marks)
Consider that a Departmental Store needs to maintain a database system for maintaining its
inventory of items. The database is needed for the following requirements:

  • To find out the item name, item-code, item description and present stock level of all or
    specified items.
  • To find the information about various Vendors of the store. A vendor can supply all or some items only. Some of the information that is needed about vendor is: the Vendor Code, Vendor name, address, office phone etc.
  • To find the information about various orders those are placed for various items to various vendors. It also keeps information about receipt of item/items and updates the inventory.
  • To keep track of all the issues of the items to various users.

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. Also design the normalized tables with required integrity and security constraints.

MCS-023 Solved Assignment 2021-22

IGNOU BCA 3rd Sem Solved Assignment 2021-22

IGNOU BCA 3rd Sem Assignment 2021-22 Question PDF Download 

Question 3: (20 Marks)
Consider a “Software Management System” that maintains the database using the following tables:

Project (p-id, p-title, start-date, duration, 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 project 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 offered maximum number of projects to the company.

b. Find the list of all the employees and the projects they have worked from time to time.

c. Find the employees who are working in more than 2 projects.

d. Find the names of all those employees who have worked on all the projects of client whose c-name is “ABC University”.

e. Find the projects which will be completed by 31st Dec, 2022.

f. Find all the clients who have not given any project. Also find the person who is not working on any project at all.

g. List all the project titles along with their p_id.

h. List all the Clients along with their details.

i. List all the project-persons along with their details.

j. List all the employees whose name starts with “A”.

Note: Make suitable assumptions, if any.

MCS-023 Solved Assignment 2021-22

IGNOU BCA 3rd Sem Solved Assignment 2021-22

IGNOU BCA 3rd Sem Assignment 2021-22 Question PDF Download 

Question 4: (10 Marks)
Consider the Relation R={A, B, C, D, E, F, G, H } and the set of functional dependencies.
A→C      B→CG      AD→EH      C→DF       A→H
What is the key for R? Decompose R into 2NF, 3NF and finally in BCNF relation.

MCS-023 Solved Assignment 2021-22

MCS-023 Solved Assignment 2021-22

IGNOU BCA 3rd Sem Solved Assignment 2021-22

IGNOU BCA 3rd Sem Assignment 2021-22 Question PDF Download 

Question 5: (20 Marks)
Consider the ER diagram of Q2 and tables designed. Implement this database using MS Access or any other similar RDBMS package. You must include the following details in your implementation:

  • Normalized tables and table relationships
  • Constraints on data values including referential Integrity constraints.
  • Design minimum two forms and two reports.
  • Also prepare the system catalog / data dictionary.

MCS-023 Solved Assignment 2021-22

MCS-023 Solved Assignment 2021-22

IGNOU BCA 3rd Sem Solved Assignment 2021-22

IGNOU BCA 3rd Sem Assignment 2021-22 Question PDF Download 

 

6 thoughts on “MCS-023 Solved Assignment 2021-22”
  1. Copy of the mail I sent you, please reply
    Hi,
    I just paid you Rs. 45 for the link of MCS-023 solved assignment like you said in your video and I haven’t yet received any mail regarding the link you said would be received.
    So, please just do the essential to solve this problem.
    Either you give me the link ASAP or send me my money back

    Proof of payment attached below

      1. I have already paid rs 45 for the dbms assignment and not yet received the answer key. Pls send me the answer key as soon as possible

    1. I have already paid rs 45 for the dbms assignment and not yet received the answer key. Pls send me the answer key as soon as possible

Leave a Reply

Your email address will not be published. Required fields are marked *

Insert math as
Block
Inline
Additional settings
Formula color
Text color
#333333
Type math using LaTeX
Preview
\({}\)
Nothing to preview
Insert
error: Content is protected !!