Question
Kawasaki Motors (Malaysia) Sdn Bhd is a company that sell Kawasaki model motorbike. Kawasaki Motors also offers servicing facility for each of their motorbike. Due
Kawasaki Motors (Malaysia) Sdn Bhd is a company that sell Kawasaki model motorbike. Kawasaki Motors also offers servicing facility for each of their motorbike. Due to the new company policy, the company manager has decided to upgrade their servicing system. As a database designer, you are assigned to design new database system according to the following requirements A Kawasaki motors agent may sell many motorbikes, but each motorbike is sold by only one agent whose ID, name, and telephone number are recorded. A customer can buy many motorbikes, but each motorbike is sold to only one customer. Each customer has a unique IC number, name, telephone number and address whereas each motorbike has a serial number, model, type, and year of production. An agent writes an invoice for each motorbike being sold which records the ID, date and customer information. The invoices will be later sent to the customer. Besides motorbike purchase, a customer can have his or her motorbike serviced. When a customer takes one or more motorbike in for repair or services, one service ticket is written for each motorbike, which highlight the motorbike serial number and its problem inclusiveness of possible parts needed by the motorbike. A motorbike brought in for services can be worked on by many mechanics, and each mechanic may work on many motorbikes. Mechanics information such as mechanic ID, and mechanic name are also recorded in the databases. a) Draw a complete Entity Relationship Diagram based on the information given above. Show all entities, attributes, relationships and connectivities involved. b) List Two (2) examples of report that can be produced from this database system.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started