COIT11237 Database Design and Implementation

Introduction

In this assessment, you are required to create a suitable database in MS Access for the given case study.  You need to do the following:
Design and draw an Entity Relationship diagram
Provide answers to the given questions related to ER diagram
Perform logical and physical design
Create a Database in MS-Access
Case Study
Hassle-free Dry Cleaners Australia (HDCA)
Victor owns and operates Hassle-free Dry Cleaners Australia (HDCA).  HDCA offers a full range of services in all their stores including garment preservation, quality business shirt service, ironing, etc.  Currently, HDCA staff record all their customers’ details and relevant transactions manually into a register. 
The collection process at HDCA starts when a customer walks-in and provides the HDCA staff with their details (First Name, Last Name, Number, Street, Suburb, Contact number, type of clothes, customer preferences, Quantity, preferred date and time for pick-up).  Upon receiving the details, HDCA staff members provide the customer with the total cost for cleaning clothes, etc.  If the customer is happy with the quote, then HDCA staff will record the customer’s credit card details (credit card number, name on the card, type, expiry date and 3 or 4 digit code). Once the clothes are collected by HDCA staff, these will be washed or dry cleaned as per the customer’s preferences and kept ready for collection by the customer.  At the time of delivery, customers are provided with a hard copy receipt which includes Receipt Number, Receipt date and Amount paid.
As part of your assessment, you are expected to find out the relevant attributes of the entities and relationships.  Each entity should have at least one additional attribute in addition to the identifying attribute. To avoid plagiarism, the case study does not clearly specify the details such as attributes and their types, relationship constraints, etc., that are required to design and draw the ERD.  Hence, you are expected to assume such details which have not been mentioned clearly in the above case study.

1Draw an appropriate ER diagramUse the symbols as prescribed in your unit-textbook to draw the ER diagram for the above case study.  
2    List your assumptions and justify the relationship constraints in your     ER diagram.  Your answers should be relevant to your ER diagram for the given case study only.
3    Create Logical Design Map your Entity Relationship model into Relations and make sure that all the     relations are in BCNF.  Provide all the relations in the following format: Student (StudentId, StudentName, Street, Suburb, State, PostCode, Email, ContactNumber)

Course (CourseId, CourseName)

Course_Student(CourseId, StudentId, grade)

foreign key (CourseId) references Course.CourseId
foreign key (StudentId) references Student.StudentId