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.

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…

SDLC - Requirement Analysis   For your course project you will specify the requirements. In this assignment you will produce the first deliverable for your course project, the requirements specification.   The purpose of this assignment is for you to learn how to write a complete and precise requirements specification, which is the first step in developing a large software system.   The teaching assistant is your customer, and he would like you to build a text editing system with the following features:   Text Editing System   A software system is desired for creating, storing, retrieving and modifying files of text. The text editing system will be accessible through a full-screen interface for interactive editing. The system will support a variety of editing commands, including inserting and deleting lines, modifying text in existing lines, and searching for text. You as the supplier are responsible for building a software system that meets the needs of your customer. However, they…

Q:What are the roles of a project sponsor and the approval committee during the different SDLC phases? Please no need copy paste

Business Rules: Each musician at NewTalent should have a name, address, and phone number on the system. The Instruments used in the songs have a unique name, musical genre (i.e. rock, pop, hip hop), and type (i.e. string, piano, guitar). Every album recorded under the NewTalent label has a title, copyright date, format, and an album identifier. Each song recorded has a title and an author. Musicians can play several instruments, and an instrument can be played by multiple musicians. Every album contains several songs, but a song can only appear on one album. Songs are performed by one or more musicians, and a musician can perform numerous songs. Each album has one musician acting as its producer, although a musician can produce multiple albums. Create an ERD for the above scenario that describes its business rules. Use Crow's Foot notations and make sure to include all of the following: All entities correctly identified with Primary key and any foreign key attributes.…

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.

Task1  Question(a), (b) and (c)

Select assessment method and create a digital rubrics for the method selected

Create a contract which successfully accomplishes the following tasks:- Add new employees with the following data: id, fullname, gender, email- Update employee information- Track an employee's check-in and check-out time- Review an employee's data- Track how many times an employee was absent for workAs always, only submit the .sol file.NOTES:- Contract must begin with 0 employees

When a prospective student wants to obtain more information about an educational institution and the courses they offer, they will phone the institution and make an appointment with a student advisor. When the appointment is made, the prospective student’s name, surname and contact number is recorded. After the appointment has taken place, the student advisor will record the key conversation points that were addressed during the meeting. The student advisor’s manager can then pull a report of the number of prospective students consulted and the type of questions they asked.”Q.2.1 Provide an example of a computer system. Q.2.2 Explain the role that the various components of a computer system will play in the scenario provided at the beginning of the question. Identify and explain the three basic operations performed by computers. Q.2.4 Identify one input device that a student advisor will use to capture the details of a prospective student.

You've added a new class (for example, Course) to your project and want to save its content to the database (e.g. save courses information in a database table). What precautions do you need to take?

NOTE: There are multiple assignments due this week. 3 diagrams, a database design document, a data dictionary, table definitions, cybersecurity plan, source code, and a software test plan (see template below).   Project implementation is arguably the most exciting stage of the project management process. It is during project implementation that project plans begin to come to life and assumptions are able to be tested and measured in real-life scenarios.   One of the outcomes of project implementation is a set of deliverables that typically includes a system diagram; a network diagram; a database design document, including an entity-relationship diagram, a data dictionary, and table definitions; a clearly articulated cybersecurity plan; and source code.   To complete this assignment, you will create: A system diagram that shows, in graphic form, the components of your project. Your system diagram should follow the system description you submitted in your Week 2 project plan (but may…

no plagiarism and 100% unique

Task 3: The StayWell property management team wants to get in touch with those owners having properties larger than 2,000 square feet. You need to return all the available information of the corresponding owners to the property management team. Task   Return a list of all the property owners having properties larger than 2,000 square feet. 1 Task 4: The StayWell maintenance team wants to minimize the number of planned visits to properties. The team wants to learn all the properties that have different planned service dates. You need to return all available data in the SERVICE_REQUEST table, where requests are made for the same property with a different NEXT_SERVICE_DATE. Task   Return a list of all properties where service requests are made with different NEXT_SERVICE_DATE values.

Q.6.3.4 Write a SQL statement to get a list of the tasks in the database, arranged by duration from largest to smallest. Include all the columns from the Task table. Q.6.3.5 Write a SQL statement to get the total duration of all the tasks that start between 2022-05-01 and 2022-05-31 (both inclusive).