Solve your IGNOU Doubts
Solve your IGNOU Doubts
Question:

 Find the total price of the order id O00105 .

See Answer →
Question:

. List all the customers whose name starts with alphabet ‘P’ and are not prime member.

See Answer →
Question:

List the customer details, who has placed their orders on 10-8-2024 and order value is more than 5000. 

See Answer →
Question:

List the order id and amount of those orders which are placed during 2nd week of the month and are of amount less than 20,000.

See Answer →
Question:

Write and run the following queries for your database using SQL commands: 1. List all the customers whose pin code is “ 110068” and have prime membership.

See Answer →
Question:

Implement the database design (create tables) that you have created in question 1 using a RDBMS with proper integrity constraints. Enter about 8- 10 meaningful records in each of your table. 

See Answer →
Question:

List the entities, their attributes and relationships for the description given above and make an ERdiagram for this e-Commerce Portal. You may use the concept of keys, aggregation, generalisation, cardinality etc. as per need. Design the suitable RDBMS tables for the ER-diagram you have created. The database design should include keys, foreign keys, constraints and referential integrity constraints. Your database design should be normalized up to 3rd Normal Form. Make necessary assumptions wherever require.

See Answer →
Question:

Write an algorithm and a program in ‘C’ language for addition of two Polynomials

See Answer →
Question:

Write an algorithm and a program in `C ’ language for the implementation of Circular Doubly Linked List. The implementation should include creation, insertion, deletion, updation , Lookup

See Answer →
Question:

Write a short note on the recent developments in the area of finding shortest path between two nodes of a Graph. Make necessary assumption

See Answer →
Question:

What are Red Black Trees? How do they differ from Splay Trees? What are their applications?

See Answer →
Question:

What is a Tree? How does it differ from a Binary Tree? Is it possible to convert a Tree to a Binary Tree? If yes, then, explain the process with an example

See Answer →
Question:

What is a Doubly Linked Circular List? What are its advantages and disadvantages? Give a scenario where its application is appropriate. Justify your answer.

See Answer →
Question:

 Write short notes on the following database technologies: (i) Distributed databases (ii) Block chain databases

See Answer →
Question:

Explain the need of NoSQL databases. Explain the characteristics of any two types of NoSQL databases.

See Answer →
Question:

Explain the multi-dimensional data model of a data warehouse. Also, define the concept of decision tree with the help of an example. List any four applications of data mining.

See Answer →
Question:

What are object-relational database? Explain the concept of complex data types used in these databases. Explain the object model in the context of Object Oriented database systems. How objectoriented database systems are different from Object-relational database systems

See Answer →
Question:

Make the query tree for the following query (assume the database of problem 2(d)).

SELECT c.custName, c. custId, a.AccountNumber, t.DebitORCredit
FROM Customer c, Account a, Transaction t
WHERE c.custId = a.custId AND a.AccountNumber = t.AccountNumber
AND Amount > 10000;

See Answer →
Question:

What is the cost of selection operation, when the index scan method is used? Explain with the help of an example. Explain the cost of Join operation when Merge-Join method is used.

See Answer →
Question:

) Explain the Log based Recovery with the help of an example. What are Redo and Undo operations. Why do you need checkpoint? Explain the process of recovery with check points with the help of an example Explain with the help of an example, how recovery is performed when Deferred database modification scheme is used.

See Answer →
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★
Top
📞
Call Support Instant phone assistance
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→