db normalisation

fotoart's Avatar, Join Date: Apr 2009
Light Poster
hello evevryone

im trying to normalise my db.

Im stuck at an instance where i find that a certain column (info)
is appearing at every table.
What should I do?

my db is about a movie album
the problem is every movieclip has a caption and also an info page which
is appearing in every table.
And each of these captions and info comes in different languages. lets say english, french german and so on.

any idea how I can go about setting up the tables?

any help would be appreciated.

I happen to know the basics of normalisation
and I can resolve the matter without the langugaes table.

thanx
ahmed
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Have a Movie ID which stores the caption and info page into separate table and not in every table
fotoart's Avatar, Join Date: Apr 2009
Light Poster
Hello Shabir
thanx for the reply.

Idont know how I can set up a separate
table for fotos.
my db is about hotels and their amenities/services.
for simplicity I have created few tables as follows


-------------------
Hotels
-------------------
Hotel A
Hotel B
Hotel C


-------------------
GuestRoomTypes
-------------------
Grand Suite
Presidential Suite
Classic Suite
Deluxe Suite



-------------------------------
Hotel-GuestRooms
-------------------------------
Hotel A, Grand Suite
Hotel A, Presidential Suite
Hotel B, Grand Suite
Hotel B, Presidential Suite


---------------------
Activities
---------------------
catamaran Sailing
water Skiing
table Tennis
Tennis
Golf



Hotel-Activities
-----------------
Holiday Inn, Catamaran sailing
Shangri La, Golf
Shangri La Tennis



--------------
photos
--------------
????


Can u help me setup the fileds for the photos table.
I have tried few ways and didnt workout.

thanx
ahmed
fotoart's Avatar, Join Date: Apr 2009
Light Poster
Sorry heres a correct version of the post

Hello Shabir
thanx for the reply.

Idont know how I can set up a separate
table for fotos.
my db is about hotels and their amenities/services.
for simplicity I have created few tables as follows


-------------------
Hotels
-------------------
Hotel A
Hotel B
Hotel C


-------------------
GuestRoomTypes
-------------------
Grand Suite
Presidential Suite
Classic Suite
Deluxe Suite



-------------------------------
Hotel-GuestRooms
-------------------------------
Hotel A, Grand Suite
Hotel A, Presidential Suite
Hotel B, Grand Suite
Hotel B, Presidential Suite


---------------------
Activities
---------------------
catamaran Sailing
water Skiing
table Tennis
Tennis
Golf



Hotel-Activities
-----------------
Hotel A, Catamaran sailing
Hotel B, Golf
Hotel B, Tennis



--------------
photos
--------------
????


Can u help me setup the fileds for the photos table.
I have tried few ways and didnt workout.

thanx
ahmed
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Ahmed

I assume

Hotel A
Hotel B
Hotel C

and

Grand Suite
Presidential Suite
Classic Suite
Deluxe Suite

Are ids and not the data.

If that is the case Have a Table where your unique identifier is the identifier of the photo.

Photos
--------
Photo Id Photo Data

And then Photo Id should be mapped to Hotel / GuestRoomTypes and other things.

Also Just a note never have the table name as plurals
fotoart's Avatar, Join Date: Apr 2009
Light Poster
shabir to make things clear, they were actually data

the tables with unique IDs are as follows



--------------
Hotel
--------------
hotelID, hotel




--------------------
roomType
--------------------
roomTypeID, roomType




--------------------
activity
--------------------
activityID, activity




they are all m:m tables
So I made join tables like so

------------------
hotel-roomType
------------------
hoteldID, roomTypeID


------------------
hotel-activity
------------------
hotelID, activityID




my problem is setting up photo table

for instance there can be a unique ID but what comes next?

photo
------------
photoID,???

thanx for the help
ahmed
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Photo Id and Photo Content like URL / FilePath / Binary Data
fotoart's Avatar, Join Date: Apr 2009
Light Poster
hello Shabbir
Once again thank you for helping me out.

What u recommended sounds right. But the part I dont understand is just giving a code and entering a photo.
For instance, I cannot say photo 001 and enter it in the photo table. it will be lost forever.
I know the URL will be there but u cannot associate it with any table.
There will be no way of mapping it to another table.

In other words photo table will not be proper with a uniqueID and a url.
I hope u under stand what im sayin.

thanx
ahmed
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
001 photoid should be mapped to Some HotelID in other table.