Re: er-diagram

#1

hi,

i am checking up ur ER diagram in the car maintainence. u have
given that there is an attachment and there is nothing. so can i
see the attachment from somewhere else or can i receive a mail
from u. if possibe ER model for also the car rental one.

Hope to get a reply from u soon.

cheers,

Elangovan Hariharan.

Originally posted by Chris

Quote:

Hi, I've got the following er-diagram, entities and attributes (see
attachment)

according to the following interview it is a car company: Is my work
correct?

Thanks for your help

Chris "Cars are uniquely identified by their registration number.
Other data

of interest concerning our cars includes: year of manufacture,

manufacturer and model, kilometres travelled, date last
serviced (so we

can tell when a car is due to be serviced) and comments on the

condition of the car. Additionally, each car is classified into one

particular type. The types of car we have are listed below:

small manual

small automatic

medium manual

medium automatic

large manual

large automatic

commercial vehicle

We work with different service centres. Each service centre has the

capacity to service any of our cars. Service centres are
identified by a

unique number. We also require details about the service centre such

as: name, address, telephone and contact person. We personally

choose a particular service centre at a given time based on a
number of

factors which are not required to be stored in the system. When a

service centre is chosen, a booking is made with that centre. The

information we require about these bookings includes: car registration

number, service centre number, date in, date out, service details,

amount due and amount paid. So that I check if a car is available to

be serviced, I need to be able to view the following data about client

rental bookings for cars - car registration number, client
number, date

out and date due."

--
Posted via http://dbforums.com

#2

On Sat, 06 Sep 2003 05:40:14 -0400, helango wrote:

Quote:

i am checking up ur ER diagram in the car maintainence. u have given
that there is an attachment and there is nothing.

Could ya learn to write, and then ask for someone to do yer
homework done elsewhere?

--
_ Leandro GuimarÃ£es Faria Corsetti Dutra +41 (21) 648 11 34
/ \ http://br.geocities.com./lgcdutra/ +41 (78) 778 11 34
\ / Answer to the list, not to me directly! +55 (11) 5686 2219
/ \ Rate this if helpful: http://svcs.affero.net/rm.php?r=leandro

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: er-diagram

comp.databases.theory comp.databases.theory

Re: er-diagram - 09-06-2003 , 04:40 AM

Re: er-diagram - 09-06-2003 , 07:50 AM