Note : you may use illustrations and diagrams to enhance
explanations.
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 center 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 Description
Distribution outlets It includes outlet code, outlet name, outlet
address, list of car models, sales made for each model etc.
Factory 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 in a single Car unit, and quantity in stock, time taken
to produce a batch of 100 corset. This information is stored factory
wise. Each factory will have separate minimum stock and reorder level
based on its capacity.
Batched order It includes details on overall sales of cars at various
outlets; all such sales are put together to generate a consolidated
order 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 minimized. Proper reorder level 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 mca student need answer before 30 oct 04 ,help me thanks 0 2143 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Alex_Bxl |
last post by:
Hi to all
I have to choose a DBMS and a database architecture for an Ebay like
website about to be launched.
The company wants to use a web hosting service and not host the
database on dedicated servers at the office.
The database will contain web-only information and lots of back end
information that is not really needed to be stored on the web host.
|
by: Fred the man |
last post by:
Hi,
Some of our customers have remote offices. I was wondering if it'd be
safe to have a DBMS running at their central office, and have our
client application running on hosts in the branches connect to it
through a VPN via the Net?
What happens if the connection goes south while a branch office was
making changes? Does the DBMS just rollbacks changes automatically
after a time-out?
|
by: Albretch |
last post by:
.. Can you define the Character Set for particular tables instead of
databases?
. Which DBMSs would let you do that?
. How do you store in a DBMS i18n'ed users' from input, coming over
the web (basically from everywhere) store it and properly serve it
back to users, . . .?
. Can you point me to info on this?
I would preferably use Java/JDBC drivers.
|
by: Remco Groot Beumer |
last post by:
Hello,
I'm trying to decide if the following situation would be workable:
Generate an MS Access Front End (which will run localy on client computers),
which will link to a DBMS (SQL server or Oracle). As far as I know there
will be approx. 30 till 40 users max working on the database. I think
approx. 25 users will actually enter data (others will be mostly reporting
and viewing).
I don't really know the network capacity.
|
by: Dave |
last post by:
Hi
I have been asked to implement an error logging/management database for the
network technicians in our company. The idea is that staff using
workstations can enter a database and log any problems they are having,
while the technicians can pull off details of faulty equipment. The users
will have little experience of databases so the system needs to be
customized to allow users access to facilities via simple a gui. The network
is ...
| |
by: Remco Groot Beumer |
last post by:
Hello,
In regards to my previous posted mail on this topic: thanks for the
feedback. The 30% is told to me by a collegea. .NET is not my working area,
but it's something our company provides. So i'm just looking for our
options.
Besides the 30% more work issue I'm mostly interested in the possibility of
an Access versus DBMS (SQL server) and how this will work with 40 users
(front end locally on each client). Another question that...
|
by: news.bahnhofbredband.se |
last post by:
Some time ago I was working with DB2/400 - and one of the most appreciated
features was the concept logical files - a bit more than views in that they
maintained an access path. That is it maintained an index of the records in
the physical table(s) depending on specified view selection criteria -
including order of records.
Some time ago I was about to create an Oracle based application and the
Oracle person in the project maintained...
|
by: Tonny Iversen |
last post by:
Hello. I haven't used NetBeans yet and I haven't programmed much Java (I've programmed more in C++), but I have a question:
Can I get a data consistancy guarantee when writing to a file from Java if I use the NetBeans IDE package without using a large DBMS?
I mean, does Java standard classes or some NetBeans packages support some kind of simple transactional database / ACID support or similar? Or maybe some good third-party packages can do...
|
by: AmberJain |
last post by:
Hello,
My new semester has started and I have a subject named DBMS (Database Management System). This is the first time I'm studying databases and so I'm not feeling very enthusiastic about databases (partly because I already had learnt C/C++ and I feel that programming is a lot easier that DBMS). Nevertheless, I must learn at least one DBMS as it is part of my college course. I'm confused and I want some suggestions:
Que-1: There are a...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |