Select a problem from the dropdown list shown below

From the following problem statement identify the possible entity sets, their attributes, and relationships.

SE VLabs Inc. is a young company with a few departments spread across the country. As of now, the company has a strength of 200+ employees. Each employee works in a department. While joining, a person has to provide a lot of personal and professional details including name, address, phone #, mail address, date of birth. Once all these information are furnished, a unique ID is generated for each employee. He is then assigned a department in which he will work. There are around ten departments in the company. Unfortunately, two departments were given same names. However, departments too have ID's, which are unique.

Note: Try to use the features of the interface provided to capture as much details as possible.

Draw an ER diagram for the following problem:

The latest cab services agency in the city has approached you to develop a Cab Management System for them. They would be using this software to efficiently manage and track different cabs that are operated by them.

The agency provides service from 8 AM to 8 PM. The agency can be uniquely identified by regestration number, and other identification can be name and address.

Cabs are solely owned by the agency. They hire people in contracts to drive the cabs. A cab can be uniquely identified by, like any other vehicle in the country, its license plate. A few different categories of cars are available from different manufacturers. And a few of them are AC cars.

Cab drivers are given a identification card while joining. The ID card contains his name, permanent address, phone number, date of joining, duration of contract. Also, an unique alphanumeric code is assigned to each number.

Whenever any passenger books a cab, an available cab is allocated for him. The booking receipt given to the passenger contains the car #, name, phone, source, destination. Once he reaches the destination, he signs on a duplicate copy of the receipt and gives back to the driver. Driver must submit this duplicate copy signed by the passenger at the agency for confirmation.

To evaluate their quality of service, the agency also wants a (optional) customer satisfaction survey, where passengers can provide feedback about their journey through the agency's website.

Table #1: Add Entities

Entity	Weak	Add
	Weak

Table #2: Add attributes for each entity

Entity	Attribute	Primary Key	Add
		Primary Key

Table #3: Define relationship between two entities

Entity	Relation	Entity	Constraint	Add

Table #4: Entities and their attributes

Entity	Attributes	Weak

Table #5: Relationships between entities

Entity	Relation	Entity	Constraint Type	Remove

Table #1: Add Entities

Entity	Weak	Add

Table #2: Add attributes for each entity

Entity	Attribute	Primary Key	Add

Table #3: Define relationship between two entities

Entity	Relation	Entity	Constraint	Add

Table #4: Entities and their attributes

Entity	Attributes	Weak

Table #5: Relationships between entities

Entity	Relation	Entity	Constraint Type	Remove

Solution