Skip to main content

MCS-023 SOLVED ASSIGNMENT 2017-18 IGNOU BCA AND MCA

MCS-023 SOLVED ASSIGNMENT 2017-18 IGNOU BCA/MCA



Course Code: MCS-023
Course Title: Introduction to Database Management Systems
Assignment Number: BCA (3)/023/Assignment/17-18
Last Date of Submission: 15th Oct, 2017 (for Jul-2017 batch)
                                             : 15th April, 2018(for Jan-2018 batch)
Questions Solved in Assignment:
1. List and describe briefly all the possible applications of a database
management system for any IGNOU’s Study Centre.
2. Identify all the associated entities for a Study Centre Management System,
their corresponding attributes, relationships and cardinality and design an
Entity-Relationship (ER) diagram for it.
3. Consider the E-R diagram of Question 2 and design the relational schema
and the tables. Perform and show the Normalization till the required normal
form. Implement the database using MS-Access and submit the screenshots
along with your assignment response for this question.
4. Consider a “Project Management System” that maintains the database using
the following tables:
Project (p_id, p_title, start_date, duration, end_date, c_id, cost)
Client (c_id, c_name, c_address, c_phone)
Employee (e_id, e_name, e_address, e_phone)
ProjectLeader (p_id,e_id)
Please note that an employee may be working on more than one project in
the organization at a time. Write and run the following SQL queries on the
tables:
(a) Find the c_id and c_name of the clients who have given maximum
number of projects to the company.
(b) Find the list of all the p_id’s, their project details and project leaders of
all the projects.
(c) Find the p_id’s whose title starts with “a” or “A”.
(d) Find the projects which will be completed by this month-end.
(e) Find all the clients who have not given any project. Also find the person
who is not working on any project at all.
Note: Make suitable assumptions, if any.
5. (a) Discuss the advantages and disadvantages of hierarchical database
management system in comparison with RDBMS. Discuss types of
applications suitable for hierarchical DBMS and RDBMS.
(b) Define the two principal integrity rules for the relational model.
Discuss why it is desirable to enforce these rules.

« BCA 3rd SEMESTER SOLVED ASSIGNMENTS

Comments

Popular This Week

IGNOU BA (BDP) Solved Assignments For All Subjects 2017-18 Session

MCO-05 Solved Assignment For IGNOU MCOM 2nd Year 2018 Session

IGNOU MCOM Solved Assignment for 2018 (FREE) MCO-05 Accounting For Managerial DecisionsQuestions Solved In Assignment:“Balance Sheet is a statement of assets and liabilities or sources and uses of funds or both”, Comment.“Funds flow statement is only supplementary to P/L Account and Balance Sheet, it can not substitute to P/L Account and Balance Sheet”. Do you agree to this statement? Explain your views.Comment on the following statement: A budget is both a plan as well as a control tool.Budget should be regarded as a master but not as a servant.Fixed budget is more useful than a flexible budget.Performance budgeting lays immediate stress in the achievement of specific goals over a period of time.Describe various sectors of chemical industry. What are India’s competitive advantages & disadvantages in the export of chemical goods?Differentiate between the following: Standard cost and Estimated costFixed overhead Efficiency variance and fixed overhead calendar varianceMarginal costi…

BSHF-101 (ENGLISH MEDIUM) SOLVED ASSIGNMENT FOR IGNOU BDP

Download Assignment IGNOU BDP Solved Assignment for 2018 (FREE)BSHF-101 Foundation Course in Humanities and Social SciencesQUESTIONS SOLVED IN ASSIGNMENT:Discuss the different aspects of the non-cooperation movement. Discuss some of the sources of thinking that went in to formulating a strategy for development immediately after independence? What do you understand by the term 'renaissance'? How did the Indian economy adapt to globalisation? Comment. Comment on the main environmental challenges we are facing today?What do you understand by the term 'Fundamental Duties' as given in our constitution? SCQ: Write short notes on any two in about 100 word s each: BharatnatyamSwara in Indian musicDownload Assignment

BEGE-101/EEG-01 Solved Assignment For IGNOU BDP 2017-18

IGNOU BDP Solved Assignment for 2018 (FREE)BEGE-101/EEG-01 Elective Course In English SOLVED ASSIGNMENT Read the following poem carefully and answer the following questions. Amalkanti (Nirendranath Chakrabarti) Amalkanti is a friend of mine, we were together at school. He often came late to class and never knew his lessons. When asked to conjugate a verb, he looked out of the window in such puzzlement that we all felt sorry for him. Some of us wanted to be teachers, some doctors, some lawyers. Amalkanti didn't want to be any of these. He wanted to be sunlight — the timid sunlight of late afternoon, when it stops raining and the crows call again, the sunlight that clings like a s mile to the leaves of the jaam and the jaamrul. Some of us have become teachers, some doctors, some lawyers. Amalkanti couldn't become sunlight. He works in a poorly lit room for a printer. He drops in now and then to see me, chats about this and th at over a cup of tea, then gets up to go. I see him of…

FEG-1 AND BEGF-101 SOLVED ASSIGNMENT FOR IGNOU BDP 2018

Download Assignment IGNOU BDP Solved Assignment for 2018 (FREE)FEG-1 BEGF-101 Foundation Course In EnglishQUESTIONS SOLVED IN ASSIGNMENT:Read the following passage and answer the questions that follow: A new study has found that the giant panda’s distinct black - and - white markings have two functions: camouflage and communication. The scientists who earlier uncovered why zebras have black - and - white strips, took the colouration question to giant pandas in the latest study. “Understanding why the giant panda has such striking colouration has been a long - standing problem in biology that has been difficult to tackle because virtually no other mammal has this appearance, making analogies difficult , ” said Tim Caro, a professor at the University of California, Davis in the U.S. “The breakthrough in the study was treating each part of the body as an independent area,” said Mr. Caro. This enabled the team to compare different regions of fur across the giant panda’s body to the dark a…