SITXHRM008_AE_Pro2of2 _ Messages and Recordings (1)

List the changes  needed to make the requirements change so a student can have more than one advisor and list the changes needed to make the requirements change so that you must store the year and the semester in which a student took a course and received a grade.

Create use case diagram based on the user story

Task2 :   Updating Order Status Create a procedure named STATUS_SHIP_SP that allows an employee in the Shipping. Department to update an order status to add shipping information. The BB_BASKETSTATUS table lists events for each order so that a shopper can see the current status, date, and comments as each stage of the order process are finished. The IDSTAGE column of the BB_BASKETSTATUS table identifies each stage; the value 3 in this column indicates that an order has been shipped.     The procedure should allow adding a row with an IDSTAGE of 3, date shipped, tracking number, and shipper. The BB_STATUS_SEQ sequence is used to provide a value for the primary key column.   HINT: In your Procedure main part (BEGIN _END)   BEGIN   INSERT INTO bb_basketstatus (idstatus, idbasket, idstage, dtstage,                                shipper, shippingnum)   VALUES (bb_status_seq.NEXTVAL, p_basketid, 3, p_date, p_shipper,           p_shipnum);   COMMIT; END;   bb_status_seq.NEXTVAL  is auto…

Please to create a chart base on the information below cross functional interactions chart for a recovery policy request Please show the satrt and end on the chart it a recovery Policy request  The Policy Change Request process diagram should start with the client submitting a request for a change in coverage to the customer service department. The customer service representative will verify the client's information and send the request to the accounts department for approval. Once approved, the IT department will update the client's deduction amount in the system and notify the Marketing department to update the client's policy premium. The Finance department will also notify the client's employer of the updated deduction amount.

How many records does the file contain? How many fields are there per record?

Create an organisational chart with at least 15 employees. The chart should display at least 4 levels. Be sure to include the title/role of each person.

A team member hears the term Validate Scope and is confused by its purpose. Which of the following is not a response you would give this team member

ERD Case: A Project ID identifies each project. Each project is also given a short title that may or may not be unique and may be given a longer description. A project manager must manage each project and may have many team members assigned to work on it. Some of the team members may work on more than one project. The project has a start date and scheduled completion date. The project also has a total estimated cost. Employee ID identifies people in the company, although the project manager needs to know the name, phone number and e-mail address assigned to each member of his/her team. The project manager also needs to know when an employee is officially assigned to a project and when is relieved from a project. An employee can be a full-time employee or a part-time employee. For a full-time employee, information on the medical benefit provided by the company to the employee is kept. For a part-time employee, information on the contact term and duration is kept. Each project consists…