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.

Dig Deeper on Oracle development languages

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.