• 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. System I designed in order to produce a promotion package for her newly formed ...

    It's easier to draw details at 200 percent. � Use the Freeform button instead of the Scribble button. � Try setting your mouse to the slowest tracking speed available in Windows Control Panel. You have greater control when you draw at a slow speed. � You can adjust the shape of freeform to make them look smoother.

  2. Unit 6 - Advanced Spreadsheet Skills

    the customer's ID number, the amount of products sold individually and overall it must also contain the amount of money the company has made.

  1. Signal Theory

    Advantages of using synchronous transmission are that lower overhead and more data can be transmitted and data transmission rates are also faster. The drawbacks of using synchronous transmission is obviously more prone to problems, it is more expensive and more complex.

  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

    When complete algorithm-independence is not possible, the JCA provides developers with standardized algorithm-specific APIs. When implementation-independence is not desirable, the JCA lets developers indicate the specific implementations they require. 2.5 JavaTM Cryptography Extension (JCE) 1.2.1 The JavaTM Cryptography Extension (JCE)

  1. Internal Operations

    - 2 = 1= 1 1 - 1 = 0 = 1 so 27 = 00011011 in 8-bit binary This means that hexadecimal is 1 and 8 + 2 + 1 = 1B * 187 - 187 - 128 = 59 = 1 59 - 64 = 0 59 -

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

    / EVALUATION OF IMPLEMENTED SYSTEM / / User Documentation * Installation * Use / Index / Bibliography / This gant chart illustrates the intended time period it will take to complete the different sections of my project. By following a gant chart it is easier to plan how long each

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