Assignment 6 - INFO 623

Design an entity- relationship diagram

Course Title: Object Oriented Analysis and Design Question : There is a utility company which provides waste management services to citizens. It has a CRM system, billing system, messaging system and mapping (GIS) system. When a customer is created in the CRM system, the billing, messaging, and GIS systems need a copy of customer data to perform follow-up tasks and automation. For instance—the billing system will create a billing account for the customer, the messaging system will send a welcome message with customer account details on preferred communication channel and the GIS system will update the customer’s address in the database for mapping purposes. After completion of one billing cycle the billing dept. sends a copy of the bill in a pdf format on the customer email address and the bill amount is directly debited from the customer’s bank account. Draw an appropriate Activity diagram . (Note):  Forks and joins have the same notation: either a horizontal or vertical bar (the…

Draw a SEQUENCE DIAGRAM                                          Purpose: High level UML sequence diagram for Research Paper Reviewing. Summary: User can search for his submitted, under review and published articles. He/she can view revisions/ comments of the reviewers, the process must be blind reviewed, there must be performance evaluation criteria of the reviewers, and the process must be speedy.

Q: Explain KNN classifier in detail.

Consider a conceptual schema given below. LONGER TSERVICE SHORTER TSERVICE total-days total-hours DRIVER TSERVICE dlnumber enumber first-name last-name phone[e..] ID1 ID2 BUS departure-city destination-city departure-time arrival time ID ID ID Assigned-to - - Assigned-to date-when-assigned ID rego make 1..* snumber Passes-through 0..1 date-when-discharged STOP stop-City edap larrival-time Your task is to perform a step of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. For each relational schema clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any). Assume, that a superset method must be used to implement a generalization. T0

Design EERD schema for the system.

In a(n) _____, nodes with the same parents are called twins or siblings. a. relational model b. hierarchical model c. network model d. object-based model

On class diagrams Classify the following into generalization (G), association (A), aggregation (AG), or composition (C): a) A country has a capital city b) A dining philosopher uses a fork c) A file is an ordinary file or a directory file d) Files contain records e) A class can have several attributes f) A relation can be association or generalization g) A polygon is composed of an ordered set of points h) A person uses a computer language on a project

Cohesion and coupling work together.

Develop the Context Level DFD and DFD Level 0 Diagram for the attached picture

Create an Access Matrix for the given domain structure: D1: D2: D3: D4:

ER diagrams, Information management, Database

Draw UML diagrams for online shopping system (use case diagram, class diagram). Based on the requirements and the scenario.

Java OOP: Polymorphism

Provide detailed explanation with diagram and code for the following Design patterns   Singleton Proxy Builder Chain of responsibility

Explain the biggest drawback of one-vs-one multi-class classification when compared to one-vs-all multi-class classification. Be specific.

O True O False 6. Every aggregation relationship is an association * O True O False 7. Removing a duplicate code in the program is an example for * (1 Point) Reverse engineering

Express the following as semantic net with interconnected nodes and labelled arcs: Company ABC is a software development company. Three departments within the company are Sales, Administration and Programming. Joe is a manager of programming. Bill and Sue are programmer. Sue is married to Sam. Sam is editor of PHI. They have three children and they live on Elim street. Sue wears glasses and is 5.5 feet tall.