Home   |   Register   |   Rules   |   Calendar   |   Get New   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Need Assistance for my Project 2

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-01-09, 11:01
MarineX MarineX is offline
Registered User
  
Join Date: Jul 2009
Posts: 24
Need Assistance for my Project 2
no further assistance...
Last edited by MarineX; 07-03-09 at 09:50.
Reply With Quote
  #2 (permalink)  
Old 07-01-09, 11:14
MarineX MarineX is offline
Registered User
  
Join Date: Jul 2009
Posts: 24
do correct me if im wrng. thanks
Last edited by MarineX; 07-03-09 at 09:47.
Reply With Quote
  #3 (permalink)  
Old 07-01-09, 11:40
MarineX MarineX is offline
Registered User
  
Join Date: Jul 2009
Posts: 24
can anyone assist me on it ? thanks.
Reply With Quote
  #4 (permalink)  
Old 07-01-09, 11:50
r937 r937 is online now
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,085
Quote:
Originally Posted by MarineX
Car Rental Agency (AgencyId, AgencyLocation, CustomerId)
this is wrong, because it means each rental agency has only one customer


Quote:
Originally Posted by MarineX
Car Vehicle Details (VehicleId, VehicleTypeId, VehicleType)
this is wrong because it fails 2NF

i'm not going to hand you the correct answers, you have to figure those out yourself
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 07-01-09, 12:01
MarineX MarineX is offline
Registered User
  
Join Date: Jul 2009
Posts: 24
Quote:
Originally Posted by r937
this is wrong, because it means each rental agency has only one customer


this is wrong because it fails 2NF

i'm not going to hand you the correct answers, you have to figure those out yourself
thanks... wad about this?
Last edited by MarineX; 07-03-09 at 09:47.
Reply With Quote
  #6 (permalink)  
Old 07-01-09, 12:30
pootle flump pootle flump is offline
King of Understatement
  
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
You fixed the problems Rudy mentioned but added a new one
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #7 (permalink)  
Old 07-01-09, 12:31
MarineX MarineX is offline
Registered User
  
Join Date: Jul 2009
Posts: 24
Quote:
Originally Posted by pootle flump
You fixed the problems Rudy mentioned but added a new one

so the above is correct right now ? including the ER Diagram?

i am wondering if its correct or not as i am taught only up to 4 of it. But right now i have 5.
Reply With Quote
  #8 (permalink)  
Old 07-01-09, 12:34
pootle flump pootle flump is offline
King of Understatement
  
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
Look again at Vehicles - do you think that looks right?
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #9 (permalink)  
Old 07-01-09, 12:35
MarineX MarineX is offline
Registered User
  
Join Date: Jul 2009
Posts: 24
Quote:
Originally Posted by pootle flump
Look again at Vehicles - do you think that looks right?
hmm.. r u refering to the diagram?

erm... shld i change agencyId to RentalId instead?

if it is... it makes me understand one more thing... your ER diagram reflects entirely the same as your NF, am i right to say that?
Reply With Quote
  #10 (permalink)  
Old 07-01-09, 12:39
pootle flump pootle flump is offline
King of Understatement
  
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
I'm referring to post #15.

Looking at your diagram, post #15 and the diagram are out of sync. Perhaps you should get one correct and derive the other from the correct one, eh?
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #11 (permalink)  
Old 07-01-09, 12:41
MarineX MarineX is offline
Registered User
  
Join Date: Jul 2009
Posts: 24
Quote:
Originally Posted by pootle flump
I'm referring to post #15.

Looking at your diagram, post #15 and the diagram are out of sync. Perhaps you should get one correct and derive the other from the correct one, eh?
so that means what i will be doing is to switch e diagram from Vehicles > AgencyId to RentalId yahs?
Reply With Quote
  #12 (permalink)  
Old 07-02-09, 21:09
MarineX MarineX is offline
Registered User
  
Join Date: Jul 2009
Posts: 24
Quote:
Originally Posted by MarineX
so that means what i will be doing is to switch e diagram from Vehicles > AgencyId to RentalId yahs?
Anyone care to help?
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.