A- design the physical DFD level 1 for the following system. “In a video rental store the secretary receives a request from the customer to rent a movie then she saves the rent information in the rental file and gives the customer the bill. When the customer returns the video the secretary puts it in the video library file and signs the bill before returning it to the customer and finally return the rental information to the rental file. The manager wants a final report of all videos that have been rented so the secretary generates that report from the information in the rental file”.

A- design the physical DFD level 1 for the following system. “In a video rental store the secretary receives a request from the customer to rent a movie then she saves the rent information in the rental file and gives the customer the bill. When the customer returns the video the secretary puts it in the video library file and signs the bill before returning it to the customer and finally return the rental information to the rental file. The manager wants a final report of all videos that have been rented so the secretary generates that report from the information in the rental file”.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 3.20CP

See similar textbooks

Similar questions

Course: Software Engineering A web based software for an online book store is to be developed when a valid customer logon to the site a list of available books is displayed. When the customer selects the required book a form will be displayed that will take input the credit card number and other necessary information of the user. After submission of the form by the customer the validity of the credit card is ensured by a banking system (external to the system). The valid orders are passed to the shipment department and an email is sent to the customer that his order is being shipped. Mention your brain storming as well before the drawing. Write four functional (user+system) requirements. Draw level 1 DFD of the given scenario. Draw ERD of the given scenario.
Overview: A famous factory has bought new machines for each one of its product lines. The manager of the factory has decided to assign some workers from each product line to attend training workshops in order to know how to use the new machines where workshops will be given by engineers from the company manufactured the machines. In this TMA, it is required to help the manager of the factory keep track of the workshops and workers assigned to them. Requirements: After a quick meeting with the manager of the factory, you got the following information: Each worker has a civil ID (which is unique), a name and cannot attend a workshop not given to his/her product line. Each engineer has a civil ID (which is unique), a name and other attributes (add at least 2 attributes from your choice). He/she could give more than one workshop. There is a unique reference number for each workshop. Each workshop will be given by an engineer and to a specific product line. Workers could be added or removed…
Video-Rental LTD case study Video-Rental LTD is a small video rental store. The store lends videos to customers for a fee and purchases its videos from a local supplier. A customer wishing to borrow a video provides the empty box of the video they desire, their membership card, and payment – payment is always with the credit card used to open the customer account. The customer then returns the video to the store after watching it. If a loaned video is overdue by a day the customer's credit card is charged, and a reminder letter is sent to them. Each day after that a further card is made, and each week a reminder letter is sent. This continues until either the customer returns the video, or the charges are equal to the cost of replacing the video. New customers fill out a form with their personal details and credit card details, and the counter staff gives the new customer a membership card. Each new customer form is added to the customer file. The…
Case Study – Personal Trainer Personal Trainer, Inc. Fact-Finding Summary A typical center has 300-500 members, with two membership levels: full and limited. Full members have access to all activities. Limited members are restricted to activities they have selected, but they can participate in other activities by paying a usage fee. All members have charge privileges. Charges for merchandise and services are recorded on a charge slip, which is signed by the member. At the end of each day, cash sales and charges are entered into the BumbleBee accounting software, which runs on a computer workstation at each location. Daily cash receipts are deposited in a local bank and credited to the corporate Personal Trainer account. The BumbleBee program produces a daily activity report with a listing of all sales transactions. At the end of the month, the local manager uses BumbleBee to transmit an accounts receivable summary to the Personal Trainer headquarters in Chicago, where member…
Q: Explain the document downloading task card please.
Overview: A Sports Club is an organization formed in order to help its members develop interest in certainsports.Usually, members interested in the same sport are divided into groups and an expert trainer is responsible for training each group.In this TMA, it is required to help the head of a Sports Club for kids implement application to keep track of the kids (members of the club) and the sports they are interested in.Requirements:After a quick meeting with the head of the sports club, you got the following information: It is required to store the whole data (all groups of all sports) in one collection. Each group has a number, a trainer and they are interested in a certain sport (e.g. football). In addition, it contains many kids with flexibility of adding and removing kids within a given limit for the maximum number of kids who could be in the same group (where this limit is fixed and unified for all groups). Furthermore, there are other attributes (add at least 2attributes from…
Process Sale: A customer arrives at a checkout with items to purchase. The cashier uses the POS system to record each purchased item. The system presents a running total and line-item details. The customer enters payment information, which the system validates and records. The system updates inventory. The customer receives a receipt from the system and then leaves with the items.
Case Study: A Video Store (AVS) runs a business of renting out video to customers. Every customer must have a AVS customer card in order to rent a video, or he need to apply for one. Customers rent videos for three days at a time. Every time a customer rents a video, the system must ensure that they do not have any overdue videos. If so, the overdue videos must be returned and an overdue fee paid before customer can rent more videos. Likewise, if the customer has returned overdue videos, but has not paid the overdue fee, the fee must be paid before new videos can be rented. Every morning, the store manager prints a report that lists overdue videos. If a video is two or more days overdue, the manager calls the customer to remind them to return the video. If a video is returned in damaged condition, the manager removes it from the video database and may sometimes charge the customer. Task 1: Behavioral communication diagram. Create a communication diagram…
Systems Analysis Assignment (Microsoft Word and Excel) You and your team have been hired to set up a computer classroom for Tech United, Inc. An up and coming tech startup who will like to become a tech training company. Tech United, Inc. wants to offer various different kinds of tech training at their new office location. They have only one classroom space available that can accommodate up to 30 students. The classroom is already equipped with tables and chairs. The classroom, however, does not have any computers, routers, projectors, smartboard etc. This is where you come in. The company has $40,000 as a starting budget and will like for you to determine for them what computers/keyboards/mouse/router/printer/smartboard etc. they should buy. You determine based on their budget, how many of each item should be purchased for the classroom. Deliverables Deliverable Part 1: A systems analysis report on what kind of computers and hardware the company should use in their classroom,…
CASE STUDY AITAM LIBRARY MANAGEMENT SYSTEM AITAM Public Library is the biggest library in Koforidua. Currently, it has about 300 members. A person who is 18 or above can become a member. There is a membership fee of GHC400 for a year. There is a form to be filled in which person fills personal details. These forms are kept in store for maintaining members’ records and knowing the membership period. A member can issue a maximum of three books. He/she has three cards to issue books. Against each card a member can issue one book from library. Whenever a member wishes to issue a book and there are spare cards, then the book is issued. Otherwise that request is not entertained. Each book is to be returned on the specified due date. If a member fails to return a book on the specified date, a fine of GHC 2 per day after the due return date is charged. In case a card gets lost, then a duplicate card is issued. Accounts are maintained for the membership fees and money collected from the fines.…
Do as directed This describes the business process to publish an academic paper. The author submits a paper to an editor in chief of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor in chief assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor in chief. The editor in chief then assesses the quality of the paper with the help of reviewers comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper. a) Apply query to only access to compile the final decision to editor in chief and only visualized by author not reviewers.
Activity diagram,Registration System At the begening of each term a student can demand a prospectus containing a course list. data about a course is provided, such as the instructor, department and pre-requisites. The Registration System let the students create a schedule, then choose 4 courses. Each student chooses two others in case their first choices become full or are cancelled. No course can have more than 10 students. No course can have less than 3 students or it will be cancelled. This functionality are also available to the other users of the system. When registration is finished, the registration system sends a message to the billing system to email a bill to the student. Instructors use the system to find which classes they are teaching and who the students are. The registrar will administer the system. At the beginning of the term the student can change their schedule. Students are allowed to access the system during this time to add or delete courses