“Saboo-Car-Rental-Services” is a car rental showroom ,who want to automate their business.
They offer different types of cars on rent as small car,SUV,MUV.
Each type of car has the maximum seating available and the tariff per kilometer.
The management wants the system to show availability of the number of cars of each type for serving the inquiry.The system should have a provision for booking the car.
Before the booking is made ,the customer needs to provide personal information and driving license details.
Booking is typically stored as booking date,date of rent,duration in hours and type of vehicle.
Once the booking is done a unique booking number is provided to the customer for their reference which they need to produce at the time they come to collect the car.
A new transaction record is created for each booking after the car is returned,specifying the kilometers used and the amount to be paid ,date of payment.”
when we design Entity sets during database designs through Entity Relationship Diagram, there have to be some kind of connections existing between them too. These connections are called “Relationships “derived from the real world term. A relationship can be classified according to the degree or connectivity. The following are the important points to remember about relationships in Entity Relationship diagrams
A relationship is an association between entity sets.
The entity sets that are involved in the relationship are also known as participants.
Relationships are named and the name is generally a verb.
Relationships are always two ways i.e. they operate in both the directions, so the N: 1 between Students and Teachers could also be thought of as a 1: N between Teachers and Students.