• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Purposes and Features of a Relational Database

Extracts from this document...


3 Contents Introduction- What and Why - 3 Purposes - 4 * Manage details and data * Allow easy access and addition * Increase company operations rate * Discover Data Discrepancy Features- * Tables, Records & Fields o Relationships o Normalisation o Field Properties o Key Fields o Relationship Properties o Errors * Queries * Forms * Reports * Macros Conclusion Introduction - What and Why? What? Data is stored in an organised manor in a Database. This is useful for finding data by searching exact terms. "A database is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data according to a database model. The model in most common use today is the relational model. Other models such as the hierarchical model and the network model use a more explicit representation of relationships". The Relational model is subject in question. Good modern examples of relational databases are MSA, Oracle and MySQL Databases. The most commonly used in large business situations are Oracle and MSA, websites such as eBay tend to use MySQL, however in most small business and personal situations Microsoft Office Access will be used. ...read more.


It is a powerful and valid function within a database and is often a useful step towards Normalisation. Sometimes a database can be connected in a different way- Normally it will be a one to one relationship (linking two fields from two different tables together), however sometimes a one-to-many relationship is required- for example if a store has many customers- a one to many relationship will be required so that each store will have every required detail about the customer linked to it. Also Many-to-Many Database Relationships exist, for example if many customers have a Merlin Pass; they will go to many parks, and in this case many to many relationships could be needed however they can mostly be overcome by creating another table that can hold bridge the gap so that only one to many relationships have to be used. Especially seeing as how some databases do not allow many-to-many, or cannot support them very well. Normalisation This process has four goals 1. Arrange the data into easy to access and logical groups 2. Minimising the amount of duplicated data 3. Creating a database in which you can easily and quickly change and access the data- without compromising structural integrity 4. ...read more.


A Query is simply based on a series of values that grab the required data from any table into a new and condensed as required table. Very often new queries need to be made to get data in new ways, however this can also be achieved through revision of older ones. Reports A report is simply a way of displaying specific data, most of the time from queries, and presenting it with custom text and pictures. For information on selecting the data for a report - see Queries. These can be printed off or sent in email, for easy reading. These are intended for presentation and display mostly. Macros Macros perform mundane and often forgotten functions quickly and simply without using too many resources, be they human or computer. They are a simple set of instructions the computer must follow in order to perform tasks that have to be done repeatedly, for example, deleting redundant records and keeping the database clean. Databases are large and complex, both in theory and in implementation. I hope this report has helped you to understand the purpose and features of a database. Nick Hutchins - P1 - M1 - M4 ?? ?? ?? ?? Advanced Databases 1 Nick Hutchins ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Discuss the relationship that exists in the UK between the legal rules that govern ...

    should appoint new directors whereas company law suggests that appointment should be by the general meeting. Other legal rules on this point are stated in The Companies Act 1985; S292 says that they are not to have been "disqualified" it also states that anyone over the age of 70 cant be appointed to the board of a plc.

  2. Different ways of data capture

    comp capacity overnight or at times when the comp would be idle. Batch processing is often carried out on mainframe computers. Many applications use a combination of batch and interactive processing! DISSEMINATION + DISTRIBUTION Dissemination of Information Characteristics of good information Computers are capable of generating unimaginable amounts of data.

  1. I have been given the task to design a database for a company called ...

    * Price lists which specification says must be included. This will be used for hard evidence on the prices and may be used when re-pricing the cost of sending parcels. * Manager's statistics which were also specified in the specification. METHODS OF DATA ENTRY The user only needs to enter data into the database about the customer, parcel, destination and order.

  2. Signal Theory

    Benefits of using asynchronous data is that it works out cheaper because timing is not that important and it is also simple because both end do not require synchronization. Drawback are that if a large amount of data is to be transmitted it would take a long time this is

  1. Spare Parts Database Project

    SYSTEM TESTING When the system is complete, the whole range of tests will be carried out again to ensure that no errors have been introduced. RECOVERY TESTING The computer will be re-booted while the database is open to ensure that data is not lost or corrupted in the event of a power of a power failure.

  2. Smart Card System

    inter-application security protection mechanisms and bootstrapping the software downloading process; 3.5 Prepaid Smart Card Techniques A prepaid smart card is a kind of technology that can contains stored value, which the person holding it can spend at retailers. A system provider is used to let the retailers to reimburse the actual money after they accept the stored value from card.

  1. CP3 - Proposed Solution to a Realistic Problem - Apartment Administration software

    ELSE BEGIN FormPassword.Color:=clRed; // Change background colour to red ShowMessage('New password must be the same'); // If new passwords do not match then notify user END; END; EDpw.Text:=''; EDnewpw.Text:=''; EDnewpw1.Text:=''; FormPassword.Color:=clBtnFace; // Clear edit boxes and reset background colour end; procedure TFormPassword.BTclearClick(Sender: TObject); begin EDpw.Text:=''; EDnewpw.Text:=''; EDnewpw1.Text:=''; // Clear edit

  2. Definition-nature of the problem solved - Car Mechanic business

    there car can be seen, without wasting their time because of a lack of space or time. Data Flow of Current System Inefficiencies and Problems As mentioned earlier under current method used there were a number of inefficiencies present. The most important of these are listed below 1.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work