IGNOU BCS 92 SOLVED ASSIGNMENT 2025

Ques 1.

Design an ER diagram for a departmental Store. This store sells many products. The store keeps multiple quantities of these products. Each product is uniquely identified by a Product ID. In addition, the store maintains the Product Name, Price, Quantity in stock, Date of production, and Date of expiry of each product. The store sells these products to registered customers of the store. The store maintains the Customer ID, Name, Postal Address with City and Pin code, and Phone number of every customer. All the orders made by different customers are recorded in an order table. An order may consist of many products.

Identify and list the entities, attributes, relationships, cardinality, and key constraints for the description of the store given above. Make and state suitable assumptions.

Ques 2.

Design the Relational Schema for the E-R diagram you drew for Question 1. The relations must be at least in 3NF. Perform the following tasks using these relations:

a) Identify the domain of the attributes.

b) Identify the Primary key of every relation.

c) Identify the Foreign keys and referential integrity constraints in the relations.

Create the tables with keys and constraints and enter about five sets of meaningful data in cach relation

Ques 3.

List the names of all the customers whose names start with the alphabet "A".

Ques 4.

List the Product name of all the products whose price is over INR 5000.

Ques 5.

Find the list of products whose quantity in stock is less than 5.

Ques 6.

Find the list of products whose quantity in stock is less than 5.

Ques 7.

Find the total amount of order of Order ID "000001".

Ques 8.

List the name of the customers who have Ordered at least once.

Ques 9.

Find the number of orders given by cach customer.

Ques 10.

Find the total number of products in the store.

Ques 11.

List the product that has been ordered the most.

Ques 12.

Find the total number of customers of the store.

Ques 13.

Explain the logical design phase of database development of an organisation.

Ques 14.

Compare the Android platform with one other open-source mobile operating system, focusing on community contributions and licensing models.

Ques 15.

Explain the role of the Dalvik Virtual Machine (DVM) and ART in Android's runtime environment. Discuss their impact on application performance and memory management.

Ques 16.

Design a flowchart to depict a custom Activity Lifecycle that includes logging the state transitions. How would you manage state persistence during configuration changes?

Ques 17.

Discuss the features of Gradle used in Android Studio. Provide an example of how to include a third-party library in your Android project using Gradle.

Ques 18.

Outline the strategies to ensure compatibility with Android's fragmented ecosystem. Include techniques to handle API level differences and screen resolutions.

Ques 19.

Describe the use of Espresso for UI testing in Android. Write a test case to verify the behavior of a button click that changes the text of a TextView.

Ques 20.

Explain the differences between SQLite, Shared Preferences, and Room Database in Android. Provide a scenario where each storage option is the most appropriate.

Ques 21.

Describe the steps required to publish an Android application to the Google Play Store. Include considerations for setting up a monetisation strategy using in-app purchases.

Ques 22.

Discuss three common performance bottlenecks in Android apps. Suggest strategies to profile and optimise application performance using Android Studio.

Ques 23.

Propose measures to secure sensitive user data policies in an Android application.

• Latest IGNOU Solved Assignment
• IGNOU BCS 92 2025 Solved Assignment
• IGNOU 2025 Solved Assignment
• IGNOU CMAD Certificate in Mobile Application Development 2025 Solved Assignment
• IGNOU BCS 92 Introduction to Databases 2025 Solved Assignment

Looking for IGNOU BCS 92 Solved Assignment 2025. You are on the Right Website. We provide Help book of Solved Assignment of CMAD BCS 92 - Introduction to Databasesof year 2025 of very low price.
If you want this Help Book of IGNOU BCS 92 2025 Simply Call Us @ 9199852182 / 9852900088 or you can whatsApp Us @ 9199852182
 

IGNOU CMAD Assignments Jan - July 2025 - IGNOU University has uploaded its current session Assignment of the CMAD Programme for the session year 2025. Students of the CMAD Programme can now download Assignment questions from this page. Candidates have to compulsory download those assignments to get a permit of attending the Term End Exam of the IGNOU CMAD Programme.

Download a PDF soft copy of IGNOU BCS 92 Introduction to Databases CMAD Latest Solved Assignment for Session January 2025 - December 2025 in English Language.

If you are searching out Ignou CMAD  BCS 92 solved assignment? So this platform is the high-quality platform for Ignou CMAD  BCS 92 solved assignment. Solved Assignment Soft Copy & Hard Copy. We will try to solve all the problems related to your Assignment. All the questions were answered as per the guidelines. The goal of IGNOU Solution is democratizing higher education by taking education to the doorsteps of the learners and providing access to high quality material. Get the solved assignment for BCS 92 Introduction to Databases course offered by IGNOU for the year 2025.Are you a student of high IGNOU looking for high quality and accurate IGNOU BCS 92 Solved Assignment 2025 English Medium? 

Students who are searching for IGNOU Certificate in Mobile Application Development (CMAD) Solved Assignments 2025 at low cost. We provide all Solved Assignments, Project reports for Masters & Bachelor students for IGNOU. Get better grades with our assignments! ensuring that our IGNOU Certificate in Mobile Application Development Solved Assignment meet the highest standards of quality and accuracy.Here you will find some assignment solutions for IGNOU CMAD Courses that you can download and look at. All assignments provided here have been solved.IGNOU BCS 92 SOLVED ASSIGNMENT 2025. Title Name BCS 92 English Solved Assignment 2025. Service Type Solved Assignment (Soft copy/PDF).

Are you an IGNOU student who wants to download IGNOU Solved Assignment 2024? IGNOU CERTIFICATE PROGRAMMES Solved Assignment 2023-24 Session. IGNOU Solved Assignment and In this post, we will provide you with all solved assignments.

If you’ve arrived at this page, you’re looking for a free PDF download of the IGNOU CMAD Solved Assignment 2025. CMAD is for Certificate in Mobile Application Development.

IGNOU solved assignments are a set of questions or tasks that students must complete and submit to their respective study centers. The solved assignments are provided by IGNOU Academy and must be completed by the students themselves.