SS S06 C39 01

Information about SS S06 C39 01

Published on November 12, 2007

Author: Boyce

Source: authorstream.com

Content

Advanced relational databases:  Advanced relational databases ER modelling:  ER modelling ER modelling is the process of identifying the: entities needed nature of the relationships between them primary and foreign keys other ‘non-key’ attributes. Many relational databases consist of three tables (as with the Video database), although modelling 4 or 5 entities may be required. Normalisation:  Normalisation Normalisation is the process of ensuring that a relational database conforms to certain rules that ensure that the database is as efficient as possible. There are a number of rules and, when all of these have been followed, the database is said to be normalised. There are several layers of normalisation: For A level, you need to go up to third normal form (3NF). Normalisation can be used: to turn a flat file into a relational database to ensure that a relational database is set up as efficiently as possible. First Normal Form (1NF):  First Normal Form (1NF) Reduce entities to 1NF by removing repeating attributes. Ensure that every record is uniquely identifiable – this might mean adding a unique attribute such as an ID. Ensure every attribute is unique – there should only be one instance of an attribute in each entity, i.e. Video hired (1), Video Hired (2) will not work. RENTAL version 1:  RENTAL version 1 This table shows a first attempt at creating the database RENTAL version 2:  RENTAL version 2 Changes made to make it 1NF:  Changes made to make it 1NF Rental ID has been added to uniquely identify every rental made. Repeated attributes Video Hired 1 to 3 have been replaced by a single attribute Video Hired. This uses the Video ID which has been created from a new entity that stores the video data. The Video ID is the primary key in the VIDEO entity and the foreign key in the RENTAL entity. Additional non-key attributes have been included in the VIDEO entity. Customer ID has also been added at this stage to ensure that each customer can be uniquely identified. Second Normal Form (2NF):  Second Normal Form (2NF) Remove attributes that are not wholly dependent on the primary key. The non-key attributes are all the other attributes not used as keys. These need to be in the correct entity. Any attribute that is not dependent on the primary key should be moved to another entity. In this case, the Customer ID is in the RENTAL entity is not dependent on the Rental ID so it should be moved. Changes made to make it 2NF:  Changes made to make it 2NF A new entity, CUSTOMER is created: CUSTOMER Third Normal Form (3NF):  Third Normal Form (3NF) Reduce 2NF by removing attributes that depend on the primary key of another entity. This means that every attribute in every entity is completely dependent on the primary key of that table. In this example, Customer Name and Address are still in RENTAL, although they are not dependent on the Rental ID. Therefore they should be removed. Changes made to make it 3NF:  Changes made to make it 3NF Boyce-Codd Normal Form (BCNF):  Boyce-Codd Normal Form (BCNF) There are further levels of normalisation. The truest form is called BCNF and is named after the people who created the relational database. It is similar to 3NF but uses candidate or compound keys. This means that all of the primary keys must be derived from the existing attributes within an entity. For example, you could not invent a Customer ID for the CUSTOMER table; you must combine attributes together to create a unique compound key. Customer Name and Date of Birth combined could be used although this may still not guarantee a unique key.

Related presentations


Other presentations created by Boyce

Homophones 2
05. 11. 2007
0 views

Homophones 2

Chap 24
13. 04. 2008
0 views

Chap 24

oct28 singapore sg
30. 03. 2008
0 views

oct28 singapore sg

Kalsi 6 3 06
27. 03. 2008
0 views

Kalsi 6 3 06

europesecommissie
18. 03. 2008
0 views

europesecommissie

recent
14. 03. 2008
0 views

recent

hospitality recruitment
11. 03. 2008
0 views

hospitality recruitment

NucPower Kendal07
05. 03. 2008
0 views

NucPower Kendal07

Distribution Point Brief 06 7 05
29. 02. 2008
0 views

Distribution Point Brief 06 7 05

Motion Pictures still
27. 02. 2008
0 views

Motion Pictures still

groupandfamilyinflue ncelecture
24. 02. 2008
0 views

groupandfamilyinflue ncelecture

GPS power point
05. 11. 2007
0 views

GPS power point

physics 101 astronomy
13. 11. 2007
0 views

physics 101 astronomy

PHYS362 set8b
14. 11. 2007
0 views

PHYS362 set8b

When Generation Collide Aug07
23. 11. 2007
0 views

When Generation Collide Aug07

Holiday Eating
17. 12. 2007
0 views

Holiday Eating

group 7 Motor Sport
18. 12. 2007
0 views

group 7 Motor Sport

JavaSIG Flex Yakov
27. 11. 2007
0 views

JavaSIG Flex Yakov

ase06jpftut
04. 01. 2008
0 views

ase06jpftut

f05 outlikne Conformity
05. 11. 2007
0 views

f05 outlikne Conformity

AC
04. 10. 2007
0 views

AC

Limocar fr
05. 11. 2007
0 views

Limocar fr

20050829 2
01. 11. 2007
0 views

20050829 2

Primal
19. 02. 2008
0 views

Primal

Hitlerdictator
23. 12. 2007
0 views

Hitlerdictator

LEARN ABOUT PRAIRIE DOGS
19. 11. 2007
0 views

LEARN ABOUT PRAIRIE DOGS

Drury CHI04 wk shoppres
31. 12. 2007
0 views

Drury CHI04 wk shoppres

yasartekdemir PPP
23. 11. 2007
0 views

yasartekdemir PPP

CorrectionFac2005
29. 10. 2007
0 views

CorrectionFac2005

ULSD Distribution
07. 11. 2007
0 views

ULSD Distribution

msn
18. 12. 2007
0 views

msn

july15
26. 11. 2007
0 views

july15

Pastpracticetraining
05. 11. 2007
0 views

Pastpracticetraining

ZR EZR rozhovory
16. 11. 2007
0 views

ZR EZR rozhovory

HelpNetwork1003
29. 12. 2007
0 views

HelpNetwork1003

PermCoursePictures
28. 12. 2007
0 views

PermCoursePictures

Rapanos pp show
03. 01. 2008
0 views

Rapanos pp show

Historia soft propietario
05. 11. 2007
0 views

Historia soft propietario

RET Experience JMcMillian1
28. 11. 2007
0 views

RET Experience JMcMillian1

Estadistico Presentacion 2005
05. 01. 2008
0 views

Estadistico Presentacion 2005

Affreightment
15. 11. 2007
0 views

Affreightment

undergradplanningnig ht0708
06. 12. 2007
0 views

undergradplanningnig ht0708

Boyadjieva Grozev
30. 12. 2007
0 views

Boyadjieva Grozev

Evillage
04. 12. 2007
0 views

Evillage