This project report provides a comprehensive overview of the design, implementation, and testing of a relational database system. It begins with an understanding of data models and database technologies, including a critical analysis of various data models and schema, along with a discussion of different types of database management systems, highlighting the benefits and limitations of each. The report also addresses the limitations of traditional file-based systems and illustrates how relational database systems solve these problems. It then delves into various database design approaches, identifying entities, primary keys, foreign keys, and relationships to design a relational database system, presenting an ERD for the system. The physical implementation is carried out in MS SQL Server, and various methods and factors for user interface enhancement are discussed and applied. The report further explores SQL and its features, implementing a query language into the designed relational database system and evaluating the extraction of meaningful data through query tools. Finally, it investigates different testing methods for the database system, including the creation of a test plan and analysis of test results, along with the importance of technical and user documentation, and an explanation of verification and validation processes and control mechanisms used in the developed relational database system.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
