DDD DEVOTO MANAGEMENT HENRY PETER KIBE 
NCC REQUIREMENT
Statement and Confirmation of Own Work
Programmer /Qualification name:
All NCC Education assessed assignments submitted by students must have this statement as the cover page or it will not be accepted for marking. Please ensure that this statement is either firmly attached to the cover of the assignment or electronically inserted into the front of the assignment.
Student declaration
I have read and understood NCC Education’s Policy on Academic Dishonesty and
Plagiarism
I can confirm the following details:
Student ID/Registration number: 00144154
Name: HENRY PETER KIBE KARIUKI
Centre Name: Multimedia University of Kenya
Module Name: Database Design and Development
Module Leader: Mr. Mugambi
Number of words:
I confirm that this is my own work and that I have not plagiarized any part of it. I have also noted the assessment criteria and pass mark for assignments.
Due Date:
Student Signature
Submitted Date:
Table of Contents
ACKNOWLEDGEMENT 4
INTRODUCTION 5
TASK 1 6
DESIGN 6
Normalization 8
ENTITY RELATIONSHIP MODEL 10
Data dictionary 11
TASK 2 13
DATA 13
QUERY 13
TASK 3 20
DERIVED DATA 20
Task 4 22
EVALUATION 22
CONCLUSION 23
REFERENCE 24
ACKNOWLEDGEMENT
I would like to take this opportunity to express my gratitude to the almighty God for providing the opportunity to undertake this assignment. Grateful thanks to my tutor Mr. Mugambi for his guidance throughout the duration of this assignment, to the institution for providing the research materials and to my classmates with whom we were able to brainstorm.
Last but certainly not least I would like to thank the members of my family for their encouragement and their moral and financial support.
INTRODUCTION
Devoto Management is a property management company based in London, United Kingdom. They manage residential, retail and industrial
Statement and Confirmation of Own Work
Programmer /Qualification name:
All NCC Education assessed assignments submitted by students must have this statement as the cover page or it will not be accepted for marking. Please ensure that this statement is either firmly attached to the cover of the assignment or electronically inserted into the front of the assignment.
Student declaration
I have read and understood NCC Education’s Policy on Academic Dishonesty and
Plagiarism
I can confirm the following details:
Student ID/Registration number: 00144154
Name: HENRY PETER KIBE KARIUKI
Centre Name: Multimedia University of Kenya
Module Name: Database Design and Development
Module Leader: Mr. Mugambi
Number of words:
I confirm that this is my own work and that I have not plagiarized any part of it. I have also noted the assessment criteria and pass mark for assignments.
Due Date:
Student Signature
Submitted Date:
Table of Contents
ACKNOWLEDGEMENT 4
INTRODUCTION 5
TASK 1 6
DESIGN 6
Normalization 8
ENTITY RELATIONSHIP MODEL 10
Data dictionary 11
TASK 2 13
DATA 13
QUERY 13
TASK 3 20
DERIVED DATA 20
Task 4 22
EVALUATION 22
CONCLUSION 23
REFERENCE 24
ACKNOWLEDGEMENT
I would like to take this opportunity to express my gratitude to the almighty God for providing the opportunity to undertake this assignment. Grateful thanks to my tutor Mr. Mugambi for his guidance throughout the duration of this assignment, to the institution for providing the research materials and to my classmates with whom we were able to brainstorm.
Last but certainly not least I would like to thank the members of my family for their encouragement and their moral and financial support.
INTRODUCTION
Devoto Management is a property management company based in London, United Kingdom. They manage residential, retail and industrial