Database Design & Implementation - Assignment 2

CSG1207/CSI5135 Systems and Database Design
Assignment 2
Database Design & Implementation
Student Name:
Student ID:

P a g e | 1
Table of contents
Assumptions.............................................................................................................................2
Logical ER diagram................................................................................................................... 3
Physical ER diagram..................................................................................................................4
Data Dictionary.........................................................................................................................5
1

P a g e | 2
Assumptions
 The customers who are registered, only their details are recorded.
 Each customer has their addresses. Customers can have multiple addresses.
 All the customer details are mandatory.
 The customer referral number will be from the customer table.
 Except for address name, all the address tables are mandatory.
 The items which are registered, only their details are recorded in the database.
 It is not mandatory to the description of each item.
 Each item belongs at least one category.
 Each order has a particular invoice number.
 It is possible the customer has never ordered anything.
 It is possible that particular item has never been ordered.
 It is possible that particular category has never been ordered.
 It is possible that customer has not been interested in any of the categories.
2

P a g e | 3
Logical ER diagram
Figure 1: logical diagram
The logical diagram has been well designed according to the scenario given. The scenario
results in designing of 9 entities with a primary key defined in each table. This diagram has
been designed taking 3 NF normalization forms, to remove any inconsistency and
redundancy. All the tables are precisely observed and designed while taking some few
assumptions. This complete ER-diagram has been converted into Physical ER diagram.
3