i have been set a task which i having problems with.
i have to carry out the task of:
The task is expected to be completed before the end of the second laboratory session. A full account on the design at both conceptual and physical level, database normalisation, as well as the database implementation and results on table creation, data insertion and requested data searches, are to be presented in a form of a technical report (laboratory log book can be used) with a copy of search printouts.
Design a MRP system that is needed to support business activities in a company that manufactures car
starters. The MRP system is supposed to keep data on the Bill of Material for every product (car starter) in the company, all the suppliers of the parts used in the company, as well as the existing stock of all the parts. Assume that each part is generally supplied by more than one supplier and that each
supplier supplies more than one part. Also, each part could take any place within bills of material of any product. Parts are stored only on one place and only data on total quantity (inventory) of parts is needed.
i have created the relationships but needed help on the normalisation can you plz help