SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Nov 2006
    Posts
    206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question on database structure of multipule databases

    I work at a newspaper. As of now we have a database for classified ads and a database for subscriptions, and more databases to come.

    The question here is whether or not to combine the different databases into one in order to not have double entries and make it easier to enter data in each respected field.

    I built the Classified Ads database and my boss built the subscription database.

    The Classified Ads database has multiple tables
    One for customer information
    one for the ads
    and a multitude of others that won't help you provide input for me..

    One enters generic data into the customer information
    Name
    address
    city
    state
    etc...

    And in the ad table, the customer gets linked according to their customer id

    Now, if we wanted to incorporate the subscription database customer list with the classified ads so that the company has only one big list of customers which serve multitudes of database would it be wise to combine the customer list and then make the other tables do the work they are suppose to do... This seems to me like the logical way but I just want to make sure.

  2. #2
    SitePoint Addict
    Join Date
    Nov 2006
    Posts
    206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    P.S. The database is running on MYSQL with a MSACCESS front end

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by prince_mallow View Post
    Now, if we wanted to incorporate the subscription database customer list with the classified ads so that the company has only one big list of customers which serve multitudes of database would it be wise to combine the customer list and then make the other tables do the work they are suppose to do... This seems to me like the logical way but I just want to make sure.
    yes

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    SitePoint Enthusiast
    Join Date
    Oct 2006
    Posts
    85
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Even if your databases are located on different servers, you can use the Federated engine to communicate between them.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •