Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Azki Unibus operates a bus services in Kubang Pasu, Kedah. Hamdi IT Expert is appointed to develop a new information system for Azki Unibus. The

image text in transcribed
Azki Unibus operates a bus services in Kubang Pasu, Kedah. Hamdi IT Expert is appointed to develop a new information system for Azki Unibus. The information gathered by Hamdi IT Expert during the fact-findings process are as follows: 1. A driver can be assigned to many driving schedules, but each of the driver can be assigned to one driving schedule at a time. 2. A driver may drive many buses, but a driver can only drive one bus at a time. 3. Each bus can be assigned to various routes. 4. For each of the routes, the prices are different. Hence, tickets are needed in order to travel to all routes. 5. Passengers can buy tickets for many tickets, but each of the ticket is for only a passenger at a time of travelling. 6. At the end of each route, each of the bus will be parked at any available parking lots. REQUIRED: (a) Draw an entity relationship (ER) diagram for the Azki Unibus's new information systems. (8 Marks) (b) List FOUR (4) entities identified from the ER diagram in (a) and identify THREE (3) attributes for each of the entities. Use the following format to present your answer: Entity Attribute (Primary key) Attribute Attribute (8 Marks) (c) Design an interface for bus ticket purchase form that lists the details about the bus ticket, its route and driver. The form must consist of ONE (1) form header, FOUR (4) command buttons, THREE (3) combo boxes, SIX (6) labels and FOUR (4) text boxes. (9 Marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Ethics for Scientists and Engineers

Authors: Edmund G. Seebauer, Robert L. Barry

1st Edition

9780195698480, 195134885, 195698487, 978-0195134889

Students also viewed these Accounting questions