Project Description The project is designing a complete database management system to address a practical database need and implement a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization. The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of Spring Company, Spring company has several departments. Each department has a supervisor and at least onc cmployee. Employecs must be assigned to at least one project, but possibly more departments. At Icast onc cmployec is assigned to a project, but an employce may be on vacation and not assigned to any projects. The impulan data liells are the names of the departments, projects, supervisors, and employees, as well as the supervisor and employee number and a unique project number. The initial entities for your model are Department, Employee, Supervisor and Project. In addition to these initial entities, you are provided with several business rules. You should treat this project as a business assignment in which your instructor is your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as inaccurate or incomplete work. Your grade represents your pay. Deliverable 1 Begin with the initial entities for Department, Employee, Supervisor and Project provided above, transform them into RELATIONS Realize that the four entities (or the four converted relations) are not in 3rd Normal Furi. This is obvions hy the many-to-many relationship that would need to exist between DEPARTMENT and EMPLOYEE and the relationship between EMPLOYEE and PROJECT. Make sure to show the referential integrity constraints diagram (see? figm:28 1-3 i 1-5 in wow taxthonky You are lu do the steps necessary to obtain 3rd Nuruzal Forn. You do not have lu show bow you yol there, but you are lo provide a document that sbwws the final relativos you come with (and their relationships) once you tuve achieved 3rd Normal Form. Hint: Your answer will be within the Word document you submit as your Project Assignment response along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relativos in alphabetical order and lines between the relations windlicate the relationstups). Thuis formal is NOT in ERD. Make sure it includes proper curtailing and capitalization, as well as the appropriate relationships. Project Description The project is designing a complete database management system to address a practical database need and implement a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization. The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of Spring Company, Spring company has several departments. Each department has a supervisor and at least onc cmployee. Employecs must be assigned to at least one project, but possibly more departments. At Icast onc cmployec is assigned to a project, but an employce may be on vacation and not assigned to any projects. The impulan data liells are the names of the departments, projects, supervisors, and employees, as well as the supervisor and employee number and a unique project number. The initial entities for your model are Department, Employee, Supervisor and Project. In addition to these initial entities, you are provided with several business rules. You should treat this project as a business assignment in which your instructor is your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as inaccurate or incomplete work. Your grade represents your pay. Deliverable 1 Begin with the initial entities for Department, Employee, Supervisor and Project provided above, transform them into RELATIONS Realize that the four entities (or the four converted relations) are not in 3rd Normal Furi. This is obvions hy the many-to-many relationship that would need to exist between DEPARTMENT and EMPLOYEE and the relationship between EMPLOYEE and PROJECT. Make sure to show the referential integrity constraints diagram (see? figm:28 1-3 i 1-5 in wow taxthonky You are lu do the steps necessary to obtain 3rd Nuruzal Forn. You do not have lu show bow you yol there, but you are lo provide a document that sbwws the final relativos you come with (and their relationships) once you tuve achieved 3rd Normal Form. Hint: Your answer will be within the Word document you submit as your Project Assignment response along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relativos in alphabetical order and lines between the relations windlicate the relationstups). Thuis formal is NOT in ERD. Make sure it includes proper curtailing and capitalization, as well as the appropriate relationships