Table Name Attributes Explanation of attribute Remarks A unique 8 digit identification that is assigned to each project for all tracking all business transactions and activities Since a project may have multiple revisions for design bids, each design bid is assigned a version number in sequence For example 01, 02, 03 ProiectNumber bidNumber For example: Regular granite pots come in sizes of 10 A unique code of up to 6 digits and letters, assigned to each gallons, 25 gallons, 40 gallons and 50 gallons; and have material used in different projects. If the same material is mateialCode GP10, GP25, GP40, GP50. The black available in different sizes and colors, each is assigned different code NBD classifies all its materials used in a project as Plant and Pottery. All other materials used are currently classified as Materials. To avoid confusion in the database, everything other than plants and pottery will referred to as General Materials. Common description of the material. This is usually the name of the material size of the material identified by material code units used to describe the size of the material Quantity of material included in the design bid version The unit price quoted for the material included in the design bid. Depending on season, quantities used in a project, etc. the unit price for the same material can change from one design bid to another granite pots have codes GPBL10, GPBL25, GPBL40 GPBL50 materialCod BidMatReq materialType materialDescription materialSize materialSizeUnits materialQuantity For example: inches, feet, gallons, yards, cu. Yards, etc materialUnitPrice BidMatReg ProiectNumber (FK1) bidNumber (FK1) materialCode.materialType materialDescrition, materialsize, materialsizeunits, materialQuantity materialUnitPrice Functional Dependencies for BidMatReg No Partial Dependencies Partial Dependencies Transitive Dependencies: 2NF Solution 3NF Solution