Skip to main content



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
(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.



Popular This Week

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


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

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…

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…

FST-01 Solved Assignment For IGNOU BDP 2018 Session

IGNOU BDP Solved Assignment for 2018 (FREE)FST-01 Foundation Course In Science and Technology SOLVED ASSIGNMENT IGNOU BA (BDP) Solved Assignment For 2017-18FST-01 Foundation Course In Science and TechnologyQuestions Solved In Assignment:Download For 2017 Download For 2018 IGNOU BDP (BA) SOLVED ASSIGNMENTS FOR ALL COURSES