Member Avatar for msundastud

trying to create a 3NF database given a classic car database with members name, contact info and car.

need to know stuff....

members have more than one car
more than one member can have the same car
be able to find the club member of each car
able to find car of each member
include necessary and primary keys
must be able to select a model car and find all members who have that car

  • 2 Contributors
  • 1 Reply
  • 52 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for dickersonka

table names are the top row of each set, each first row is a primary key

members
member_id
first_name
last_name
zip

zipcodes
zip
city
state

cars
car_id
manufacturer_id
car_model

carmanufacturer
manufacturer_id
manufacturer_name

membercars
member_car_id
member_id
car_id

if you need to be more specific and need more help let me know

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.