Q3|I Produce a use case model for the following scenario: "The hotel housekeeping manager checks the requirement file once weekly to ensure that there are sufficient quantities of soaps, shampoos etc. Where necessary, an order is raised to be sent to the supplier. Copies of the orders are kept and used to check the supplier delivery notes and invoices when they are received. Occasionally the suppliers are unable to send the requested things and suggested alternatives. Once the requirements have been supplied the stock file is updated."

Q3|I Produce a use case model for the following scenario: "The hotel housekeeping manager checks the requirement file once weekly to ensure that there are sufficient quantities of soaps, shampoos etc. Where necessary, an order is raised to be sent to the supplier. Copies of the orders are kept and used to check the supplier delivery notes and invoices when they are received. Occasionally the suppliers are unable to send the requested things and suggested alternatives. Once the requirements have been supplied the stock file is updated."

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Consider the following requirements of a car rental company: A member may rent more than one car and a car can be rented by more than one member in a given period. Cars are classified into categories (For example; economy, premium, SUV). A car is assigned to only one driver, but a driver can drive many cars. A car can only belong to one category, but a category can have one or more cars. Details of car rent must be recorded to reflect the rent duration and cost. 1. What are the possible entities in this business case? 2. Suggest 2 relationship names that might exist between the entities 3. List at least 2 attributes of each entity?
4. Company TeaLeaves has recently adopted a new order management system for handling production requests. The sales representative can place a new order for production. If special materials are required for producing the new order, then an order is placed for special materials with the supplier. Otherwise, if no special materials are required for producing the new order or the supplier has finished providing the special materials, the order is added to the production list. Afterwards, the order is scheduled for production. Once the order is confirmed, a letter is generated to the sales representation and to the manager. Draw the activity diagram for the above scenario.
A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of CHEMIST include Employee ID (identifier), Name, and Phone No. Attributes of PROJECT include Project ID (identifier) and Start Date. Attributes of EQUIPMENT include Serial No and Cost. The organization wishes to record Assign Date—that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A chemist must be assigned to at least one project and one equipment item. A given equipment item need not be assigned, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.
Business System ERD Create an ERD based on the Crow’s Foot model, using the following requirements: An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. An INVOICE can include many detail lines (INVOICE_ITEM), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity. The product’s vendor information is found in a VENDOR entity. You do NOT need to put any fields/attributes into this ERD. Just draw the entities as empty boxes with relationships between them.
A course instructor will assign grades from (A, B+, B, C+, C, D+, D, EJ. What is the minimum number of grades that must be assigned in order to guarantee at least one of the grades has been assigned 10 times.
Draw a sequence diagram for the “Apply for Leave” use case: Employers need to login into thesystem using correct username and password, input the start and end date of the asking for leave,and then submit the request to the leader of the department. The leader approve the request or not. Ifthe leader approve the request, the request will be submitted to the HR to process. HR will decidewhether to approve the request according to the regulation of the company, and then send the finaldecision to employers and Accounting staffs. Build an activity diagram to describe the “Apply for Leave” in question
An university has decided to grant loans for the students. For this the financial administrator has to check with the number of students apply for loan with "Manage Loan and Grants" view. Student can enroll themself and apply for loan. Financial administrator will check whether the students has cleared the tuition fees up to last year, if the student is applying loan for current year tuition fee and enrollment was done for courses like seminars, etc. Professor will be allotted for the course once students got enrolled for subject. The actors involved in the system are student, scheduler, financial administrator and professor. The packages that are linked in the system are manage loan and grants, manage fees, manage seminars, enrollment. Identify the dependencies between one element and the other by drawing a package diagram for
Draw an ERD for the following problem:Company organized into departments. Each department has unique, name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations. A department controls a number of projects. Projects have a unique name, number and a single location. Company’s employees name, ssno, address, salary, sex and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; the immediate Supervisor for the employee. Employee’s dependents are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).
Draw a sequence diagram for the “Apply for Leave” use case: Employers need to login into thesystem using correct username and password, input the start and end date of the asking for leave,and then submit the request to the leader of the department. The leader approve the request or not. Ifthe leader approve the request, the request will be submitted to the HR to process. HR will decidewhether to approve the request according to the regulation of the company, and then send the finaldecision to employers and Accounting staffs.
Scenario – 2 Suppose that you are developing ERD about reality shows on TV. For each reality show, itsname, genre, basic_info and participants name. Any reality show has at least two or moreparticipants. Reality show may run for multiple days during the week. For each producer, thecompany name, company country is stored. A show is produced by exactly one producer. Andone producer produces exactly one show. For each television, its name, start year, head officeis stored. A television may broadcast multiple shows. Each show is broadcasted by exactly onetelevision. For each user, his/her username, password, and age is stored. A user may ratemultiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.Every show comes with Advertisement. Advertisement may belong to Single or more shows.Every advertisement will have customer who will pay for different packages for advertisements.Advertisements may vary from Reality show. Task to do: i. Identify Entities…
Create a use case sequence diagram using the information below. Buy Parts Customer/Store Employee Description: This use case describes car parts dealer purchasing. Successful Finish: client requests vehicle component 2. Store associate verifies availability 3. component is available and client pays cost 4. Customer receives part; stock adjusted. 1. Customer asks auto part 2. Store Associate checks part availability 3. Part is unavailable and customer chooses to order part or no part 4. Customer receives part and stock is updated (if alternate part ordered) or leaves without part. Alternative: Customer wants component. No post-condition No assumptions
Schema: Part(PartNo, PartName, VehicleType, UnitPrice, SalesPrice) Service(ServiceNo, PartNo, ServiceDate, CustomerNo, Qty) Constraints: i. Vehicle Type should be V1', V2', 'V3', 'V4', or 'V5' ii. UnitPrice and SalesPrice should be greater than zero iii. PartNo, FK in Service refers to PartNo, PK in Part Data: Part Service P1 V1 10 12 1 01-Jan-17 C1 P2 V2 100 110 3 01-Jan-17 C1 4 P3 V1 150 175 2 3 05-Feb-18 C2 10 P4 V3 200 250 3 1 15-May-18 СЗ 9. P5 V2 75 90 1 03-Jun-19 C1 Write a PL/SQL program to find the total profit done in the sales of a given part number in the service of different customer vehicles. Raise an exception for invalid part number. 12345n