What is the outcome document produced by each of the following scenarios: A shipment is received at one of Sekhir's facility. a) Owner of Faan Burgers places an order of 200 buns directly to the usual vendor. b) An employee in Manama branch fill out a purchase form for a new printer. c)

What is the outcome document produced by each of the following scenarios: A shipment is received at one of Sekhir's facility. a) Owner of Faan Burgers places an order of 200 buns directly to the usual vendor. b) An employee in Manama branch fill out a purchase form for a new printer. c)

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 Scenario the Modeling of which you have completed in Assignment1: The Ministry of XYZ is the government body in the in charge of religious affairs. The application for Hajj is submitted to the hajj directorate, part of XYZ Ministry. Initial documents are submitted to the hajj directorate for registration. Documents are checked and verified by the Assistant Registration Officer. There are two categories of applicants based on their nationality. Specified percentage of seats are fixed for locals and other nationals. A unique registration number is issued to each applicant by the Assistant Registration Officer. After the completion of registration process, each applicant is asked to submit the detailed documentation which includes passport, vaccination certificate, medical certificate, receipts of payments. One Additional document (permission letter from home country) is needed for other national. Payments can be made through cash or card. Assistant Registration…
Read the following scenario and answer the questions given bellow.• A car rental company has its offices in three major cites of the area. Acostumer once registered with the company, can avail its services from anynearby office. Every office keeps record of the vehicles, their drivers andrenting details. Salaries of administrative staff are controlled at a single sitewhile the drivers are paid (according to the services they provide) from their local office. Rates for famous tourism spots are fixed (with a slight difference for different vehicles), while other spots are charged according to the mileage covered. 1. Identify the entities involved in the database designed for thecompany.2. Draw GCS for the system.3. Give details of any of the relations replicated on more than one sites
Create a BPMN model (2) (Business layer) of the following Business scenario: The company’s sales department receives an order from a buyer, while the finance department checks the buyer’s credit, and sends him/her an invoice when the order is fulfilled by the warehouse department. The order is considered complete if the buyer’s credit is sufficient, or the goods are in stock, otherwise the order fails, and the invoice isn’t sent. To fulfill the order, the warehouse department checks the availability of the order in the stock then allows to pick and then ship the order if it is available otherwise it is considered out of stock. In either case, the invoice is sent, and the order is considered complete, otherwise the order is failed.
After merging all the Colleges in University of Technology and Applied Sciences (UTAS) the course registration process is as follows: A student may register for classes during a specified registration period. To register, a student must see their advisor. The advisor must approve each course that the student has selected. The advisor will use the registration system to determine if the student has met the course prerequisites, is in good academic standings and is eligible to register. If the advisor approves the courses, the advisor enters the student's college id into the course registration system. The course registration number for each course is entered. The course description, course number and section for those courses will automatically display. The system will check for schedule conflicts before saving the registrations. A bill for the courses will print in the Bursar's office. The student should proceed to pick it up. A)ldentify the nouns that are used to identify the…
After merging all the Colleges in University of Technology and Applied Sciences (UTAS) the course registration process is as follows: A student may register for classes during a specified registration period. To register, a student must see their advisor. The advisor must approve each course that the student has selected. The advisor will use the registration system to determine if the student has met the course prerequisites, is in good academic standings and is eligible to register. If the advisor approves the courses, the advisor enters the student's college id into the course registration system. The course registration number for each course is entered. The course description, course number and section for those courses will automatically display. The system will check for schedule conflicts before saving the registrations. A bill for the courses will print in the Bursar's office. The student should proceed to pick it up. b)Draw a class diagrams which represents the generic…
Please solve this one I need help: Auto Workshop is a vehicle service centre located in the city ofMuscat, which provides vehicle maintenance/repair services.The charges of vehicle maintenance/repair are based on the type of theservice.Details of charges are as follow:Basic Tuning: 50 OMRSoftware Re-installation: 60 OMRParts Replacement: 100 OMRBody Paint: 120 OMRThe workshop offers 10% discounts to the customers who have membershipof the service centre.You are required to draw a flow chart diagram and write a C++ computerprogram that takes customer’s name, car plate number, membershipstatus(Y/N) and the required service (mentioned above). The programoutputs the input data and maintenance charges based on the serviceprovided by the service centre with discount, if applies.
Question 2: Muscat Auto Workshop is a vehicle service centre located in the city of Muscat, which provides vehicle maintenance/repair services. The charges of vehicle maintenance/repair are based on the type of the service. Details of charges are as follow: Basic Tuning: Software Re-installation: 60 OMR Parts Replacement: Body Paint: 50 OMR 100 OMR 120 OMR The workshop offers 10% discounts to the customers who have membership of the service centre. You are required to draw a flow chart diagram and write a C++ computer program that takes customer's name, car plate number, membership status(Y/N) and the required service (mentioned above). The program outputs the input data and maintenance charges based on the service provided by the service centre with discount, if applies.
A program called lsu [104] gives access to role accounts. The user's access rights are checked, and the user is required to enter her password. If access rules allow the change and the user's password is correct, lsu allows the change. Given that Mary uses lsu from her account, why does lsu require her to enter her password? Name the principles involved, and why they require this
A.1 Q is a local governmental organization (council) for a town in country U. It has a large call center to deal with queries and complaints from local residents and aims to ‘help callers find the information they need. Callers are asked to grade their satisfaction levels from 1 to 10 once they have completed their call, depending on how satisfied they were with their service. Currently, the higher the average grades given by callers across the year, the higher the bonus given to call center staff. The call center experiences a high volume of calls, with a number of calls going unanswered. Q has recently decided to change the performance mix for its call center staff. Staff will now be assessed on three separate measures: the number of calls taken by the center in the period, the average speed with which the call is handled and the total number of complaints about call center service received by Q. Each of these three measures will contribute equally to call center staff bonuses. Based…
In Bangladesh Premier League (BPL) player selection system, each team ownerpossesses a numbered paddle that is used to indicate a base price for a player. The BPLmanaging committee then starts the proceeding by mentioning the base price, and checkswhen a paddle is raised to accept that price to buy that player. As a result, the acceptanceof the player’s base price changes which is broadcast to all the team owners in the formof a new bid.Which design pattern is applicable here and why? Which design pattern is applicablehere and why?
Jeddah Municipality has decided to build a network of national hospitals to treat infectiousdiseases. A special task force is constituted which is tasked to investigate possible locations forthese new hospitals. The task force has done its job and come back with a list of potential sites.Each of these hospitals has an associated cost and will provide coverage to some number ofnearby districts within Jeddah. We can represent each potential hospital site as having: a name(string), cost to build the hospital (int) and a set of districts to be covered (Set of strings).Jeddah Municipality is interested in providing health care to all, but they do not have funds tobuild an unlimited number of hospitals. The goal is to provide coverage to as many districts aspossible using the available funds. For example, suppose Jeddah Municipality has the followingdistricts:Al-Aziziya, Ar-Rihab, Mosharafa, Al-Faysaliya, Bani Malik, An-Naseem, Al-Balad, Al-Salam, AlMakarona, As-Salmiya, Al-Gozain,…
The Great Bear Lodge is a hotel with an adjoining indoor waterpark and indoor minature golf center. The hotel sells packages which include overnight hotel stays with waterpark passes and minature golf passes. The hotel also has a plicy of selling daily passes to the indoor waterpakr and daily passes to the indoor minature golf center (in other words people do not need to stay at the hotel to use the indoor waterpark or indoor minature golf center.) Hotel guests may also choose to reserve just a hotel room without purchasing the waterpark or minature golf center passes. Great Bear Lodge is offering an incentive for the month of April. They are offering a package in which guests who reserve an overnight stay with the waterpark pass package will receive a free pass to the minature golf center. The total price for this package is $225 per night. The typical pricing for each of these sold independently are: One night hotel stay: $180, Daily Waterpark pass: $90, Minature Golf…