Database Design and Development Assignment 1 - BKC Company Analysis

This report details the design and development of a database system for BKC Company, addressing the need for improved data management. It begins with an analysis of BKC's business requirements, encompassing human resource, sales agent, product, customer, and order management. The report then outlines the data management system, including objects, properties, and relationships between entities, culminating in an ERD diagram. The relational database system is discussed, including RDBMS, deployment, and query language implementation. Data normalization, system security, and database maintenance are also covered. The report concludes with test runs, checks, and technical documentation, including configuration requirements, installation guides, and SQL Server user guides, providing a comprehensive overview of the developed database system.