Question: Information System Development exercise. need help by using crow's foot model Adni Bus Company (ABC) wants to develop a database to keep all information about

Information System Development exercise. need

Information System Development exercise. need help by using crow's foot model

Adni Bus Company (ABC) wants to develop a database to keep all information about its buses. Each bus bought by ABC will be registered in the database. The information stored is bus plate number, model, year made, date of purchase and amount purchase. These buses are used to carry passenger from ABC bus station to many destinations all over Malaysia. Each bus may visit different destinations. Each destination can be visited by more than one bus. The information about destination includes destination code, destination name, and state. Once in a month, the buses need to be sent for maintenance to check for their conditions. The information about maintenance is maintenance identification, date sent for maintenance, date finish and the latest status of the bus condition. Every maintenance is performed by a mechanic. The information about mechanic that needed to be stored in the database is mechanic identification number and name. Other information about mechanic is qualification and years of experience. Based on the given information, draw a complete ER diagram using Crow's Foot model. Include the necessary connectivities and attributes in your diagram. (20 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!