Assignment No. 02
CS403 Assignment 02 Solution Fall 2021
| Total Marks: 20
Due Date: 24-12-2021
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The submitted assignment does not open or file corrupt.
The assignment is full or partially copied from (other student or ditto copy from handouts or internet).
Student ID is not mentioned in the assignment File or name of file is other than student ID.
The assignment is not submitted in .doc or .docx format.
Your submission must include:
The objective of this assignment is
To be able to understand the concepts of Entity Relationship diagrams concepts and Enhancement in Entity Relationship diagrams.
Database relations concepts.
Your answer must follow the below given specifications.
Lectures Covered: This assignment covers Lectures: 1 to 14.
Your assignment must be uploaded/submitted at or before 24-12-2021.
Suppose you are required to model “Rent a vehicle” system for an organization to get complete understanding of the domain. System’s requirements in textual format are given below in paragraphs.
Registered customers can rent out a vehicle for their common use. By using this system, customer will also be able to know about different types of vehicles (cars, loaders, motorcycles, auto Rickshaw, van, bus, truck etc) available for rent at organization store. Customers can view available vehicles under vehicle categories without registration, but only register customers can send a booking request for an available vehicle with or without a driver (its user choice to rent a vehicle with or without driver). After getting confirmation from the manager, customers 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. Customers can view discounts/feedback, they may also be able to post reviews/feedback.
The manager can add drivers, vehicle categories (transporter, non-transporter) and vehicle details (cars, loaders, motorcycles, van 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 Customer.
In above given scenario some entities have common attributes:
Entities, attributes and primary keys:
You’re required to perform the following tasks.
a) Draw the Enhanced Entity Relationship Diagram (EERD) by considering above given scenario and table. You are required to identify and draw super types and sub types properly. Draw relationship cardinalities in alphabetical notation.
b) Perform the Cartesian product (Booking X Feedback) on the following relations: