SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jun 2004
    Location
    wales
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with database system architecture

    Hello,

    If there are any wizzes out there that can point me in the right direction over this question i am stuck in a rut with it.

    I am aware of several different architectures client surver (single), client surver (multiple), stand alone pc, and web based, but i cant think how each of them are relived to the below question.

    As i say any pointers or links to relivent tutorials would be very much appricaiated, thanks for reading and the question i have typed below;

    For each of the following examples, choose an appropriate database system architecture to satisfy the main system requirements. Name the system components of your choice and explain the reason for your choice concentrating on SQL API issues. You MAY indicate one second alternative solution, but you need to indicate your preferred choice.

    (a) Software House developing a standard application for a 'Job progress monitoring and job accounting system". The system has to be able to handle up to 50000 new jobs a day. Some functional customisation for each individual client is expected.

    (b) A Market Research company requires a generic questionnaire analysis application. It is envisaged that for each type of questionnaire a database with questionnaire results will be created and the query tool will provide end users with a logical view of tables from which they can select required tables and columns and combine them to run analytical queries.

    (c) Reporting System for a Chief Executive reading data from a variety of data sources, i.e. different databases as well as non-database sources.

    (d) Car Management and Car Booking System for a major international car hire company with franchised outlets at all European airports and most European cities. Customers are able to book cars for any location in the franchise either in person at any franchise, by phone via a central call centre or directly via the internet.
    It is company policy to always accept customer bookings made at least one week prior to the required date and ensure availability from the international pool of cars. This requires intensive "Car Management". Bookings within 7 days will only be accepted it the local franchise has the car available.

  2. #2
    SitePoint Wizard
    Join Date
    Jul 2003
    Location
    Kent
    Posts
    1,921
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Put yourself in the position of the system user and ask yourself what you'd need, how you'd best access the data, who else would need access to it and so on.

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,340
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    (a) foxpro on a dedicated linux machine
    (b) microsoft access on a virtual private network
    (c) oracle enterprise on the ceo's laptop
    (d) this will only work with dot-net technology

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


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
  •