• Home   /  
  • Archive by category "1"

A Level Ict Database Coursework

6. Relational database

To overcome the limitations of a simple flat file database that has only a single table, another type of database has been developed called a 'relational database'.

A relational database holds its data over a number of tables instead of one. Records within the tables are linked (related) to records held in other tables.

The picture below shows two tables. The main one is called 'customers'. This contains almost the same fields as we have seen in the flat file database. But there is one key difference - the city is now held in a separate table called 'city'. The line between them shows there is a link (relationship) between a record in the city table and records in the main table.

 

Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Relational Database

 

 

 
  1. hi,. im currently doing an a2 ict coursework(AQA),. and im stucked at idntifying constraints imposed by the organisation.
    i was asked by my client to create an electronic employment form(application form),.
    btw my client is a manager in a store where they sell ink cartrdiges for fax,printers etc,..

    im clueless on what to write so if anyone has an idea can u pls share it im really desperate, deadline is 4days from now,..

  2. I taught this last year. This is the advice I gave my students. Hope this gives you some ideas.


    2.1.2 Internal Constraints

    In this section you need to set out any internal constraints.
    An internal constraint is something that can limit your ability to complete the project, but is something that you may have some control over.

    e.g.
    o Do you have particular software or hardware that you have to use and why? Perhaps the organisation has already licensed certain software and don’t want to buy other software or perhaps all their staff is already skilled in the software they specified.
    o Do you have a budget to work to? There may be only a limited amount of money to complete the work.
    o Do you have particular timescales in which to complete the work? For example, a till system would have to be complete by the date the shop opened.
    o Staff may have skills in particular software so you have to use that software to produce the solution.
    o You only have a certain number of staff available to you to complete the work.
    o Are there any particular procedures or ways of doing things within the organisation that you have to comply with?
    o Do you have any existing legacy systems that you have to integrate with?

    2.1.3 External Constraints

    In this section you need to set out any external constraints.
    An external constraint is something that is outside of the business and that you may have no control over.

    e.g.
    o Your work may be required to be compliant with acts of law such as the Data Protection Act, Copyright and Patents Act and Disability Discrimination Act. You could explain what parts of your system need to comply with these laws and in what way.
    o You may have to wait for delivery/installation of something at some point in your plan. If that is delayed the project will be delayed. E.g. in a building project, the installation of the roof would be critical as inside work could not start until this is completed.
    o Are there any external systems that you need to exchange data with in a particular format?


    Things to consider for both internal and external constraints are:

    o Hardware
    o Software
    o Communication technologies
    o The format of information requirements
    o Finances
    o Staffing
    o Environmental factors

  3. now i have something to start with ,..thanks very much sir,. it helped a lot,...

One thought on “A Level Ict Database Coursework

Leave a comment

L'indirizzo email non verrĂ  pubblicato. I campi obbligatori sono contrassegnati *