Draw appropriate Context Diagram and DFD Level O for the following case study. State any assumption for the diagram. A Rent-A-DVD (ARD) runs a series of fairly standard DVD stores. Before a DVD can be put on the shelf, it must be catalogued and entered into the DVD database. Every CUSTOMER must have a valid ARD customer card to rent a DVD. CUSTOMER rent DVD for three days at a time. Every time a CUSTOMER rents a DVD, the system must ensure that he or she does not have any overdue DVDS. If so, the overdue DVDS must be returned and an overdue fee must be paid before the customer can rent more DVDS. Likewise, if the customer has returned overdue DVDS but has not paid the overdue fee, the fee must be paid before new DVDS can be rented. Every morning the store MANAGER prints a report that lists the overdue DVDS; of a DVD is 2 or more days overdue, the manager calls the customer to remind him or her to return the DVD. If a DVD is returned in damage condition, the manager removes it from the DVD database and may sometimes charge the customer. SUPPLIER provides DVD descriptive information to the system.

Draw appropriate Context Diagram and DFD Level O for the following case study. State any assumption for the diagram. A Rent-A-DVD (ARD) runs a series of fairly standard DVD stores. Before a DVD can be put on the shelf, it must be catalogued and entered into the DVD database. Every CUSTOMER must have a valid ARD customer card to rent a DVD. CUSTOMER rent DVD for three days at a time. Every time a CUSTOMER rents a DVD, the system must ensure that he or she does not have any overdue DVDS. If so, the overdue DVDS must be returned and an overdue fee must be paid before the customer can rent more DVDS. Likewise, if the customer has returned overdue DVDS but has not paid the overdue fee, the fee must be paid before new DVDS can be rented. Every morning the store MANAGER prints a report that lists the overdue DVDS; of a DVD is 2 or more days overdue, the manager calls the customer to remind him or her to return the DVD. If a DVD is returned in damage condition, the manager removes it from the DVD database and may sometimes charge the customer. SUPPLIER provides DVD descriptive information to the system.

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

Draw a use-case diagram and create a set of activity diagrams for the following system. A Video Store (AVS) runs a series of fairly standard video stores. Before a video can be put on the shelf, it must be cataloged and entered into the video database. Every customer must have a valid AVS customer card in order to rent a video. 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…
Read the following scenario and draw a data flow logical diagram that includes both the context diagram and the '0' level diagram (0 diagram) on a piece of paper, take a clear picture and upload it as the solution to this question. ABC Video Shop plans to develop a video rental system. This system allows Video Shop employees to enter and store details of all videos / movies in the video file. The system enables members to enter required videos / movies and rent videos / movies, if available in store. All the videos / movie rental details will be stored in the rental file. Then the system calculates the invoice amount for the rental video / movies and sends the invoice amount details to print the invoice / receipt. Now the system will print the invoice and issue it to the member, and the members will pay the invoice amount and settle the transactions.
Create a use case diagram for the following system: A video store (AVS) runs a series of faily standard video stores. Before a video can be put on the shelf, it must be cataogued and entered into the video database. Every customer must have a valid AVS customer card in order to rent a video. Customers rent videos for for three days at a time. Everytime a custmer rents a video, the system must ensure that this customer does not have overdue 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 him or her to return the video. If a video is returned in damaged condition, the manager removes it from the video database and may somtimes charge the customer.
Create a UML Activity Diagram for processing an order. Once an order has been finalized, four parties are involved in processing it: Online Sales, Accounting, Shipping, and Printing. Online Sales receive the order and sends the order to Printing, where the associated PDF file is inspected. If the file is not suitable, a new file is requested from the customer, and the received new file goes for the inspection. Once the file is suitable, Accounting is informed to charge the credit card. While this is done, Printing carries out the actual printing, and sends the result to Shipping. When Shipping has both received the printed products and confirmation from Accounting that payment was successful, the products are shipped to the customer. answer step by step and take screen shoot for your answer
1. Part 1 Below is the description of a Clothes Information Store (CIS) System. Customers are identified by a customer ID. Customer names, addresses, and ages must be recorded. Brands are identified by a brand ID. For each brand, the brand name, country of origin, and year of establishment must be recorded. ● ● ● Each clothing item has a unique clothing item ID. • Each clothing item has a name, description, and price. ● ● Each brand has at least one clothing item. Each clothing item has only one brand. Each brand produces multiple clothing items. Customers purchase clothing items. A customer could purchase one or more clothing items, and a clothing item could be purchased by (zero or) one customer. Question: Develop an ER diagram that describes a conceptual model for CIS. 1. Indicate the primary key for each of the entities. 2. Include the attributes for the different entities in the ER model. 3. Include the cardinalities of the different relationships.
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
(Deadline: 28 Dec 2021) Part 1: (7.5 %) Design the use case diagram for the following scenario: This system is a monitoring system which manages the transports of UHB's buses, and the system is servicing the undergraduate students, faculty and staff and provides information to them like the transports bus times. Also, the system is connected to other systems like UHB login system and SIS database. The system should schedule bus's stops and enable the manager to add, delete or change a bus's stop. The manager can also change the bus's transports times and add or delete buses. The system should allow the route coordinator to create, modify or delete a route. The route coordinator can also schedule the bus services from UHB to various commercial centers in Hafr Al-Batin. The system should allow the faculty, staff, or students to request a bus service. They can also issue complaints regarding a specific bus or driver. All users should login to the system through the university's login…
Create an ER diagram for the following requirements:You are asked to design a database to store music album information. A simplified set of requirementsare provided below.- A music album has a title, year of release, total running time, one or more artists, and list ofsongs.- Each song has a lead artist and may have a list of additional artists. Each song has a list of otherassociated people such as mixer, mix engineer, keyboards, guitar, etc. Each song has a genre,running time, and lyrics. Each song can be associated with many albums, but needs to beassociated with at least one.- Each person has a first name, last name, and nickname.
Case Study 2:A commercial bakery makes many different products. These products include breads, desserts,specialty cakes, and many other baked goods. Ingredients such as flour, spices, and milk arepurchased from vendors. Sometimes an ingredient is purchased from a single vendor, and othertimes an ingredient is purchased from many vendors. The bakery has commercial customers,such as schools and restaurants, that regularly place orders for baked goods. Each baked goodhas a specialist that oversees the setup of the bakery operation and inspects the finished product.Exercise:1. Draw an entity-relationship diagram for the above situation.2. List the tables and keys that are needed to implement the commercial bakery system.
Create a UML Use Case Diagram for the following scenario: Scenario: CDM - Cash Deposit Machine User can do different types of transactions named withdraw, transfer or deposit cash at the CDM in association with the bank.In every transaction type, the system will validate the user.During the withdraw, insufficient funds notification may arises.Staff fills the CDM. he needs to shut down the system during filling.
Create an ER Diagram for the following scenario. Please state any assumptions you have madein your answer.A university offers a Mathematics program. This program can offer any amount ofcourses in a semester. Each course has a roster limit, location and time slot. A studentcan be registered for any number of courses in a semester but to register for a coursethey must have a valid student ID and address. Each course is assigned a singleprofessor. Only on completion of a course, a student receives a final grade for thatcourse.
1. Draw the context diagram or Level 0 DFD for the following case/scenario. “The purpose of the SALALAH acres real estate system is to assist agents as they sell houses.Sellers contact the agency, and an agent is assigned to help the seller complete a listing reqeuest.Information about the house and lot taken from that request is stored in a file. Personal informationabout the sellers is copied by the agent into a sellers file.When a buyer contacts the agency, he or she fills out a buyer request. Every two weeks, the agency sendsprospective buyers area real estate listings and an address cross reference listing containing actual streetaddresses. Periodically, the agent will find a particular house that satisfies most or all of a specificbuyer’s requirements, as indicated in the buyer’s requisrements statement distributed weekly to allagents. The agent will occasionally photocopy a picture of the house along with vital data and send themultiple listing statement to the potential…