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

    Most obvious example of this would be someone listening to FM radio in the midlands; the further he goes away from the midlands the more signal gets weaker. Microwave An electromagnetic based wave which has a range or wavelength of up to 30 GHz.

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

    No one individual should have unfettered powers of decision." The Combined Code 2003 S1A.2 Although it is possible for the chief executive to also hold the positions of managing director or chairman this principle is saying it is not the best idea for the company to have such a high concentration of power, it creates a huge control issue.

  1. Smart Card System

    In addition, ambiguities may arise in analyzing the log file format since field separator characters may in some cases occur within fields. Thus, the extended log file format is designed to meet the following needs: * Permit control over the data recorded.

  2. System I designed in order to produce a promotion package for her newly formed ...

    You can't edit calculated fields. � Locked or disabled fields. If a control on a form has the Locked property set to Yes or the Enabled property set to No, you can't edit the data in the field. � Fields in a locked record.

  1. Unit 6 - Advanced Spreadsheet Skills

    invoices * Automatically transfer invoice data to a summary sheet * Create pivot tables, charts and graphs * User friendly * Be easy to navigate around the system * Provide different types of prints They also want the system to be capable of calculating the following: * Total monthly sales

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

    Capture the essentials Many models consist of documentation for businesses, such as invoices, orders, receipts. If it only consisted of documents, what would happen if the business changes? Most businesses today are dynamic - meaning that they have to respond to increasing competition and to he changes in the environment around them.

  2. Internal Operations

    32 = 27 = 1 27 - 16 = 11 = 1 11 - 8 = 3 = 1 3 - 4 = 0 3 - 2 = 1 = 1 1 - 1 = 0 = 1 so 187 = 10111011 This means that hexadecimal is ( 8 + 2 + 1 )

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