Q
Problem solve Get help with specific problems with your technologies, process and projects.

Connecting tables in a database

SQL Expert Rudy Limeback gives advice on finding information on primary and foreign keys to connect tables in a database.

I am making a database for billing system in a photo shop. The different tables are cashier, assistant, job order, picture, customer. My problem is that I can't find a proper way of connecting the different tables in my database. I need to find a way to link them together for the database to connect, thus my dilemma. Could you please give me your advice on how I should go about connecting this database? Thank you for your time.
My advice is brief and simple: read some tutorials on primary and foreign keys. If you pop that phrase into your favorite internet search engine, you will get many excellent results.

If your question didn't sound so terribly much like a homework assignment, I'd say more.

Here's a tip: when you start looking through the search engine results, if the first thing you see when you visit the site is a lot of ads, then that tutorial is probably not very good. Try the next one.

For Oracle tutorials on SearchOracle.com, check out the learning guides in our Oracle tutorial library.
This was last published in June 2008

Dig Deeper on Oracle development languages

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close