sure feel free
it won't be that hard once you get the concept

for your new questions close out this thread and start a new one

look forward to your new questions

keith

area codes are a little tricky and sort of hard to get a direct correlation with a physical location

i think it would be best to leave them separate

for example atlanta has 3 area codes, but...

Lol always helps to have a second set of eyes.

Sure just give the link for your new diagram and i'll check it out.

yes sequential inserts into the rest of the tables after user, the ripple effect you are wanting, is only on updates and deletes, you can't necessarily insert and populate tables the way you are...

sorry i mistyped my id from before, you were correct, it should be 1 2 3

also your city, country, and area code tables are out of sync

the way you have it, a city could have a different postal code, different country and different area code

the relationship should...

yes, you can drop users_airports_link

i don't know which 3:37 post is, but i assume its the one with the data

airports
aid airport code
1 hartsfield ATL
...

i thought this meant airports have different services

this table structure can be used, or you can use this one

userairportservices
user_airport_service_id
user_id
airport_id
service_id

the airport services will have something like this

as_id a_id s_id
1 1 1
2 1 2

services
1 movies on board
2 international flights

yep that looks good, the other way to do it would be to replace user_id in user_airport_services with user_airports_link, but there could be a constraint violation if the user was ever removed from...

create two tables, airportservices and userairportservices

airportservices
AIRPORT_SERVICE_ID
AIPORT_ID
SERVICE_ID

userairportservices
USER_AIRPORT_SERVICE_ID
USER_ID

you should do this code side, rather than database side

34 = 00034 as far as numeric terms

if you want it display that way in a query use leading zeros

here's how to do it in sql server...

i agree, would also add clientpets to bookings / volunteers

I will help, not do assignments, what specific pieces are you having trouble with?

Also what is background and skills in the volunteers table?
One more, where did the relationships table go? ...

you can just use this post here, so everyone can benefit from it and be able to offer you advice

ahhh, now with the document i see how volunteers are related


volunteers
VOLUNTEER_ID
NAME
TELEPHONE
ADDRESS

volunteerservicesprovided

then this table structure should work for you

very clear question and thanks for showing your effort and what you are having trouble with

i'm not too big on vocabulary, but you want to try to get the database to use third normal form
...

If you have functionality in the exe then go the webservice route

If you have display then use php or html, for that

Here's a sample of php calling C# web service...

An option could be to change your exe to a web service. Communicating with an executable from a web application and distributed application is not something you normally want to do and super...

google is your friend, try this one
http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

bill table should not have a primary key of patient
a patient will have multiple bills
that patient should not have a column of pbill, unless it something associated with the patient

move pbill...