Hi all,
Help me to build a table structure having 3 tables. Let me explain.

The stream , Audio, Video tables are present. Stream table has the following properties:

Streamid, Stream name,Location, Program_Count

Audio table properties:

Audio PID,PCR PID,AUDIO TYPE, SAMPLING RATE,LOCATION

and Video table has the foll properties:

Video pid, pcr pid,resolution ,chroma format, Aspect ratio,framerate,mux. bitrate and Audio type.

Primary key is Steam id. Now how to link all the 3 tables.

Plz help.

I dont really understand what you are looking for. can you explain a bit clearer

do you mean linking them to make your query?

Here's a simple database based upon the fields you supplied. of course the field types may need altering and I've taken liberties in assuming that Stream is the parent of Audio that is the parent of Video. if none of these terms make any sense you aren't ready to mess with relational databases.

Cheers, Lol

Is your StreamID the super set of audio pid and video pid ?
if so, you are all set . You got the tables right.
if your question about creating foreign key constraints, you need to issue alter table commands on audio and video tables.

You should have a primary key for each table. You may consider using the primary key for each table as the foreign key to link with other tables. In other words, you will have an additional "parent id" field for referring to the primary key of the tables you want to link with.

i also need help

this stuff is hard ! =|

Originally Posted by Twine

i also need help ...
...this stuff is hard ! =|

Hi Twine - Don't feel bad, there are tons of ppl hear with good knowledge and resource who would be happy to help you out in any way they can. If you're stumped on a particular project or idea, feel free to post a question!

- It's a community here, and we're all happy to help

Twine, post your db problem and perhaps we can help. I'll be honest my db forte is Access and relational layouts in general so if that's what you need perhaps I can be of help.

Cheers, Lol