CS403 Assignment 1 Solution Fall 2021

VU Answer Provide the Latest CS403 Assignment 1 Solution Fall 2021. Easy to See Proper Step by Step CS403 Assignment No 1 Solution 2021 Download PDF.

CS403 ASSIGNMENT 1 SOLUTION FALL 2021

Provide by VU Answer

Total Marks: 20

Due Date: 13 Dec 2021

Upload Instruction:

Your submission must include:

Assignment should be in .doc or .docx format.

Save your assignment with your ID (e.g. bx020200786.doc).

Question:

Suppose you are required to model the “Rent a vehicle” system for an organization to get a complete understanding of the domain. The system’s requirements in the textual format are given below in paragraphs.

Registered users can rent out a vehicle for their common use. By using this system, users will also be able to know about different types of vehicles (cars, loaders, motorcycles, auto Rickshaw, vans, buses, trucks, etc) available for rent at the organization stores. Users can view available vehicles under vehicle categories without registration, but only register users can send a booking request for an available vehicle with or without a driver (its user choice to rent a vehicle with or without a driver). After getting confirmation from the manager, the user will fill a rental agreement form which has all necessary details ( duration of hire, fuel detail, rental fee, The purpose of renting, return date, description of the rented vehicle, etc), he/she can select payment method via cash or online. Users can view discounts/feedback. Users may also be able to post reviews/feedback.

The manager can add drivers, vehicle categories (transporter, non-transporter), and vehicle details (cars, loaders, motorcycles, auto Rickshaw, van, bus, truck, etc), update vehicle and driver status as available or not available. He/She can view booking requests, confirm/ reject booking requests, view payment details. He/she can view feedback/ reviews and also add offers/discounts for their regular users.

context-Page-1.drawio (8)

Part a:

Draw the level 0 Data Flow Diagram for the above-given context level diagram.

Solution:

Part b:

Identify Entities their attributes and primary keys from the above-given scenario and fill out the below given table.

Solution:

Entities	Attributes	Primary Keys
User	user id, name, phone number	user-id
Manager	manager id, manager name, booking status	manager id
Vehicle	vehicle number, name, category	vehicle num
Registration	registration id, user detail, vehicle num, vehicle category	registration id
Booking	booking id, status, vehicle num, category	booking id
Driver	driver id, name, license num	driver id
Payment	payment id, type, transaction detail, user id, total bill	payment id
Discount	discount id, amount	discount id
Feedback	feedback id, rating, user-id	feedback id