design and develop a database application that will facilitate the organization

ntroductionThe Blue Ridge Apparel Group (BRAG) sells clothing, jewelry, and footwear items directly to consumers through its web-based portal. The products supplied to BRAG by their multiple vendors are first packed in cases. Multiple cases are then aggregated and assembled into pallets for delivery to BRAG’s main warehouse. After pallets arrive at BRAG’s warehouse, they are verified against a purchase order and inspected. Once the verification and inspection processes are completed, warehouse personnel at the receiving department break down the pallets, put away the items into their corresponding storage location, and update the inventory record. Main DeliverablesThe intermediate submission is a complete design of BRAG’s database application. This should include context, key-based,and fully attributed data models; normalized (3NF) relations; a final fully attributed data model including data types for all [login to view URL] include a list of assumed business rulesthat support the relationships among the main entities included inthe [login to view URL] data models must be drawn electronicallyusing a computer application such as Microsoft (MS) Visio or MS [login to view URL] names for entities and attributesmustcomply with the terminology presented in the background section of this [login to view URL] final submission should include the following items. A brief term report documenting the activities carried outduring the various phases of the project is required. The report should include(1) a formalstatement of the project scope and objectives; (2) a detailed requirementsstatementfor the database application, (3) database design(context, key-based,and fully attributed data models; normalized (3NF) relations; a final fully attributed data model including data types for all attributes); and(4) a working prototype in MS Access including a user guide.