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.
Uploading instructions
Your submission must include:
Assignment should be in .doc or .docx format.
Save your assignment with your ID (e.g. bx020200786.doc).
Assignment submission through email is NOT acceptable.
Objectives
The objective of this assignment is
To be able to understand the concepts of Entity Relationship diagrams concepts and Enhancement in Entity Relationship diagrams.
Relationship Cardinalities.
Database relations concepts.
Note:
Your answer must follow the below given specifications.
Font style: “Times New Roman”
Color: “Black”
Size: “12”
Bold for heading only.
Font in Italic is not allowed at all.
No formatting or bullets are allowed to use.
Your answer should be precise and to the point, avoid irrelevant detail.
Lectures Covered: This assignment covers Lectures: 1 to 14.
Deadline
Your assignment must be uploaded/submitted at or before 24-12-2021.
Question Statement:
Scenario:
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:
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:
