IGNOU MCA BCA MCS-023 Solved Assignment 2019-20 Available Now

IGNOU MCA  BCA MCS-023 Solved Assignment 2019-20 Available Now

MCS-023 Solved Assignment 2019-20

                                                    DOWNLOAD NOW

Q1. (20 Marks)

Design an ER diagram for an ABC IT Training Institute that will meet the training needs for

individuals and employees of corporate offices. Clearly indicate the entities, relationships,

cardinality and the key constraints. The description of the environment is as follows:

The Institute offers 5 advanced courses of 3 months duration each. The Institute has 20 faculty

and can handle up to 40 trainees per batch. The training will be conducted batch wise. They can

accommodate maximum 5 batches per day (2 batches in the pre-lunch session and 3 batches in

the post-lunch session). The student can register up to 2 courses simultaneously. Training

consists of theory and practical. Theory and practical are scheduled on alternate days. Each batch

is assigned a faculty member who takes theory sessions as well as practical sessions. Sunday is

holiday for everyone. A test will be conducted per course every week to continuously evaluate

the performance of the student. The question paper will be set by the faculty concerned whoever

is teaching the batch. The result/grade will be declared at the end of the third month after

conducting course-end exam.

Q2. (10 Marks)

Design the Relational Schema for the E-R diagram that you have drawn for part Question 1. The

relations must be at least in 2 NF. Perform the following on the relations:

a) Enter about 5 sets of meaningful data in each of the relations.

b) Identify the domain of various attributes.

c) Identify the Primary keys of all the relations.

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

Q3. (10 Marks)

(a) “For creating a Employee Management Information System of an Organisation a

database management system(DBMS) is better or a file management system.” Justify the

statement given above.

(b) Assume that you are assigned the role of Database Administrator for the Organisation

database, mention the key responsibilities you have to handle?

DOWNLOAD NOW

Read More

BCA(2) BCSL-022 Assembly Language and Programming Lab Solved Assignment 2019-20

BCA(2) BCSL-022 Assembly Language and Programming Lab Solved Assignment 2019-20.

BCSL-022 SOLVED ASSIGNMENT 2019-20

BCA(2) BCSL-022 Assembly Language and Programming Lab Solved Assignment 2019-20

Q: 1 Design a two bit counter circuit that counts from 0 to 2. It should have states 00, 01 and 10. The initial state of the counter may be assumed to be 00. The counter will be in following successive states: 00, 01, 10, 00, 01, 10, 00, 01, 10, 00 ... Use J-K flip flop to design the circuit. You must design the circuit using state transition diagram and Karnaugh's maps.

Ans: 

A sequential circuit is specified by a time sequence of external inputs, external outputs and internal flip-flop binary states. Thus firstly, a state table and state diagram is used to describe behaviour of the circuit.

DOWNLOAD NOW

Read More

IGNOU MCA(1) BCA(2) MCS-015 Communication Skill Solved Assignment 2019-20

IGNOU MCA(1) BCA(2) MCS-015 Communication Skill Solved Assignment 2019-20

IGNOU MCA(1) BCA(2) MCS-015 Communication Skill Solved Assignment 2019-20

This assignment has six questions. Answer all questions. Please go through the guidelines

regarding assignments given in the Programme Guide for the format of presentation.

Q1. Read the passage carefully and answer the questions given below. This passage is taken

from the Commencement address delivered by late Steve Jobs, who was CEO of Apple

Computer

When I was 17, I read a quote that went something like: "If you live each day as if it was

your last, someday you'll most certainly be right." It made an impression on me, and

since then, for the past 33 years, I have looked in the mirror every morning and asked

myself: "If today were the last day of my life, would I want to do what I am about to do

today?" And whenever the answer has been "No" for too many days in a row, I know I

need to change something.

Remembering that I'll be dead soon is the most important tool I've ever encountered to

help me make the big choices in life. Because almost everything — all external

expectations, all pride, all fear of embarrassment or failure - these things just fall away

in the face of death, leaving only what is truly important. Remembering that you are

going to die is the best way I know to avoid the trap of thinking you have something to

                                                         DOWNLOAD NOW

Read More

IGNOU MCA(1) MCS-013 Discrete Mathematics Solved Assignment 2019-20 | BCA MCS-013

IGNOU MCA(1) MCS-013 Discrete Mathematics Solved Assignment 2019-20 | BCA MCS-013 Solved Assignment 2019-20

MCS-013 Discrete Mathematics Solved Assignment 2019-20 MCA BCA

Q1.

(a) What is proposition? Explain different logical connectives used in proposition with the

help of example. (3 Marks)

(b) Make truth table for followings. (4 Marks)

i) p→(q  r)  p  ~q

ii) p→(~r  ~ q)  (p  r)

(c) Give geometric representation for followings: (3 Marks)

i) R x { 2}

ii) {1, 5) x ( -2, -3)

Q2.

(a) Draw a Venn diagram to represent followings: (3 Marks)

i) ( A  B  C) ~A

ii) (A  B  C)  (B  C)

(b) Write down suitable mathematical statement that can be represented by the following

symbolic properties. (4 Marks)

i) (  x) (  z) (  y) P

ii)  (x) (  y) (  z) P

(c) Show whether √3 is rational or irrational. (3 Marks)

Q3.

(a) Explain inclusion-exclusion principle with example. (2 Marks)

(b) Make logic circuit for the following Boolean expressions: (4 Marks)

i) (x ' y ' z) + (x ' y ' z)'

ii) (x ' yz) (x ' yz ') (xy ' z)

(c) What is a tautology? If P and Q are statements, show whether the statement

(𝑃 → 𝑄) ∨ (𝑄 → 𝑃) is a tautology or not. (4 Marks)

Q4.

(a) How many words can be formed using letter of STUDENT using each letter at most

once?

i) If each letter must be used,

ii) If some or all the letters may be omitted. (2 Marks)

(b) Show that: (2 Marks)

P=>Q and (~P  Q) are equivalent.

Click Here to Download Solved Assignment 2019-20

Read More

BCA-1st Semester Solved Assignment 2019-20 | BCS-011 Solved Assignment 2019-20

IGNOU BCA BCS-011 Basic Computer and PC Software  Solved assignment for session 2019-20 available now. Student can Download solved assignment 2019-20 for bca -1st Semester 2019-20 IGNOU from our site. . This assignment is good quality and made according to assignment cretireia. . Student got good marks from this assignment. 

                                DOWNLOAD NOW

Read More

IGNOU BCA BCSL 021 C Language Programming Solved Assignments || BCA 2nd ...

bcsl 021 solved assignment 2018-19

bcsl 022

bcsl 022 solved assignment 2018-19

bcsl 021 solved lab manual

bcsl 21 solved assignment 2018 -19

bcsl 22 solved assignment 2018-19

Read More

IGNOU MCA BCA Solved Assignment 2018 19 || BCA SOLVED ASSIGNMENT2018-19

BCA 2nd Semester solved Assignments 2018-19              Download Now

Read More