how to create this table in sql server ? : i fond it hard to create a table for this problem. can somebody help me?


You are the owner of some tables for Sweeney Tours that have been created for you already. They are: 
 
COUNTRY(country, language, timezone, currency)
 REGION(region, landtype, country, scenery, page) 
RESORT(resort, region, transfertime, beach, beachnum, page)
 HOTELS(hotelid, hotelname, sunbeam, ya, rating, stdbasis, page, resort, resortloc, roomtotal) 
FACILITIES(facid, description, category)
 FACINRESORT(resort, facid)
 FACINHOTEL(hotelid, facid, numof) 
 Each hotel has one standard meal basis on offer (stdbasis), always one of Half Board (hb), Bed&Breakfast (bb), Full Board (fb) or Apartment Only (ao). Some hotels are designated "Young and Active" (meaning ideal for 18-30 year olds) (ya). A few resorts cater particularly well for children by running a 'SunBeam Club' (sunbeam) where parents can leave their children. These clubs are associated with particular hotels in the resort. Each hotel has a distance from the centre of the resort included (resortloc). The transfer time from the airport to the resort is included (transfertime). 
 
Resort and/or Hotels have facilities such as swimming pools, discos, horse riding, waiter service, kids playgrounds, telephones in bedrooms etc. Facilities fall into a number of different categories: 
 
6 
accommodation a 
entertainment e 
sport s m
eals m 
children c 
bedroom b 