Database Design and Implementation for a Construction Administration

This report details the design and implementation of a database for a construction company's administration department, addressing the limitations of the current manual system. It outlines the database development lifecycle, including planning, system definition, logical and physical modeling, implementation (data conversion and testing), and database techniques like normalization and ER modeling. The report proposes a relational database with seven tables: Project, Client, Company, Project Manager, Project Update, Employee, and Employee Task, defining their attributes and relationships. It also includes instructions on creating a database in Microsoft SQL Server Management Studio, along with SQL commands for table creation. The aim is to improve data management, facilitate project control, and enable better decision-making by leveraging past project data to mitigate delays and losses. The report emphasizes the importance of data modeling, data organization, and knowledge acquisition for informed decision-making in construction projects, and the use of databases in construction industry for the effective management of scheduling, document, and cost control.