University | Singapore Management University (SMU) |
Subject | Introduction to Database Design and Development Assignment |
Please attempt ALL questions.
Question 1
Draw an Entity Relationship Diagram (ERD) for the following case study:
Blue Garage Private Limited (BGLM) provides car maintenance services to its clients. To keep costs low, BGLM employs freelance mechanics. A record of the names of freelance mechanics working for the garage together with their employee identification is maintained for payment purposes.
A car has one owner although some owners have more than one car. When a client contacts the garage, the workshop clerk verifies the client’s details. If it is a new client, details of the client are added to the client files. The clerk checks the current service schedule, and the date and time are agreed with the client and a unique job number is given to the client for reference.
The chief supervisor assigns mechanics to carry out each service job. Sometimes more than one mechanics are assigned to the job. Each job might require using one or more service parts. This service part has a part number, description, and unit price for billing purpose. When the job is complete, the clerk prepares a bill for the client. On payment, the clerk updates the job record.
Please take note that the ERD must clearly show all attributes, primary key, foreign key, relationships (and their types) on the diagram., as well as any assumptions you have made. (30 marks)
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
Avail Assignment Help Singapore now for comprehensive support with your Introduction to Database Design and Development assignment at Singapore Management University (SMU). Our proficient team assists students in crafting top-notch reports and drawing precise Entity Relationship Diagrams (ERDs) tailored to the course requirements. Save time and elevate your academic performance by tapping into our Online Report Writing Services. Let our experts guide you through the complexities of your coursework, ensuring thorough understanding and exceptional quality submissions.
Looking for Plagiarism free Answers for your college/ university Assignments.
- SOC367 Gender Equality in the Philippines and the Magna Carta for Women – ECA Essay
- HBC251 Religious Hate, Violence, and Inter-Religious Relations: A Sociological Analysis – ECA
- Leadership Responses to Environmental Turbulence Using Yukl’s Leadership Matrix
- Financial and Investment Analysis Report – Economic Trends, Risk Assessment, and Strategic Growth Potential
- BUS363 Total Quality Management Analysis of Ride-Hail Services in Singapore – ECA
- BUS353 Air Taxi System Project Management Case Study – ECA
- BUS356 Ethical Justification for Delaying Catalisten’s Launch Due to Bias
- HRM335 Thought Leadership Analysis: Leadership Styles, Impact & Competencies
- HBC101 Singapore’s FWAs: Addressing Aging, Talent Shortage & Mental Health – TMA01 Essay
- HRM358 Addressing Hiring Bias and Promoting Diversity – ECA