Database Design and Implementation

DOUBLE D ESTATE AGENCY
ASSESSMENT PART 1

1.0 INTRODUCTION

The first part of the formative assessment that deals with the case study of the Double D Estate Agency Company. The estate agency is situated in Yorkshire with their head office in Melbourne, Australia. The company handles properties that are for sale or rental. Potential customers become aware of the properties as a result of advertising carried out by Double D. It uses both the traditional printed media, such as newspapers and brochures, and the new electronic media, such as the Internet and local radio.

The following parts need to be completed for this assignment;

The contribution that Conceptual design, Logical design (deriving tables from ER model and Normalisation top-down and bottom-up approaches)
SECTION 1: Sales ERD given to you in week 4, for referencing.
SECTION 2:
a) Produce a set of relations (table definitions) from Sales ER model, in SECTION ONE, by following the rules for logical design...