• 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...

Introduction

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.

Middle

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.

Conclusion

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. Different ways of data capture

    stops operating then it may not be possible to access various hardware and software resources * The efficiency of the network is very dependant on the skill of the system manager * It is difficult to make the system secure e.g.

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

    This is to keep the management fresh as well as to allow the shareholders to have their opinion on a director who they do not think is acting in the best interests of a company. Going back to the fifth principle of the code; "The board should be supplied in

  1. Spare Parts Database Project

    Add all records except 'Item code' and click on 'Save' A message box must appear saying 'Item code' OK 9 Click on 'Add' command button. Add all records except 'Customer code' and click on 'Save' A message box must appear saying 'Customer code' OK 10 Click on 'Add' command button.

  2. Unit 6 - Advanced Spreadsheet Skills

    * Average sales per month * Maximum and minimum sales per box size * Monthly income per box size * Annual income * Profit and lose The spreadsheet will consist of the following worksheets: * Main Menu * Invoice page * Customer Details * Product Details * Order Details * Summary Page 7.

  1. Signal Theory

    Synchronous It does not use start or stop bits but instead it synchronizes the transmission speed with receiving and sending end of transmission using the clock signals specifically built for each of the components. After this constant streams of data are transmitted between two sources.

  2. Basic Database Building

    The database works on the principles of one to one relationships, the one to one being because the individual members can only use any one piece of sports equipment at any one time. This is the same for their ID, as only one of these can be possessed.

  1. You have been asked to create a database to handle various account combinations of ...

    This is to say that if a set of models represent the same thing then it should be possible to put them altogether without introducing inconsistencies. Reduce complexity To deal with systems not too complex to understand directly by breaking them up into more manageable parts and separating out a

  2. Smart Card System

    divisible by (p-1)(q-1). We define E_K(P) = P^e mod pq, D_K(C) = C^d mod pq. All quantities are readily computed from classic and modern number theoretic algorithms (Euclid's algorithm for computing the greatest common divisor yields an algorithm for

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