• 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. Discuss the relationship that exists in the UK between the legal rules that govern ...

    shareholder interests as well as the company's interest it makes sure that directors are not taking unfair advantage of their position in the company. The Combined Code also goes on to look at director remuneration, the level and make up of remuneration saying that it should be sufficient to attract

  2. Unit 6 - Advanced Spreadsheet Skills

    This is the customer details page. As can be seen the colour and design is consistent with the menu page. This is very basic workbook the data was imported from another spreadsheet using excels import wizard and the macro was done as shown previously. This workbook is to very basic it contains the product details that

  1. Signal Theory

    Because no start or stop bits are involved data transmission is faster, but more problems occur because if latency takes into effect then the synchronization clock will be out of timing therefore the receiving node will get the wrong timings that have been acknowledged in the protocol sending and receiving data.

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

    Would it be easier if information was copied from table to table or was identified in different sections using the customer ID? -Yes -No 7) Does adding colour make the database more interesting? -Yes -No 8) Would it be a good idea if the database was made more realistic using 3D effects and interesting graphics and writing?

  2. Smart Card System

    The Smart Card is different. By using multi directional interaction between the card and the reader true authentication of identity can be met in a more powerful way that is much more secure than the traditional magnetic stripe card. The cardholders' identity is held on the card via a secret key.

  1. Internal Operations

    + ( 8 + 2 + 1 ) = BB 3) Using twos compliment, show how the two 8-bit binary numbers representing 68 and 112 can be added, subtracted and multiplied using the process of addition. Explain the meaning of "floating point number" and illustrate you answer with several examples.

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

    Dialogs, StdCtrls, Menus; type userrec = RECORD username: STRING[8]; password: STRING[6]; fullname: STRING[30]; end; userlist = ARRAY[1..1] of userrec; TFormLogon = class(TForm) EDuser: TEdit; EDpass: TEdit; BTclear: TButton; BTlogon: TButton; Label4: TLabel; Label3: TLabel; Label1: TLabel; MainMenu1: TMainMenu; File1: TMenuItem; Closewindow1: TMenuItem; procedure FormCreate(Sender: TObject); procedure BTlogonClick(Sender: TObject); procedure BTclearClick(Sender:

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