|
|
|
|
Filed under: Course Code : CS-15
Course Title : Relational Database Management
Systems
Assignment Number : MCA(6)-15/Project /2004
Maximum Marks : 15
Last Date of Submission : 30th October, 2004
This is Project Assignment consisting of one problem. Each subsection carries equal weightage. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignment given in the Starter kit for the format of presentation.
Question 1: XYZ Company is a Car production company. It has four factories and many distribution outlets spread across the country. The company keeps online records of the sales of its cars. It also creates batched Production schedules on the basis of the sales of the car. The car production is done at a nearest factory so that the cost of transfer of cars to distribution centre is minimized. Each factory also maintains its inventory. The company maintains a distributed database management system keeping all the above information. The following information may be stored in the Distribution and Inventory Management System of the Company: (Please note that the following description may lead to un-normalized relations, normalize them wherever required. You may also add more tables as per your analysis.)
Data store Name : Distribution Outlets
Description : It includes outlet code, outlet name, outlet address, list of car models, sales made for each model etc.
Data store Name : Factory
Description : It may be keeping information about each car inventory items (Model wise). It includes item code, item name, model in which this item is used, quantity used in a single Car unit, and quantity in stock, time taken to produce a batch of 100 cars, etc. This information is stored factory wise. Each factory will have separate minimum stock and reorder level based on its capacity.
Data store Name : Batched Order
Description : It includes details on overall sales of Cars at various outlets, all such sales are put together to generate a consolidated orders for factories. On the basis of such orders the factories make Cars.
Assume that only following two applications exists:
(a) Keeping track of status of Inventory so that the delays in production of Cars can be minimised. Proper reorder levels should be kept so that a given order of cars is completed with full assembly load in desired time.
(b) It evaluates the performance of each distribution outlet of the Company.
Design a distributed database assuming that at present the company has only 10 outlets. Also assume statistics, which justifies your design.
Your design should include:
(i) The global schema, fragmentation schema and allocation schema.
(ii) SQL commands/ application code for above queries/applications.
(iii) How the response for application 1 and 2 will be generated? Assuming these are global queries, explain how various fragments will be combined to generate the query response.
(iv) Implement the database at least using a centralized database management system (make suitable adjustments in your design).
|
Related pages
Syllabus of CS-06 Database Management Systems From IGNOU
Course 6 Database Management Systems - [CS-06]
Block 1 Introductory Concepts of Database Management System
Unit 1 : Basic Concepts
Unit 2 : Database Models and Its Implementation
Unit 3 : File Organisation for Conventional DBMS
Unit 4 : Management Consideration .....
New Revised Syllabus of MCS-043: Advanced Database Management Systems From IGNOU
MCS-043: Advanced Database Management Systems :: 4 Credits
Objectives
This course will help the students to acquire the theoretical foundation of Database Management Systems. It includes concepts relating to various advanced database models, and concepts like database mining and .....
New Revised Syllabus of MCS-043: Advanced Database Management Systems From IGNOU
MCS-043: Advanced Database Management Systems :: 4 Credits
Objectives
This course will help the students to acquire the theoretical foundation of Database Management Systems. It includes concepts relating to various advanced database models, and concepts like database mining .....
CS-06 Introduction to DBMS
Block 1 Introductory Concepts of Database Management System
Unit 1 : Basic Concepts
Unit 2 : Database Models and Its Implementation
Unit 3 : File Organisation for Conventional DBMS
Unit 4 : Management Consideration
Unit 5 : Enterprise Wide Information System of the .....
Syllabus of CS-15 Relational Database Management System From IGNOU
CS-15 Relational Database Management System .....
New Revised Syllabus of MCS-023: Introduction to Database Management Systems From IGNOU
MCS-023: Introduction to Database Management Systems :: 3 Credits
Objectives
This course will help the students to acquire the basic knowledge and practical skills relating to Relational Database Management Systems. After .....
Question Paper of CS 06 - Database Management System of December 2001 from IGNOU
Time: 3 hours
Maximum Marks: 75
Note: There are six questions in this paper Question number 1 is compulsory and carries 30 marks. Attempt any three,from the rest.
1.
a. Design a Relational database to the E-R diagram given below .....
CS-67 RDBMS Lab
Block 1 Unit 1 : RDBMS Terminology
Unit 2 : Overview of logical database design
Unit 3 : Overview of Normalization
Block 2 Practical on Relational Database Management System
Block 3 Unit 1 : Introduction to Microsoft Access
Unit 2 : Microsoft Access Basics
Unit 3 : Working with database
Unit 4 : Creating a Table .....
MCA CS-06 PROJECT Database Management Systems
Course Code : CS-06
Course Title : Database Management Systems
Assignment Number : MCA(2)-6/Project/04
Maximum Marks : 15
Last Date of Submission : 30th October, 2004
This is a Project assignment. There is one question in this project assignment. You must execute the program and submit the program logic, sample input and output along with the necessary documentation .....
Question Paper of CS-15 - RDBMS of Dec 1997 from IGNOU
Time : 3 hours
Max. Mark : 75
Note : There are six questions in this paper.
Question 1 us compulsory and carries 30 marks.
Attempt any three from the rest.
1.
(a) Draw an E-R diagram for a Hospital System. Convert this diagram .....
Recently Visited Pages
- Ahmedabad Study Centre – Vadodara - 0926 - P
Ahmedabad Study Centre – Vadodara - 0926 - P
SC CODE - 0926 - P
NAME & ADDRESS OF THE IGNOU STUDY CENTRE
DR. R.C. (.....) - Raipur Regional Study Centres
Raipur Regional Study Centres
SL. NO.
PLACE OF STUDY CENTRE
SC CODE (.....) - Jan 2001
Question Paper of CS-09 - Data Communication & Network of Jan 2001 from IGNOU
1 (i) Suppose that the Aloha Protocol is used to (.....) - CS-17 Project (Part-II)
Syllabus of CS-17 Project (Part-II) From IGNOU
CS-17 Project (Part-II)
Comment for CS-17 Project (Part-II)
-----------------------------------------------------------------------------------------
MCA Old syllabus
Please provide (.....) - IGNOU - AIRFORCE Recognized Regional Centres - ALLAHABAD
IGNOU - AIRFORCE Recognized Regional Centres - ALLAHABAD
Code - 64
SQUADRON LEADER AJAY KUMAR
SQUADRON LEADER
REGIONAL DIRECTOR
IGNOU - AIRFORCE RECOG REGIONAL CENTRE
HQ CAC, IAF
BAMRAULI
ALLAHABAD - 211012
UTTAR (.....) - MCA from IGNOU
IGNOU MCA section is the right place to get the complete details about this course.
Visit the section of IGNOU MCA, here you can find the (.....) - IGNOU: CWDL - Downlinking Study Centres
IGNOU: CWDL - Downlinking Study Centres
Certificate in Empowering Women through Self Help Groups (CWDL )
(.....) - MS-61 Consumer Behaviour
Syllabus of MS-61 Consumer Behaviour From IGNOU
MS-61 Consumer Behaviour (.....) - JUNE 2002
Question Paper of CS-12 - Computer Architecture of June 2002 from IGNOU
Note : Question one is compulsory. Answer any three from the rest.
1. (.....) - IGNOU: Karnal Regional Study Centres
IGNOU: Karnal Regional Study Centres
SL. NO.
PLACE OF STUDY CENTRE
SC (.....) - MCA CS-10 PROJECT Software Engineering
MCA CS-10 PROJECT Software Engineering
Course Code : CS-10
Course Title : Software Engineering
Assignment Number : MCA(4)-10/Project/04
Maximum Marks : 15
Last date of Submission : 30th October, 2004
This is a project assignment. Answer the following question. (.....) - DEC 1997
Question Paper of CS-54 - Finance & Accounting On Computers of Dec 1997 from IGNOU
Time : 3 Hours
Max. Marks : 75
Note : There (.....) - MCA CS-12 PROJECT Computer Architecture
MCA CS-12 PROJECT Computer Architecture
Course Code : CS-12
Course Title : Computer Architecture
Assignment Number : MCA (5)-12/Project/05
Maximum Marks : 15
Last Date of Submission : 30th April, 2005
This is a Project Assignment. Answer all the following questions. (.....) - Mauritius - 7201
International Partner Institutions of IGNOU in Indian Ocean Island Countries - Mauritius - 7201
Mauritius - 7201
Mascareigns Academy Of Law, Economics & Management (.....) - Ahmedabad Study Centre - Ahmedabad - 0916 - P
Ahmedabad Study Centre - Ahmedabad - 0916 - P
SC CODE - 0916 - P
NAME & ADDRESS OF THE IGNOU STUDY CENTRE
DR. UMA VIKRAMBHAI DESAI
PROG. (.....)
Tell Us in Details What You Are Looking for