Individuals quiz 3

help

don't copy

Question 1: Case Description   INU Printing Press, a part of a university undertakes printing jobs from different departments of the University. The press can take printing-related orders from other organizations or individuals also, but this is a rare practice. Orders once placed cannot be canceled. Any financial transactions of the various departments with the printing press are done through the University Office only. The University Office maintains the accounts of the press and the various departments of the University. The press acquires its inventory from outside suppliers. This is done by accepting the quotations from various suppliers and placing orders respectively. They maintain information of vendors/suppliers for the raw materials. A supplier can supply more than one item and an item can be supplied by more than one supplier. The supplier may supply the item in parts. Stock for a particular item can be acquired more than once a year. The suppliers send two copies of the…

Use the preamble below to answer QUESTIONS I and QUESTIONS 2 A university SOG is made up of employees who belongs to the various departments and are characterized by their staff ID, first name, last name and date of birth. Also students are part of the university and can also be characterized by student ID, first ame, last name, date of admission. Every employee and student belongs to a particular department which can be characterized by the department ID and the department name. Again all students offer a particular program which can be identified by the program ID and program name and also a course that is offered by the students that can be identified by the course ID and the course name. a. Create SOG University database using SQL Data Definition Language. b. Create two (2) tables in the SOG University database from the schemas in QUESTION Ie using SQL. Data Definition Language. c. List the student ID of all students who do not belong to a department with departmentID7 in the SOG…

Question 1: Case Description INU Printing Press, a part of a university undertakes printing jobs from different departments of the University. The press can take printing related orders from other organizations or individuals also, but this is a rare practice. Orders once placed cannot be canceled. Any financial transactions of the various departments with the printing press are done through the University Office only. The University Office maintains the accounts of the press and the various departments of the University. The press acquires its inventory from outside suppliers. This is done by accepting the quotations from various suppliers and placing orders respectively. They maintain information of vendors / suppliers for the raw materials. A supplier can supply more than one item and an item can be supplied by more than one supplier. The supplier may supply the item in parts. Stock for a particular item can be acquired more than once in a year. The suppliers send two copies of…

1. Rick and Ryan Enterprises is an agency that specializes in representing clients in the fields of sports and entertainment. Given the nature of the business, some employees are given a company car to drive and each company car must be assigned to an employee. Each employee has a unique employee number, plus an address and set of certifications. Not all employees have earned one or more certifications. Company cars are identified by their vehicle ID and also contain a license plate number, make, model, and year. Employees represent clients. Not all employees represent clients while some employees represent many clients. Each client is represented by one and only one employee. Each client has a unique client number. Additional attributes required for each client are name, address, and date of birth. Draw an ER diagram that shows the entity types and the relationship types for Rick and Ryan Enterprises. While you must name each relationship type and define the structural constraints…

Note: Terry’s phone is not available in the evidence. However, several files that originated from the phone exist somewhere in the evidence. Can you find them? Are they related to the case?   2009-M57-Patents The 2009-M57-Patents scenario tracks the first four weeks of the 13corporate history of the M57 Patents company. The company started operation on Friday, November 13th, 2009, and ceased operation on Saturday, December 12, 2009. As might be imagined in the business of outsourced patent searching, lots of other activities were going on at M57-Patents.

Create a case of Patent (from start till registration process)

How does SRS determine whether or not a requirement exists?

Q : Draw an ERD from the following business rules: Use proper notations for the type of attributes. A software system is to be developed for an educational institute. The software is intended to be used by faculty members, students and designated support staff. System administrator will also use system for system administration and management. Student’s data including names, registration number, cell numbers and address will be added and edited by Clerk. The data will be added at the time of student reporting at campus. Student can enroll into any course of their choice from the offered courses. They can also request for dropping a course. Approval of course dropping of a student will be granted or refused by academic coordinators.

The Big State University course catalogue reads as follows: “To enroll in MIS 260, which is an advanced course, a student must complete two prerequisites: MIS 120 and MIS 222. A student who completes either one of these prerequisites and obtains the instructor’s permission, however, will be allowed to take MIS 260.” Create a decision table that describes the Big State University course catalogue regarding eligibility for MIS 260. Show all possible rules.

Please see attached file for the problem. i hope you can help me out

Requirements About the System: A local library intends to modernize its operations and seeks your assistance in designing its system. The following are the requirements for the library system: The library possesses a collection of books that can be borrowed by its members. Each book has a unique ISBN, title, author, and publication year. Members can search for books, check their availability, and place a hold on a book if it is unavailable. When a book is available, the member can borrow it and the due date will be calculated based on the library's lending policy. Members can return books, and the system should keep track of the books they have borrowed and the ones they have returned. Questions:   Q1: Use Case Diagram: Identify the use cases for the library system and draw a use case diagram to depict the relationships between the actors and use cases. how to create use case diagrams: https://drawio-app.com/uml-use-case-diagrams-with-draw-io/   Q2: Identification of Classes and…

Requirements About the System: A local library intends to modernize its operations and seeks your assistance in designing its system. The following are the requirements for the library system: The library possesses a collection of books that can be borrowed by its members. Each book has a unique ISBN, title, author, and publication year. Members can search for books, check their availability, and place a hold on a book if it is unavailable. When a book is available, the member can borrow it and the due date will be calculated based on the library's lending policy. Members can return books, and the system should keep track of the books they have borrowed and the ones they have returned.  Q1: Use Case Diagram: Identify the use cases for the library system and draw a use case diagram to depict the relationships between the actors and use cases. (I need help with a use case diagram using the requirements above. We are doing these in drawio) Here is an example of what one is supposed to…

Requirements About the System: A local library intends to modernize its operations and seeks your assistance in designing its system. The following are the requirements for the library system: The library possesses a collection of books that can be borrowed by its members. Each book has a unique ISBN, title, author, and publication year. Members can search for books, check their availability, and place a hold on a book if it is unavailable. When a book is available, the member can borrow it and the due date will be calculated based on the library's lending policy. Members can return books, and the system should keep track of the books they have borrowed and the ones they have returned. Question: Sequence Diagrams: Draw a sequence diagram including:  the scenario where a member searches for a book and borrows it   the scenario where a member returns a book to the library How to create sequence diagrams:  https://drawio-app.com/create-uml-sequence-diagrams-in-draw-io/

Draw the associations that are described by the following business rules. Include the multiplicities for each relationship. (4 marks) A patient must be assigned to only one doctor, and a doctor can have one or many patient: An employee has one phone extension, and a unique phone extension is assigned to an employee. A bookstore sells at least one book, and a book can be sold at up to 10 other bookstores around town.

a) Draw use case diagram for Altered State University (ASU) Registration System Professors indicate which courses they will teach on-line. A course catalog can be printed Allow students to select on-line four courses for upcoming semester. No course may have more than 10 students or less than 3 students. When the registration is completed, the system sends information to the billing system. Professors can obtain course rosters on-line. Students can add or drop classes on-line. b) Draw Activity diagram for business process of meeting a new client A salesperson calls the client and sets up an appointment If the appointment is onsite (in the consulting firm's office), corporate technicians prepare conference room for a presentation If the appointment is offsite (at the client's office), a consultant prepares a presentation on a laptop. The consultant and the salesperson meet with the client at the agreed- upon location and time The salesperson follows up with a letter If the meeting has…

Describe the concept of modifiability.

Definition of redundancy and problems that can occur due to redundancy.

SQL

Question e (IT 3530 Fundamental of Information Systems Security)   In this chapter (module), we discussed Auditing, Testing, and Monitoring. The chapter discussed various audit data collection methods. Which of these methods do you think is the most valuable in providing the necessary data for an audit  Full explain this question and text typing work only thanks

Differentiate between Ternary relationship and three binary relationships.