Diagrams ER, Communication
Save the file Lastname_Firstname_FinalExam2024.pdf Do not forget to write your name and student ID in the final exam file. Late Policy Full credit will be given for the exam turned in on the DUE date. 80% credit for one day late: Exam uploaded the next day (5:00 PM) will have a maximum possible credit of 80%. 50% credit for two days late: Exam uploaded two days after the due date (by 5:00 PM) will have a maximum possible credit of 50%. NO credit given after two days late. Notice that handwriting is forbidden. START HERE ——-You are asked to design a software package for Online insurance company: GEICO https://www.geico.com/ The requests include but not limited to: • • • • • Open new policy for different insurance types such as Homeowners, Renters, and Auto. Change the policy. Cancel the policy. Get new Quotes. Log in to the system since it’s an online platform: Notice that there are no guests and customers must log in to use the system’s services. Step 1. Draw a Use Case Diagram that consists of at least 5 use cases. Describe the relationship among the Use Cases by using “extend”, “include”. Step 2: Draw a class diagram (at least 5 classes) and describe the relationship among the classes such as one to one, Inheritance, (one to many) and (many to many) Association, Composition, or aggregation. On the class diagram, you must add the name of the relationship, add attributes and Operations (Methods) for each Class. You must provide the type of attributes and return type of the methods. You must provide at least 3 attributes and 3 methods for each class. Step 3: Draw three communication diagrams for the Use Cases you defined in Step 1. This step is called Use Case Realization. If you provide more than 3 correct communication diagrams, extra credits will be provided. Step 4: Draw an Entity relational diagram (ERD) out of class diagram in step 2, show only entities, one attributes which is primary key and underlined, weak and strong entities. Don’t forget to show the relationships and the multiplicity, double line only if it’s weak entities with its relationships. Show the partial and total participation. Step 5: Apply the ER to relational mapping algorithm and show the detailed steps as it was explained in the class and video. You must provide relational schema. Extra credit Create connected tables from step 5 and Insert 5 records into tables at least. Optimize your tables by applying 1nf, 2nf and 3nf. Write the reasons why you applied for each form. MORE extra credits if you run few a SQL commands from same table and different tables (screenshot SQL commands and result of SQL) END HERE………………………. Good luck,
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
