Table of Contents1.Introduction...................................................................................................................................32.Use of Database.............................................................................................................................33.Database Design............................................................................................................................33.1Table’s Creation....................................................................................................................43.2ER Diagram...........................................................................................................................53.3Form Creation........................................................................................................................83.4Query Creation....................................................................................................................113.5Report Creation....................................................................................................................134.IT controls...................................................................................................................................155.Ethical, Privacy and Security Issues............................................................................................15References...........................................................................................................................................162
1.IntroductionYou are the coordinator for a project management company. You will be handling thevarious ongoing projects. You also track the commercial project and employee activities andemployee participation in the each project. The project management company needs to createthe new database application to maintain the Project and employee information. So, you needto create the new database applications by using the Microsoft access. The New databaseapplications needs to save the team members information, supplier’s information, materialinformation and project information. These databases also retrieve, delete and update theinformation. The database application will be created.2.Use of DatabaseThe new database application is used to store the following information.Project informationSupplier’s informationPurchased materials informationEmployee InformationThis database also retrieves the project, supplier and employee information. The newdatabase applications also do update, delete and insert operations. It provides the datasecurity. The database application was only accessed by the company administrators. 3.Database DesignThe New database application creation is done by using the Microsoft Access. It is shownbelow (CORONEL, 2017). The Database creation includes the,Table’s creationER Diagram QueryFormReport3