Do you mean Calvin Klein can be placed only in mexico?

My note on MySQL:
You have to study hard to be able to use it.

Ok

MySQL can be replaced by X and it will be a universal note.

Hi All, I need a help in making a table to be in 3NF

Could anyone help me on this please

Share your tables

A table with fields
•Location
•Location Code
•Account
•Tower
•Engineer
•Caller

✓ Each Location will be having a location code.

✓ Each location will be having certain number of accounts

✓ Each account will be having Different callers and Different Towers

✓ Each engineer will be working for two or more accounts

Any other info needed!

What is Caller?
What is Tower?

May account have a few locations?

EXAMPLES

Location :
MEXICO
FRANCE
ITALY

LOCATION CODE:
MX
FR
IT

ACCOUNT:
JOCKEY
CALVIN KLEIN
HUGO BOSS

TOWER:
WINTEL
UNIX
DATABASE

ENGINEER:
SARAN
PRAVEEN
ABIRAMI

CALLER:
ALERTS GENERATED BY A TOOL
USER CREATED

Yeah a location can have multiple number of accounts

I asked about account

No only one Denis

Do you mean Calvin Klein can be placed only in mexico?

Yeah

Why?

Each location will be supporting a specific account

Example: calvin klein is supported only from mexico

You sad

It means account should have a location_id column

Then you sad

Yes

It means the opposite

Wait for a sec Denis

It means location should have account_id col

CK
– Mexico
– Russia
– Egypt

Just the opposite

Mexico can have a few accounts

Yes

Can one account have a few places?

No Denis

So Calvin Klein can’t work in Mexico and in France?

Absolutely

– accounts
– id
– location_id
– engineer_id

– locations
– id
– code

– towers
– id
– account_id

– callers
– id
– account_id

– engineers
– id

Thank You, Denis but

An engineer can be supporting multiple accounts….

And what about account? Can it have many engineers?

Right… Then there will be duplication engineers table!

An account can have multiple towers.. Each tower will be supported by an engineer.

An engineer can support two or more accounts

– accounts
– id
– location_id

– locations
– id
– code

– towers
– id
– account_id
– engineer_id

– callers
– id
– account_id

– engineers
– id

Thank you🥰

Tower is a pivot between account and engineer

Tower implements MtoM

I have stuck with another problem Denis… Reach you soon & Thanks for your help.

I have another trouble. I want to eat )

I’m sorry☺️😋😋

No worries, I will do it sometime

Where are you from?