Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

how to create er dagram & data modeling ?

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

3 Replies
Employee
Employee

Re: how to create er dagram & data modeling ?

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

Not applicable

Re: how to create er dagram & data modeling ?

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

Not applicable

Re: how to create er dagram & data modeling ?

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