COIT11237 - Database Design & Implementation - Case Study - IT Assignment Help

Assignment Task

Objectives
To develop a conceptual data model diagram
To perform logical design and physical design
To implement a database
 

Introduction
In this assessment, you will be required to perform the following tasks for the case study given below:
Develop an entity-relationship model to represent the requirements of the given case study
Document any assumptions made during the modelling process
Perform logical and physical design of your ER model
Implement your design in Microsoft Access.

Case Study
CQ Vehicle Repair Shop
CQ Vehicle Repair Shop (CQVR) performs maintenance work and smash repair of vehicles. When a new customer brings his/her vehicle for any maintenance work, they record the customer and the vehicle details. After the initial checkup of the vehicle, their employees are allotted for carrying out its maintenance work. The maintenance work involves regular service work such as oil/fluid change, battery and brake inspection, etc. However, it may require change of parts in some maintenance works. After the completion of the work, an invoice is prepared and sent to the customer for payment. The invoice mentions the following details:
work carried out and respective charges
hours of labour involved and respective charges
parts and their charges
CQVR also performs smash repair of vehicles as required by the vehicle insurance companies. The smash repair work is performed as mentioned below:
repair work quote prepared and approved
repair work performed
invoice prepared and sent to the insurance company

The invoice shows the similar details as mentioned earlier for the maintenance work.
Note: The attributes of the possible entities have not been mentioned clearly. For example, the attributes of customer have not been mentioned. You are required to identify the necessary attributes and provide their details in your ER diagram/model. Please make sure that each entity has at least two relevant attributes. As all the details have not been presented, you can make suitable assumptions.

Your tasks
You must complete the following tasks:
Develop an ER model to represent the requirements of the given case study.
You are required to develop an entity-relationship model to capture the data requirements of CQVR.
Note: Use the symbols as prescribed in your unit textbook. It is recommended that you use Microsoft Visio or any drawing software product/tool to create your ER model. You need to copy the diagram and paste it in the word document and ensure that it is clearly visible in the word document for marking purpose.
List your assumptions and justify the relationship constraints in your ER model.
For any information that is not specified or is unclear, please state a reasonable assumption and model accordingly.
Note: An example for relevant assumption - A maintenance work may not need change of parts.

Create Logical Design
Map your ER diagram into relations and make sure that all the relations are in BCNF. You need not provide any justification that the relations are in BCNF. Provide all the relations in the following format:
Student (StudentID, StudentName, Street, Suburb, State, PostCode, Email, ContactNumber)
Unit (UnitID, UnitName)
UnitStudent (UnitID, StudentID, grade)
foreign key (UnitID) references Unit.UnitID
foreign key (StudentID) references Student.StudentID

Provide Physical Design
Complete the physical design for any one table. You can use the following table, given below, for providing the properties of attributes/columns of the table.
Note: only one table must be presented.
Column name Type/length Identifier Required Default value Data constraints
ID Autonumber Yes Yes n/a n/a

Implement Database
Create a database (CQVR.accdb) in Microsoft Access. Create the necessary tables as per the logical design. Create all columns in each table and use appropriate data types. Ensure that the physical design that you have provided in the previous step (4) is also implemented in your database. All the relationships should have appropriate referential integrity and cascade options applied. You are only required to implement tables, attributes and relationships; you are not required to develop forms, reports or any other application. You need not provide any data in the tables.

This COIT11237 - IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.