Week SAFMEDS

System analysis and design IT243 Assignment 2 Considering the following ER-Diagram, answer the following questions: Course Offerings Time : datetime Student Student Course SectionNum : int SID : int Name : varchar(255) Program : varchar(255) Roomld : int CourseNo : int Semester : char(2) Year : int StudentSID : int StudentSID : int Marks : int Examination ID : int Student_Course StudentSID : int Name : varchar(255) Place : varchar(255) Column a) What is the main role of an ER diagram in data modelling? b) How many courses each student can have? c) What is the relationship degree between the entities? d) Is there an associative entity, if yes can you name it? e) What is uniquely identifying the student entity table (Primary Key)?

Create an entity relationship diagram based on the following DFD Level 0

In an ERD in Chen notation, a __________ is signified by a double rectangular box.     weak entity strong entity strong relationship primary key

Pine Valley FurniturePine Valley Furniture’s customer trackingsystem project is now ready to move intothe systems design phase. You are excitedbecause this phase involves designing thenew system’s forms, reports, and databases.During this morning’s meeting with Jim Woo,he asked you to design several forms and reports for the new customer tracking system.During the requirements determinationphase, Jackie Judson requested that a customer profile be created for each customer.The customer profile is established whennew customers place their first order. Customers will have the option of not completinga profile; however, to encourage customerparticipation, a 10 percent discount on thecustomer’s total order will be given to eachcustomer who completes a profile. In thebeginning, existing customers will also begiven the opportunity to participate in thecustomer profiling process. Customer profileinformation will be collected via a customerprofile form.Gracie Breshers, a marketing executive,has…

Case Study 1: Nancy is leading a Scrum project for her organization. The project is to create new software for the Accounting Department. She is meeting with Tom, the director for the accounting department and the project team members to discuss the requirements of the project. Tom, Nancy, and the project team have identified all the requirements that Tom would like the app to have, but now Nancy wants to organize the list of requirements in a prioritized view. Based on this scenario, what role is Nancy? What role does Tom play? What can the scrum team do to help Nancy and Tom at this point of the project? What is the list of requirements called? Who should be prioritizing the list of requirements in this scenario?

Consider diagrams below. List rule violations on these diagrams Context Diagram DF3 EE1 Ship Сap & Gown EE2 DF1 Place Order Сap & Gown rto Student Сap & Gown DF4 Formatted Inentory Data D1 ventory DF2 Receipt Ordering System PO Level 0 Data Flow Diagram Place prder Cap & Gown Into Receipt Student Ship Cap & Gown 1.0 2.0 Inventory Data 3.3 Suppier Validate Order Order Update Inventory Finalization Formatted Inventory Status Inventory Data D1 Inventory

Computer Science Make this picture in electronic form, thank you！！！

Draw entity relationship diagram

Task 4

I need Activity Diagram

STUDENT STUDENT STUDENT NUMBER NAME 1035 Linda Mark 3397 4070 Sam Carr Kelly Goldman GRADE STUDENT COURSE NUMBER NUMBER CSC151 MKT212 ENG101 CHM112 ENG101 MKT212 CSC151 CSC151 CHM112 1035 1035 1035 1035 3397 3397 3397 4070 4070 TOTAL CREDITS 14 9 8 B A B A A C B B GPA C 3.40 3.75 2.50 GRADE 23 922 ADVISOR NUMBER 49 49 ADVISOR 49 ADVISOR ADVISOR NUMBER NAME Alice Jones Carlton Smith 23 OFFICE B-230 D-331

From the DFD Level 0 diagram provided, create a USE case diagram out of it, please use the use case diagram format provided.

Design a system to track advance payments made to employees. Use uml diagrams and design patterns in this system. The design steps will be as follows.   Step 1 - Prepare an analysis document on the given topic. Step 2 - Create a Use case diagram for your requirement that contains at least 3 actor, 10 use case and use all relationship type Step 3 - Create an activity diagram for requirement Step 4 - Create a class diagram for all requirement that contains at least 10 class, necessary relations and types. Add the important attributes of the classes to the model. Step 5 - Use three design patterns, at least one creation, one structural, and one behavioral pattern, integrated into your classroom design. Step 6 - Code one of the design patterns you use with java. Note: The design should be homogenate. Excessive usage of any property type, object type, or function type is not suitable. For example, for creating 10 relations between classes, the number of relation types for aggregation,…

1. Given the following use case diagram, a. draw the context diagram b. Data Flow Diagram of this system c. Pick two of the use cases and create System Analysis use case from them Traie Agancy Book a tour certann arme Conpay Book arine tiket TeaAgert Deliver ane etent Amwge tour PHy for ae e trave apert ockets iertend- Cutina Travel agent Pay tor tour commission Online Travel Agency

What should the relationship be between a Payment entity and an Insurance Policy entity in the Payment Pays Insurance entity relationship set where Payment is on the left?       one-to-one     one-to-many     many-to-one     many-to-many

Can you identify what each weak entity in this diagram

Sales VIN CO DID Date Price Customer CO is Company Covert in to EER diagram Name Address Phone Gender Annual income FK DID Sales Dealer Name Dealer Location HO Owns Vehicle VIN FK: Option 10 FK: Model Name FK Invertory FK: Customer ID FK: Manufacturer ID Access in inventory in Name In Location ALID FK: DID Has Car Model Modello Model Name Model Year Body Style FK Brand Name Provid Produces From Option Option ID Engine Transmission Color PKModelID Produces Dan Car Company COMID Company Name Num of Employees Brand Brand Name Num of Employees FK: COMID linked Manufacturer MNT MLocation VIN Supplier Name SLocation Supples Supples Part ID Part Type Made D Supply Date

A relationship between entity supertype and entity subtype is known as  _______.     Partial participation relationship     IS-A relationship     M : N relationship     Total participation relationship

topic: Restaurant required outputs d. relationship diagram

Draw an Entity Relationship Diagram for the proposed system based on therequirements showing the Entities, Attributes and Cardinality between entities.   Entities and Attributes Flavor Attributes: FlavorID, Name, Description Inventory Attributes: InventoryID, FlavorID, Quantity, ReorderThreshold Sale Attributes: SaleID, CustomerID, FlavorID, Date, Quantity, TotalAmount Customer Attributes: CustomerID, Name, Email, Phone Feedback Attributes: FeedbackID, CustomerID, Comment, Date, Rating Supplier Attributes: SupplierID, Name, ContactInfo Order Attributes: OrderID, SupplierID, FlavorID, OrderDate, Quantity, DeliveryDate Forecast Attributes: ForecastID, FlavorID, PredictedDemand, Date Relationships and Cardinality Flavor - Inventory One Flavor can have multiple inventory records. (1:N) Flavor - Sale One Flavor can be part of multiple sales. (1:N) Customer - Sale One Customer can have multiple sales. (1:N) Customer - Feedback One Customer can…

Question System: Sales Accounts Management System Reciprocal Sales Corporation is a global sales company that works with leading Fortune 500 corporations. The company offers sales consultants who assist these corporations with their product sales, marketing and advertising. Due to the rapid growth, a Software Development Department was established to improve and automate all the manual processes and workflows. The department is currently conducting a study in order to develop a new Sales Accounts Management System to assist the sales team with data capturing and information management. The sales team currently have an established and strict manual business process and workflow that they follow whenever they secure a new customer. A sales consultant collects information from a new customer and sends it to an admin assistant for data capturing. The admin assistant captures the customer information, opens the customer account and compiles a new customer report. Once finalised, the new…

system an alysis and design