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

Features of database design

Extracts from this document...

Introduction

´╗┐Database Design P1, M1 Unit 18 ? Database Design ________________ Contents Understanding the features of a database???????????????.????????2 Relational databases?????????????????????????????.????2 ? 4 Primary and Foreign Keys??????????????????????????????3 ? 4 Referential integrity???????????????????????????????????..4 Types of relationships????????????????..??????????????????5 Understanding the features of Databases A database is basically a collection of data that can include information on people for example names, telephone number or address. It could also include information on things such as the quantities of something, the status or location. Normally a database is organised by fields, records and files. A field is a column; a record is a row; and a file is a complete set of records. A good example of this is a telephone book apart not being a file it does contain a list of records with each normally or at least commonly consisting of three fields which are the name, address and phone number. A second example of a database or at least what can be used to make a database is the software Microsoft Excel, It contains columns and rows which make it a good choice for making a simple database. Below is an example of a Microsoft Excel database ? This is a database that shows students that are enrolled at a collage. There are many forms of databases the two examples above are two of the more well-known ones. ...read more.

Middle

Tables - The tables in a relational database is set out in rows and columns. For an example of a table, the image above shows how the table is set out with the fields, rows and colons. A table is also just another term for relations. Primary Key and Foreign Key The primary key is what sets up the relationships within the database. The primary key must be unique so the attribute must not repeat which means it will normally be a number of some kind for example if the Table was to keep a record for students the student ID would be used as no student will have the same ID as another student. The primary key defines the relationship with multiple tables by becoming a foreign key in the next table so they link, the foreign key will remain the primary key in the first table. I will use the same example as above to show primary and foreign keys. This is a one-to-many relationship Here you can see the Primary keys in bold are ?Customer ID? for the customers table, ?OrderID? for the orders table and for the order details table the key is ?ProductID? For the relationship to work the primary key must be in the next table and be a foreign key, this is what gives the database its referential integrity. ...read more.

Conclusion

A one-to-many relationship is created if only one of the columns is a primary key. Many-To-Many Relationships ? In a many-to-many relationship a row in ?Table A? will have more than one matching row in ?Table B? and the same will be said the one other way round as in ?Table B? will have more than one matching row in ?Table A?. This is possible by creating a third table called a junction table where the primary key consists of the foreign keys from the first two tables. For example, the Authors table and the Titles table have a many-to-many relationship that is defined by a one-to-many relationship from each of these tables to the TitleAuthors table. The primary key of the TitleAuthors table is the combination of the author?s table?s primary key column and the Titles table?s primary key One-To-One Relationships ? In a one-to-one relationship a row in ?Table A? will only have one matching row in ?Table B?. A one-to-one relationship happens is both of the related columns are primary keys. This is the relationship that gets used the least because most information that is related with the same primary key would most commonly be in the same table. Some of the reasons a one-to-one relationship is to be able to divide a table with many columns or store data that is not going to be used for long and can deleted easily. Benjamin Milner ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Database Analysis & Design

    The stages within DSDM are, * Feasibility * Functional Model Iteration * Design & Build Iteration * Implementation These are the typical stages within this methodology and they run in this order, however the order can be re-visited and stages can be done many times.

  2. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    code to represent a particular product Presence Check Name Text 50 The name of the product which the ProductID represents Presence Check Colour Text 10 The colour of the particular product Presence Check Stock Number Long Integer The number of stock available of the product Presence Check Price Currency The

  1. User Guide to my minibus hire database.

    - Beside the "Email" label there will be a data entry box, type in the customers contact email into this box. Adding Minibuses From the Home screen menu click on the "open minibuses form": Once on this form, click on the Add record button and this will bring up a

  2. Health Book

    had agreed to sign the Memorandum of Understanding with Telstra. This memorandum was an agreement for Telstra to deliver a suite of national e-health solutions and services (see figure 1 and 2 in appendix for latest ideas). Telstra Business Groups' Managing Director, Deena Shiff, added to this announcement that "the

  1. Employee attributes and their value

    Their employees have a bigger workload shared by a smaller number of employees. An employee who is lazier than the others will hold back the progress of the company. There is only 1 financial manager in IT services. He has to deal with the financial matters himself and get the job done.

  2. Website Design, Creation and Evaluation

    The site will be themed around that of an e-business website. It will be tested extensively before the next step of publishing the site to a web server. From this point the problem of re-testing and maintaining the site will arise. This will require the creation of a Maintenance Plan.

  1. The different aspects of the design of my website for Hatch end cars.

    will also have a drop down list to allow user to choose the option they want. To make the website recognisable I will add a logo. The font style for the text (Online Help) will be times new roman and the font size will be 32.

  2. Evaluation of the database

    I detailed in the user documentation how graphs could easily be created in step-by-step form and tested that they could be successfully created. * An interface page with the school logo must be used to incorporate school image. I did create an interface page and included the school logo on it.

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