close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Premiere Ticket other Questions...

Thread began 8/31/2011 5:42 am by Sly Verano | Last modified 9/26/2011 10:51 am by Sly Verano | 1537 views | 9 replies

Sly Verano

Thanks Jason for a very clear explanation.

  in a mysql database, all of your tables will have a primary key column.

for the classes table, there will be a primary key column that uniquely identifies the class.

for the student table, there will be an ID column that uniquely identifies the student.

In MySQL you use these ID values to create relationships between the data.  



In my class table I have 3 primary keys ... those are (PKsecSectionCode, PKsecSectionSchoolYear,PKsecSectionSemester) because in every school year and semester the SECTION CODE of the class is repeating. for example (the section code is:M001, SY is 2011-2012, let say the semester is 1st Semester) ...

and when the 1st Semester is already finished,.. there is a 2nd semester so (SECTION CODE is M001, SY is 2011-2012, SEMESTER IS "SECOND SEMESTER")

So to avoid the duplication of the Row I used multiple PRIMARY KEYS of the my Class table.

------------------------------------------------------------------------------

1.) Is my class table structure for my database is correct ? because this is my first time to used the MULTIPLE PRIMARY KEY in a table.


2.) Now I want to join this MULTIPLE PRIMARY KEY table to other tables ... can you help give me some PATTERNS AND HINTS in JOINING A TABLE (already have the relationship of my tables)
...
-------------------------------------------------------------

THANKS IN ADVANCED ... :)

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...