Sample application

In order to explain the basics of the ER model, an online web portal to buy and sell cars will be modeled. The requirements of this sample application are listed as follows, and an ER model will be developed step by step:

1. The portal provides the facility to register the users online and provides different services for the users based on their categories.
2. The users might be sellers or normal users. The sellers can create new car advertisements; other users can explore and search for cars.
3. All users should provide there full name and a valid email address during registration. The email address will be used for logging in.
4. The seller should also provide an address.
5. The user can rate the advertisement and the seller's service quality.
6. All users' search history should be maintained for later use.
7. The sellers have ranks and this affects the advertisement search; the rank is determined by the number of posted advertisements and the user's rank.
8. The car advertisement has a date and the car can have many attributes such as color, number of doors, number of previous owners, registration number, pictures, and so on.