Iam trying to create a database for the following requirement.
can anyone please tell me if the design is correct or where I went wrong!!

The case is to create a database for a company that has 3 branches (A,B,C) located in a very small
geographic location (at the same street). The branches are selling the same goods, electronic stuff.
The goal of the database is to create database for the products and enabling real-time updates of goods
delivered between the branches. Each branch can view another branches inventory in real time.

nice assignment

you have a ways to go before your ER model is ready to hand in

first of all, take each of your entities, and give some sample rows for them

for example, some sample rows for the product table are

This is not my assignment. Iam trying to learn database design on my own.
so please can u explain me what this statement means, coz I think I was wrong in understanding what it means!!

"The goal of the database is to create database for the products and enabling real-time updates of goods delivered between the branches. Each branch can view another branches inventory in real time".

it means there will be a table with products in it, and some way of identifying the branch that the products belong to

does it mean M:M relation between products and Branch and a table like delivered_goods for connecting both products and branch table?

i don't think so

from the description, each item belongs to only one branch at a time

by the way, ~what~ electronic goods are we talking about?

sorry rudy,
I cannot answer your question because this is not something like an assignment that is given to me. I found this question in dbforums and Iam trying to model as I found the question interesting and I think it was left unresolved.