Need help to identify functional dependencies in a table Materials (N - material title, S - a cipher of the material, H - characteristics of the material, I - consignment note, C - the price of the material in the consignment note, K - the amount of material in the consignment note, D - date of delivery of the material, P - supplier of the material). Where {S, I} is compiled key. Also, could you help me with decomposition it into BCNF?
Comments
Post a Comment