MCS-043 ASSIGNMENT SOLUTION (2020-21)

If you have any queries please leave a message here
Your Message
×


Q1. Consider a small institute in which students register through on-line mode for programmes run by the institute. A student can be a full time or part time . A program can be offered through a normal mode ( face to face) or on-line. Every student necessarily registers in at least one programme and at most two programmes. After completion of a program, students are issued a certificate. Assuming suitable attributes, design an EER Diagram for the same.

a) Draw the EER (extended ER) diagram for the above problem showing all entities, attributes and relationship. Also identify multi-valued and derived attributes.

Answer : - Coming Soon




Q1. b) Draw the appropriate tables and relationship among the tables for the above diagram and normalize the tables up to 3NF.

Answer : - Coming Soon




Q1. c) Include generalization and aggregation features in the diagram, draw their tabular representations and UML class diagram. Explain

Answer : - Coming Soon




Q1. d) Identify weak entity sets in the above diagram if any. Show how will you convert a weak entity set to a strong entity set? What is the need of such task?

Answer : - Coming Soon




Q1. e) Identify multi-valued dependency in the above diagram if any. Justify.

Answer : - Coming Soon




Q1. f) Create an XML schema for the grade card to be issued by the division having details: student id, programme code, course id, grade, program delivery mode, assignments marks, TEE marks.

Answer : - Coming Soon




Q2. What are XML databases? What are the benefits of using XML? What are its applications? Explain.

Answer : - Coming Soon




Q3. Define cursors, stored procedures and triggers and write SQL syntaxes for each. What are the advantages and disadvantages of stored procedures? What are the main features of a cursor?

Answer : - Coming Soon




Q4. Explain primary key, foreign key, super key and composite key with the help of an example for each key. Also write the important features of each.

Answer : - Coming Soon




Q5. What are the algorithms that can be used to implement JOIN operation? What is the criteria for selecting a particular join algorithm? Explain Hash Join algorithm and perform its cost calculation

Answer : - Coming Soon




Q6. What is concurrency control? What is the need of applying concurrency control methods in database? Give an example. Write the algorithm of timestamp based ordering protocol and explain through an example. What are the problems with this algorithm and what are the proposed solutions for it?

Answer : - Coming Soon




Q7. How is recovery with concurrent transactions performed? Discuss.

Answer : - Coming Soon




Q8. State the differences between classification and clustering. Write an algorithm of K-Means clustering. Explain the algorithm with the help of an example.

Answer : - Coming Soon




Q9. What are Semantic databases? Give the features of semantic databases. Discuss the process of searching the knowledge in these databases.

Answer : - Coming Soon



ABOUT US

QuestionSolves.com is an educational website that helps worldwide students in solving computer education related queries.

Also, different software like Visual Studio, SQL Server, Oracle etc. are available to download in different versions.

Moreover, QuestionSolves.com provides solutions to your questions and assignments also.


MORE TOPIC


Windows Command

UNIX Command

IGNOU Assignment Solution

IGNOU Question Paper Solution


WHAT WE DO


Website Devlopment

Training

Home Learning

Provide BCA, MCA Projects

Provide Assignment & Question Paper Solution


CONTACT US


Follow Us