Scribd
Upload
19 views2 pages

Database Normalization for Flight Booking

Uploaded by

camille
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
19 views2 pages

Database Normalization for Flight Booking

Uploaded by

camille
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Database Design and Implementation

MOD002589 (Tutorial 4)
Make sure you have completed previous weeks’ activities before starting this
activity.

Activity
This group activity continues the second step of designing and implementing
a database for your chosen flight booking system. Last week, you have
designed an EERD. This week, you will validate your design using
normalisation. This week tutorial maps to LO 1 & 2 (i.e. capturing real world
data & Modelling). The activities below map to the element 2 of the module
assignment.

 Individually, analyse entities and evaluate using normalisation


techniques (1NF, 2NF and 3NF) to evaluate if the model is up to the
standards. (15min)
 Group members discuss their outputs after normalisation.
 Change EERD wherever it is required.
 Update Google Doc (20min)
 Add an explanation of the normalisation to your Google Doc
 If you are done with the normalisation earlier, please evaluate your
model based upon the questions you created in Week 2 (to see if you
have all required attributes to answer these questions. If you do not

1
have questions for any reason (e.g. you started late) then use the client
questions, under Week 4 on Canvas, to evaluate your model.

Resource:
Lecture Week 4
[Link] OR Visio OR LucidChart (to draw EERD on PC)

Common questions

Powered by AI

The essential steps involved in validating and updating an Enhanced Entity-Relationship Diagram (EERD) using normalisation techniques start with analysing entities individually to evaluate them against normal forms: 1NF (First Normal Form), 2NF (Second Normal Form), and 3NF (Third Normal Form). This analytical process ensures that the database design is structured efficiently by eliminating redundancies and dependencies. After the initial individual analysis, group members discuss their findings to identify any discrepancies or necessary modifications to the EERD. If discrepancies are found, the EERD is updated accordingly. The results and explanations of the normalization process are documented (e.g., on Google Docs), and this documentation is crucial for keeping track of changes and understanding the rationales behind them. Additionally, the model should be evaluated based on predefined questions to ensure it has all required attributes for functional operation. Any attributes or elements lacking to answer these questions indicate further refinement is needed in the EERD .

You might also like