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.

Post a Comment

Most Viewed This Month

BCS-012 SOLVED ASSIGNMENT FOR 2017-18 SESSION (IGNOU BCA)

IGNOU BCA 2017-18 SESSION SOLVED ASSIGNMENT FOR 1ST SEMESTER Question of Assignment:
Q1.
For what value of 'k' the points (-k+1,2k),(k,2-2k) and (-4-k,6-2k) are collinear.

DOWNLOAD PDF ASSIGNMENT OF BCS-012 (MATHS)




BORUTO NARUTO NEXT GENERATIONS EPISODE 18 ENGLISH SUB (Download or Watch Online)

When Himawari falls sick Boruto remembers the day Naruto was officially made the Hokage, and the incidents which occurred that day. Following in present with Naruto taking him to Ichiraku ramen as they had made Hinata angry over Himwaris food since she was feeling well now ,there they meet Cho-Cho and Choji who had come from their Ramen eating competition.Naruto then remembers all the incidents linked with Ichiraku over the period of his life.Boruto later comes to know of the Legendary queen of gluttony and that it was really his mom Hinata.
DOWNLOAD BARUTO EPISODE 18
GOTO PREVIOUS EPISODE GOTO NEXT EPISODE We deliver no-ads on video. There are no hidden ads on page either. You are free to watch.

Download

About VideoSeries Name: Boruto : Naruto Next GenerationsEpisode Name: "A Day in the Life of the Uzumaki Family"
"Uzumaki-ke no Ichinichi" (うずまき家の一日) Episode Number: 18Director: Noriyuki Abe, Hiroyuki YamashitaMain Character: Boruto UzumakiDate of Broadcast: August 2 20…

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

Questions Solved in Assignment:
1. Write an algorithm that accepts a Tree as input and prints the corresponding
Binary Tree
2. Write an algorithm for the implementation of an AVL tree.
3. Write a note of not more than 5 pages summarizing the latest research in the
area of “Sorting Techniques”. Refer to various journals and other online
resources. Indicate them in your assignment.
4. Write an algorithm for the implementation of a Doubly Linked List.






IGNOU BCA 3rd SEMESTER SOLVED ASSIGNMENTS FOR ALL SUBJECTS 2017-18 SESSION

IGNOU BCA 3rd SEMESTER SOLVED ASSIGNMENTS FOR ALL SUBJECTS 2017-18 SESSION
Download IGNOU BCA Solved Assignments For 3rd SemesterCOURSE CODECOURSE NAMEDIRECT LINKBCS-031Programming in C++DOWNLOADBCSL-032C++ Programming LabDOWNLOADBCSL-033Data and File Structures LabDOWNLOADBCSL-034DBMS LABDOWNLOADMCS-014System Analysis And DesignDOWNLOADMCS-021Data and File StructuresDOWNLOADMCS-023Introduction to Database Management SystemsDOWNLOAD