how to create er dagram & data modeling ?

[#1]

Hi Team,

How to create er digram & data modeling for the attached document.

company not providing any data me only  crteate the dummy data and this is the assignment for me.

I have no idea for  er digrams for this document.i need er diagram , table and fields.

please help me i am suffering last 15 days for this.

This is not a client requirement,

Thanks,

damodar

[hic]

You start in the wrong end of the problem. Start by loading the table that contains the source data, and try to answer some of the central questions in the document.

Then add more tables as you go.

HIC

[#3]

Hi Henric,

company not providing any data me only  crteate the dummy data and this is the assignment for me.

I have no idea for  er digrams for this document.i need er diagram , table and fields.

please help me i am suffering last 15 days for this.

This is not a client requirement,

Thanks,

Damodar

[#4]

Hello Reddy,

You can start with below tables:

1) Taxi_Info

  >> this contains all the information regarding a single taxi like (Total Maintenance Cost, ModelNumber, ModelDate, Number of passengers it can carry)

2) Region_Info

3) Booking_Info

Find all related information about each and then we can think of how normalized we want our data model to be.

Thanks,

ASINGH