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).
I am an MCA student [Removed]
2  1649 
Kindly do not post home work questions here.
Please follow the posting guidelines in every new post/reply.
Regards
Debasis
JosAH 11,448
Recognized Expert MVP
Kindly do not post home work questions here.
And most certainly don't double post them. btw If the OP is a student, who is
this then:
I AM NIRMAL-C, AN LIC AGENT IN PAYYOLI,CALICUT ,KERALA.
kind regards,
Jos
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Jani Yusef |
last post by:
I have a HW problem stated as shown at the top of the solution. The
thing is is that I am not 100% sure wtf constant memory means. Well, I
think I do but I am confused. Does my solution use contant memory in
terms of the length of the list i? If so why not and how could I
change it to be so? I am sure the solution is O(n) since the list must
only iterated once and the dictionary is O(1), correct?
Thanks for the help!!
#You are given a...
|
by: Joel Finkel |
last post by:
Folks,
I am confused as to how to implement the following solution.
I have a series of processing steps, each of which contains similar features
(forms, etc). Therefore, I create a base class, Step, and subclass from that
for specific steps. The Step class has a method, Execute(), which can return
either Success or Failure.
I have a Step Driver, which instantiates the first Step, calls its Execute()
|
by: SP |
last post by:
Hi,
I want to add wait cursor code whenever page is post back. Page may be
post back on my user control's or on change of dropdown or on click of any
button on page. so is there any common solution available that will provide
me mechanism to display wait cursor or wait image to user whenever page is
post back to server?
Thanks,
|
by: moondaddy |
last post by:
I'm building a small POS system which I'm going to license out and need to
include credit card processing. I've build eCommerce sites before and
custom coded CC processing for verisign, but that was coded specific to the
clients needs and account with verisign. For this app I need a generic
solution where the customer can enter in the parameters for their credit
card processor and then be ready for business. I would also want a solution...
|
by: Tony |
last post by:
I have a situation where I want to send data, but I have no need for a
response. It seems to me that XMLHTTPRequest is the best way to send the
data, but I don't need any response back from the server.
Basically, I'm writing js errors to an error log on the server side -
and there is no need to inform the user that the error has been logged.
The problem is that I don't want to sit with the request open & waiting
for a response, when I...
| | |
by: vinod.bhavnani |
last post by:
Hello all,
I need desperate help
Here is the problem:
My problem today is with multidimensional arrays.
Lets say i have an array A this is a 4 dimensional
static array.
|
by: VB Programmer |
last post by:
Here's the scenario: 3 different pcs in a doctors office. 2 doctors with 2
seperate appointment calendars. All 3 pcs need to be able to see, real
time, both doctors calendars and add, remove, edit appointments.
Any suggestions on how to do this?
I was thinking of a web based solution where all appointments are kept on 1
pc using outlook. This pc auto-publishes the current calendar regularly to
a website. When users add, edit,...
|
by: Frank |
last post by:
I've done this a few times.
In a solution I have a project, Say P1, and need another project that will
contain much code that is similar to that of P1.
I hope no one gets hung up on why I don't somehow share the code.
So, I copy the folder P1 is in, change the new folder name, and is VS2005 to
change all occurrences of P1's name tp P2's name.
|
by: Jon Slaughter |
last post by:
I have some code that loads up some php/html files and does a few things to
them and ultimately returns an html file with some php code in it. I then
pass that file onto the user by using echo. Of course then the file doesn't
get seen by the user.
Is there any command that essentially executes the code and then echo's it?
something that will take a string like
'<body>blah<?php echo 'Hello'; ?></body>' and actually interpret the php
|
by: MZ |
last post by:
Hello,
I have a webcam connected to the Internet.
I can access the current static picture of the camera using an url link. It
shows the picture with high resolution 1600x1200.
I would like to have a batch program which will do what follows every some
amount of time:
1. save the picture automatically on my local computer (which will be always
running)
2. lower the resolution of the saved picture
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
