diff_months: 3

DCA6111 Relational Database management System

Flat 50% Off Order New Solution
Added on: 2025-06-03 07:00:36
Order Code: LD522637
Question Task Id: 0

INTERNAL ASSIGNMENT


SESSION


Sep 2024


PROGRAM


Master of COMPUTER APPLICATIONS (MCA)


SEMESTER


1


course CODE & NAME


DCA6111 Relational Database management System


CREDITS


4


nUMBER OF ASSIGNMENTS & Marks


02


30 Marks each

Please read the below instructions carefully before proceeding further:



  • Learners are instructed to download the IA Question Paper, prepare the answers (Soft Copy), and submit them through Learning Management System (LMS) Portal

  • The last IA assignment submission date (Set-1 & Set-2 in a single file) is reflected in LMS only. This is the last date, and no further extension will be considered.

  • Assignment submissions are accepted only in .pdf format.

  • Assignments must be typed and formatted as per the following specifications:

    • Page Margin 1 inch on all sides

    • Page Orientation Portrait

    • Page Size A4

    • Font Family - Times New Roman

    • Font size - 12

    • Alignment - Justified.


  • The total page limit shall not exceed 12 pages.

  • Answers for 10-mark questions should be approximately 400-500 words and not more than 200-250 words for 5-mark questions.

  • The average of both assignments marks scored by the learner will be considered Internal Assessment Marks.

  • Only ONE submission is allowed per assignment.

  • Please restrict the assignment document size to <2>
  • Upon successfully submitting IA in LMS, learners can verify the document submitted against each course using the preview tab. If the file submitted has been corrupted or the wrong document submitted, it will not be considered for evaluation.

  • If the learner resubmits the assignment, it is permissible only on or before the cut-off date, and the last submission will be considered for evaluation purposes.

  • Content that has been directly copied from the Internet/SLM and Assignments that have been copied and shared among students will be automatically rejected and disqualified.


Set I


Q.No


Questions


Marks


Total Marks


1.


What do you mean by data Model? Explain different types of data model by giving suitable example.



2+8



10


2.


Explain various transaction operations in DBMS.


10



10


3.


Explain the various types of databases anomalies. Explain by giving suitable example.


10


10


Set II


Q.No


Questions


Marks


Total Marks


4.


A. What do you mean by Temporal database? What are its different types? Explain.


B. Briefly describe SQL3 and its important features.


5+5


10


5.


What are the different lock modes used in the locking system? Discuss.


10


10


6.


What do you mean by Fragmentation? What are the different types of fragmentation. Explain by giving suitable example.


2+6+2


10


  • Uploaded By : Akshita
  • Posted on : June 03rd, 2025
  • Downloads : 0
  • Views : 70

Order New Solution

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan

Premium

80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing
Most
Popular

Gold

30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%

Silver

20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more