COIT20247 Database Design and Development (T XXXXXXXXXXAssessment item 1— Entity Relationship...

Question

COIT20247 Database Design and Development (T XXXXXXXXXXAssessment item 1— Entity Relationship Diagram (ERD) Due date: Friday of Week 5 (11:45pm August 11, 2017) ASSESSMENT Weighting: 30% Length: No fixed length 1 Objectives This assessment item is to develop a conceptual data model based on the following case study. It relates to the unit learning outcome numbers 1 and 3 in the unit profile. Assessment task In this assignment, you are going to perform the entity-relationship data modelling based on the following application scenario. The application scenario: Australasia Auto Services Australasia Auto Services (AAS) is a prestigious dealer of cars based in Rockhampton, Queensland. Their main business is to provide professional maintenance services for various cars and also sells a wide range of new vehicles. With the boom of its business in recent years, AAS needs a relational database system to store information related to its business. In this assignment, your task is to design an entity relationship (E-R) data model for a database to be used by AAS in order to manage various information related to their business activities efficiently. You should read the case study carefully, making a note of all the entities you think are involved, and of their attributes. Consider
	
Document Preview: COIT20247 Database Design and Development (T2 2017) 
 
Assessment item 1— Entity Relationship Diagram (ERD)  
ASSESSMENT 
Friday of Week 5 (11:45pm August 11, 2017) 
Due date: 
Weighting: 30% 
Length: No fixed length 
1 
 
Objectives  
This assessment item is to develop a conceptual data model based on the following case study. It relates 
to the unit learning outcome numbers 1 and 3 in the unit profile. 
 
Assessment task  
 
In this assignment, you are going to perform the entity-relationship data modelling based on the following 
application scenario.

The application scenario: Australasia Auto Services 
 
Australasia Auto Services (AAS) is a prestigious dealer of cars based in Rockhampton, Queensland. 
Their main business is to provide professional maintenance services for various cars and also sells a wide 
range of new vehicles. With the boom of its business in recent years, AAS needs a relational database 
system to store information related to its business. In this assignment, your task is to design an entity 
relationship (E-R) data model for a database to be used by AAS in order to manage various information 
related to their business activities efficiently. You should read the case study carefully, making a note of 
all the entities you think are involved, and of their attributes. Consider the relationships between the 
entities as you do this. 
Although AAS hires many staff, each employee can be categorised one of three types: mechanic, 
salesperson, and administration staff. The duty of mechanic is to perform car maintenance service, while 
the salespersons are responsible for sales and the administration staff deal with a wide range of 
administrative jobs or miscellaneous tasks.  Each employee at AAS has a unique employee number, and 
AAS maintains normal contact information about each employee. In addition, the technical trade level 
and expertise of mechanics, the number of year in sales experience for a salesperson, and the qualification 
of...

Robert · Accepted Answer

Entity Relationship Diagram:
Entity and attributes definition: 
1. Employee: Employee is a person who works in AAS. An employee can be a mechanic, salesperson, 
and administration staff. 
Attribute Data type Description 
Employee_ID Primary Key, 
Numeric 
Unique identity for each employee at AAS 
Employee_Name Text The full name of the employee 
Address Long text The full length address of the employee 
Contact_num Numeric The mobile contact number of the employee 
Email Text The email ID of the employee
2. Mechanic: Sub-class of employee who performs the service operations 
Attribute Data type Description 
Mechanic_ID Primary Key, 
Numeric 
Unique identity for each mechanic at AAS 
Emp_ID Foreign key, 
Numeric 
Derived value from Employee 
Technical_trade_level Long text The level of technical trade aspect 
Experience Text The overall experience of the mechanic
3. Salesman: Sub-class of employee who performs sales activities. 
Attribute Data type Description 
Salesman_ID Primary Key, 
Numeric 
Unique identity for each salesman at AAS 
Emp_ID Foreign key, 
Numeric 
Derived value from Employee 
Sales_years_exp Numeric The number of years of experience in sales
4. Admin_staff: Sub-class of employees who performs administration related tasks. 
Attribute Data type Description 
Admin_ID Primary Key, Numeric Unique identity for each admin at AAS 
Emp_ID Foreign key, Numeric Derived value from Employee 
Education Text The qualification of the employee
5. Booking:

COIT20247 Database Design and Development (T XXXXXXXXXXAssessment item 1— Entity Relationship Diagram (ERD) Due date: Friday of Week 5 (11:45pm August 11, 2017) ASSESSMENT Weighting: 30% Length: No...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment