Introduction to Database (CCCS215 Project) Winter 2022 Project Objective: about Criminal offences The main goal of this project is to give students an opportunity to put the theory of database modelling, implementation, and application design into practice. The result will be a fully functioning database application. It includes three main phases: The first phase: Analysis (ERD). The second phase: Design of the relational DB. The third phase: Implementation of the relational DB. Instructions of the project: - You can work on this project as a group (maximum 3 students). - Develop a proposal for the database management system project. - Groups should submit for approval their project ideas. This proposal should include: A separate cover page indicating the title of your project, the full names of the group members (with student ID), the course number and course section. A narrative description of the problem or opportunity being addressed. Identification of the information needs what information would help solve the problem or allow one to take advantage of the opportunity. Initial list of entities (tables) that have been identified. This should come naturally from the above discussions. Distribution of duties for the project. List the names of each group member and what their primary role. Groups should not continue working on the project unless it has been approved by the instructor. Project worth = 15 marks, will be distributed as following: - Design the database following an ER model. (3 marks) The ER should contain all necessary information such as entities, attributes, relationships, cardinalities etc. - Convert your ER diagram to a relational schema. (2 marks) Underline all key attributes in your relations. Specify all functional dependencies for each relation. (Mapping) - Use Oracle to create the normalized tables. (2 marks) - Populate your tables with 5 rows at least. (2 marks) - Design and implement at least 4 queries. (2 marks) As specified below