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:
HENRY PETER KIBE KARIUKI
Multimedia University of Kenya
Database Design and Development
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:
Table of Contents
ENTITY RELATIONSHIP MODEL
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.
Devoto Management is a property management company based in London, United Kingdom. They manage residential, retail and industrial properties on behalf of the property owners. Each property is classified by type and has one designated owner. An owner might have several properties, of various types, managed by Devoto. The type of area of the property is also recorded as well as the address. Area types are: Residential Inner City
When properties are rented, the customer details are kept. Some customers might rent more than one property. Some properties come with associated fixtures. Fixtures might include: Furniture and kitchen utensils (such as a bed, table, wardrobe, chair, microwave), for residential properties Shop fittings (such as shelves, a cash register) for retail properties, and Industrial and office equipment (such as a photocopier, desks) for industrial properties.
A database is a collection of information organized to provide efficient retrieval. A good database has to be designed for Devoto Company. This will help to avoid data redundancy and help with good record keeping.
An entity is a piece of data, an object or concept about which data is stored. The following entities have been identified:
A relationship is how the data is shared between entities. There are three types of relationships between entities:
One instance of an entity (A) is associated with one other instance of another entity (B).
One instance of an entity (A) is associated with zero, one or many instances of another entity (B), but for one instance of entity B there is only one instance of entity A.
One instance of an entity (A) is associated with one, zero or many instances of another entity (B), and one instance of entity B is associated with one, zero or many instances of entity A.
In Devoto the...
Please join StudyMode to read the full document