cna anybody help me in this assignment . subject- database system management

You have been assigned to a group already Open with me on a team/group leader. This person should take care of collaborating with the group om vo the person who submits the final project deliveries on the google classroom. Make sure that the person you select is up for this responsibility so that you do not run into organisation and collaboration issues. The team leader will be the one that will submit the project only. Each member (including the leader) should contribute to the project and design document, and though you may have divided some work up between team members, you have to check each others work, you must each check the totality of the design, and you must all contribute into one cohesive, robust, and elegant design. At this time you need to share your common schedule with the team and your contact information in case it is needed. You can also decide on how the team will work: Will each one of you work on a separate part or will you meet and do all the parts together? If each member does a part how will you combine the document together?... Part 1: Conceptual Design (3%) . 1 Select your favorite website, app or literally any other system that is likely employing any database in any capacity and provide web address for it as well as a screenshot or two of its primary graphical user interfaces that are: used by the end-users of the system designed to collect data which will be later stored in the database 2- Explain in writing how the system works 3- Use the nouns and verbs from your explanation of the system to discover entities and relationships among them. Create a table containing at least 10 entities and 10 potential relationships among them. 4. Create an EERD for the database of the system you had selected and examined previously. You are require to us a software like draw.io) to complete this step. Make sure you include Super & subtypes Make sure your entities are normalized Hand-drawn models are not acceptable Please note: if you are not sure what exact data information system stores feel free to make educated guesses - given that you annotaPageem Zeally. 2 + S: 1 Part II: Design (3%) Based on the analysis and design conducted in Part I, you will be creating an actual working database for your system. The main deliverable of this part is SQL code, however you are also expected to reflect on Part II in the Main Document. This part contains the following steps: Create a table for each entity you modeled. Each table must . contain at least 6 attributes. be populated with at least 10 tuples have all the required elements to allow it to function based on how you had modelled it in Part 1 Create 4 updatable view of your choice. Explain each of these views, with at least part of each rationale being related to security, and the principle of "need to know" (e.g., a "user" only needs access to information concerning them). You may, of course, define more than one view per group member, but I am really more interested in a small number of sophisticated views, rather than seeing a bunch of very simple, one-table views. Build four triggers of your choice Build four procedures of your choice You need to provide the SQL statements for all the above. The main deliverable of this part is SQL code, however you are still expected to comment on each query in the main document. Part Ili: Usage (2%) Design and execute at least 10 unique queries with non-repeating commands (i.e. you are not allowed to use LEFT JOIN more than once) using the database you had created in Part IL. Each query should be based on the real or perceived business need. As with Part II, the main deliverable of Part III is SQL code, however you are still expected to comment on each query in the main document