Get your IGNOU Help books delivered to your doorstep in Delhi NCR within just 4-6 hours! (T&C Apply). Order now to Get Success in Exams.

IGNOU MCS-23
- Introduction to Database Management Systems,
Latest Solved Assignment

(July 2022 - January 2023)

MCS-23 Assignment

#1 Best Selling IGNOU Assignments in All Available in Market

Bought By: 4222 Students

Rating: 4.1

Get IGNOU MCS-23 Assignments Soft Copy ready for Download in PDF for (July 2022 - January 2023) in English Language.

  • Helps save time and effort-really well
  • Promises Good Marks in Less Time
  • Answers that are verified and accurate
  • Based on IGNOU Guidelines.
Only 5 left to stop selling the Same Copy people are viewing this, and 10 recently purchased it

Select Assignment Type

Typed or Handwritten
Instant Download in Next 2 Minutes after Payment.

Buy Bulk Assignments (Soft or Hard) Copy

Buy Bulk Handwritten Assignments
  • 100% Money-Back Guarantee
  • Faster Shopping
  • Choosing us saves you time and money
  • Guaranteed Safe Checkout

IGNOU MCS-23 July 2022 - January 2023 - Solved Assignment

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 2022 - January 2023 session. The code for the assignment is MCS-23 and it is often used by students who are enrolled in the MCA 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.

IGNOU MCS-23 (July 2022 - January 2023) Assignment Questions

Q1. a) Draw and explain the detailed system architecture of DBMS.
b) With the help of a diagram, describe the concept of client/server model.
c) Explain in detail about various key constraints used in database system. Give examples for each.
d) Explain the importance of NULL values in Relational Model.
e) Discuss the mechanism of attribute relationship inheritance. How is it useful?
f) By considering an example describe various data update operations in SQL. Give examples.
g) Explain insertion, deletion and modification anomalies with suitable examples.
h) State BCNF. How does it differ from 3NF?
i) How can a database recover from failure when many transactions are going on? Describe with the help of an example.
j) What is a distributed database management system? How is it different to that of client server database systems?

Q2. Suppose you are given the following requirements for a simple database for the National Football League (NFL):
• the NFL has many teams,
• each team has a name, a city, a coach, a captain, and a set of players,
• each player belongs to only one team,
• each player has a name, a player position (such as Centre Forward, left midfield, center midfield, right midfield, left fullback, centre back etc..), a skill level, and a set of injury records,
• a team captain is also a player,
• a game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 2000) and a score (such as 4 to 2).
Construct an ER diagram for the NFL database using the Chen notation with all conventions. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram.

Q3. Consider a “Library Management System” which keeps the following tables:
Book (isbn_no, book_title, author, publisher, edition, year_of_copyright)
BookAccession (accession_no, isbn_no, date_of_purchase)
Members (m_id, m_name, m_address, m_phone).
Issue_return (accession_no, m_id, expected_date_of_return, actual_date_of_return)

Please note that a member can be issued a book for a period of 15 days. The actual-date-of-return is kept blank for the books that have not been returned. Write and run the following SQL queries on the tables:
(i) Find the m_id and m_name of the members who have got maximum number of unreturned books.
(ii) List the book details along with the number of copies for that book in the library (issued or not-issued both)
(iii) Find the names of all those students who have got all the books issued to him of the author named “ABC” .
(iv) Find the books that are expected to be returned in this week.
(iv) Find those members who have not got any book issued to him/her during last six months.

Make suitable assumptions, if any.

Q4. Consider the Relation R={A, B, C, D, E, F, G } and the set of functional dependencies.
A→F B→CD C→G F→E
What is the key for R? With the help of a suitable example discuss the Insertion, Deletion and Updation anomalies which can arise if the relation is not in 2NF and 3NF ? Decompose R into 2NF, 3NF and finally in BCNF relation.

MCS-23 Assignment Details

  • University IGNOU (Indira Gandhi National Open University)
  • Title Introduction to Database Management Systems
  • Language(s) English
  • Session July 2022 - January 2023
  • Code MCS-23
  • Subject Computer Application
  • Degree(s) MCA
  • Course Core Courses (CC)
  • Author Gullybaba.com Panel
  • Publisher Gullybaba Publishing House Pvt. Ltd.

Assignment Submission End Date

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.

  • 30th April (if Enrolled in the June Exams)
  • 31st October (if Enrolled in the December Exams).

Download Files & Sessions Details

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.

English Language

  • July 2022 - January 2023 14 Pages (0.00 ), PDF Format SKU: IGNGB-AS-MCA-MCS23-EN-231

What's Included

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.

  • All Solved Answers By IGNOU Experts.
  • Available for 3 Times for Download.
  • Downloadable Soft Copy in PDF.
  • Print Ready Format: A4 (21 x 29 x .20 cm (Width x Length x Height)