Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Systems and Database Design Assignment: Normalisation and E - R Modelling Assignment Marks: Marked out of 2 0 , worth 2 0 % of unit
Systems and Database Design
Assignment: Normalisation and ER Modelling
Assignment Marks: Marked out of worth of unit
Due Date: December :AM
Background Information
This assignment tests your knowledge and understanding of two of the concepts we have covered in this unit
Normalisation and EntityRelationship Modelling. Both processes aim to organise and represent a set of data in an
efficient manner that minimises redundancy and establishes the structure of related groups of data. These are
important first steps in constructing databases.
The assignment consists of four tasks, focusing on normalisation and entityrelationship modelling. Attempt all
questions, and be sure to show all relevant stagesworking and state any assumptions.
The presentation of your solutionsdocument and use of correct notation are also considered.
A Note Regarding Assumptions
It is not possible to define every single aspect of all systems in the assignment brief, nor is it beneficial to attempt this.
Part of the process of completing the assignment tasks is making and declaring assumptions that define any
ambiguous or unspecified details in the scenarios. It is up to you to make these assumptions, but feel free to discuss
them with your tutor if you are uncertain of their validity. The tutorial of Module recording available on unit site
discusses assumptions.
There is no universally correct set of assumptions for the tasks. Think about the problem, and make assumptions as
you encounter the need for them. All assumptions should affect or be enforcedimplemented by your database
design, and they should not contradict or repeat something that is specified in the assignment brief. Your assumptions
are unlikely to have a major impact upon the task or the resulting database structure if they do seek advice from
your tutor.
The most common assumptions are likely to regard identifying irrelevant or derived data Tasks and or the
cardinality of relationships between entities all tasks Some assumptions may make a task easier, but avoid always
making assumptions that make the task easier, as this is a questionable practise and is likely result in a solutions that do
not demonstrate a deep understanding. Always remember to clearly state all assumptions you make.
Your assumptions should give context to your solutions, making it clear to staff that you have considered certain
aspects of the scenarios and decided upon how to approach them.
Summer School, CSG Assignment Page
Task Normalisation marks
The table below shows part of a spreadsheet used by libraries to keep track of their stock of books.
BookId Author Title PublisherId Publisher LibraryCode LibraryName Stock
Boris Markson more things to do
in zero gravity
CSXPNG Pinguino PER WA State
Boris Markson more things to do
in zero gravity
CSXPNG Pinguino VIC Victoria Park
Terbert
Humperdinkle
How to train a skunk
for fun and profit
SCIIND Indigo PER City of Perth
Agnes
Finkleworth
The Bantworth
Chronicals
CSXPNG Pinguino PER City of Perth
Agnes
Finkleworth
The Bantworth
Chronicals
CSXPNG Pinguino VIC Victoria Park
Agnes
Finkleworth
The Bantworth
Chronicals
CSXPNG Pinguino JOO Joondalup
Take heed of the following tips and reminders:
There are several valid ways to normalise this data, leading to almost identical solutions.
This scenario only allows for one repeating group, ie ROuter Group Repeating Group Not all groups
of logically related attributes will begin in its own repeating group, ie
A repeating group may contain attributes that will be split into different relations later on
Design a relational database for this scenario by normalising the data to the third normal form, clearly showing the
stages of NFNFNF and NF State any assumptions you make. Use relational symbolic notation as indicated in
the second lecture, and name the relations upon reaching NF
Hint: You canshould introduce autoincrementing ID columns to serve as the primary key of a relation if a suitable
attribute does not exist in the data. Remember to state assumptions and include them from NF
Include a physical ER diagram of your normalised results. Remember to state any assumptions regarding the
cardinality of the relationships in the diagram.
Summer School, CSG Assignment Page
Task Normalisation marks
The form below depicts an invoice for a purchase from a fast food store.
Design a relational database for this scenario by normalising the data to the third normal form, clearly showing the
stages of NFNFNF and NF State any assumptions you make. Use relational symbolic notation as indicated in
the second lecture, and name the relations upon reaching NF
Include a physical ER diagram of your normalised results. Remember to state any assumptions regarding the
cardinality of the relationshi
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started