Consider the following case study:A renowned restaurant chain wants to automate their business. The branches of restaurant arespread over different parts of the country. Currently each branch was being managed by adesktop based POS system, and the sales records were presented to the CEO at the end ofmonth in a meeting. Now the CEO of the company requires a system which can provide him dailysales reports of all branches through a centralized system.The each branch manager needs help to manage employees work shifts, inventory and stockmaintenance, order placement and sales record etc. The system will be installed on each branchand will be operated by the sales team. In order to keep their business running, the owners wantto implement the system gradually.The software development company has agreed to provide the solution as per terms. Softwaredevelopment team consists of 6 members and time to completion is 6 to 8 months.Which Process lifecycle model would you suggest and why?

Answered: Consider the following case study: A…

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Big Data

Section5.4: Big Data

Problem 2CTQ

See similar textbooks

Similar questions

For two SQL queries of the same complexity, one in a parallel database scenario and one in a distributed database scenario, which (if any) should take longer to optimize and why? The query would take longer to optimize on a distributed database. Because different machines have different performance power, network performance is likely to be slower and may vary across the system, and some data sources might only be accessible from certain machines. The query would take longer to optimize on a parallel database because each node is homogenous and connected to a large global storage system, which is inherently slow due to its size, and any complex query will take considerable time to process. It depends on how the query is written. There should not be a difference in the query processing time if the complexity of the queries is equivalent to each other.
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
Consider, for instance, the database used by a large airline that relies on snapshot isolation as the foundation for its data management. In order for an airline to be willing to accept a nonserializable execution in exchange for improved overall performance, what kinds of conditions would have to be met first?
Consider a school system in which data is recorded about the movie industry. The data requirements are summarized as follows: Each subject is owned by a department and each department ismanaged by a teacher, called Head of Department (HOD). Eachdepartment has a name and a unique code number. Each subjecthas a name, unique number and credit value. All teachers have aunique ID. A HOD cannot manage more than one department at atime. Also, a HOD does not teach subjects. A subject cannot betaught by more than one teacher. Finally, the system needs toknow each student’s contact details, including, full name, studentID, address, age and gender, as well as date of enrolment in thesubject. Design an Entity-Relationship diagram for the movie database
Develop an Entity-relationship diagram for a TCS parcel delivery company that uses system-wide information for all the parcels it delivers. All parcels are identified by their tracking number and are associated with different parameters including weight, dimension, destination, delivery date, sender, and receiver addresses. All items are received at various distribution centers across the country and are identified by their unique id, type, and their addresses. All parcels make their way to the destination via one or more standard transportation methods (i.e. flights, delivery trucks, motorcycles, these transportation methods are characterized by their unique type, id, and transportation identification number.
In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storagelocation and its capacity. Sometimes, a customer may need to come back to pickup their items afterchecking out while most of the time they leave the store with their purchases. Which of the following is thebetter design for manage transactions?A) Add an attriute to transaction to indicate whether goods have been pickuped or notB) Create two subtyeps of TransactionC) Create a weak entity Pickup to link with TransactionD) Add a relationship between Transaction and Product
How to answers below question for 'ATM Transaction' based on object oriented modeling: a. Case: part of that system will be modeled ?b. Specifications: concrete explanation about the flow to be modeled ?c. Identification of Actors/Roles ?d. Identify Paths (Alternative and Concurrent) ?e. Identify Node Objects ?f. Identify Exception Handling ?g. Final Charts ?
Make Activity Diagram draw from ATM Transaction with Type of Concurrent Paths: Parallelization Node & Synchronization Node? Draw answer based on object oriented modeling. Below is draw example!
1. PART (40%): Evaluation and optimization:A schema of the ski shop information system is given:Customer (cid, name, surname, address, telephone);Employee (eid, name, surname, address, telephone);Purchase (pid, sid, cid, eid, date);Skiis (sid, brand, model, length, hardness)Additional information is given:|Customer| =150 pages, 40 records/page|Employee| = 2 pages, 40 records/page|Purchase| = 2000 pages, 100 records/page|Skiis| = 250 pages, 30 records/pageBuffer can store up to 2500 pages.Let's assume that the following indices are now set on the schema from the previoustask:- Level 2 B+ index on the attribute Purchase.date- Hash index on the attribute Skiis.sidOur DBMS has the following algorithms to perform the join:- Hash join- Index nested loops join- Sort-merge joinTranslate the following SQL query into relational algebra and find the plan that readsthe fewest pages or blocks:SELECT Skiis.model, Skiis.lengthFROM Skiis JOIN Purchase ON (Skiis.sid = Purchase.sid)WHERE Skiis.brand =…
Draw an ER diagram using Cardinality Notation for the following description: A veterinary hospital only treats dogs and cats (use ISA). Clients have an address, phone number and client ID. Each pet has a name, a pet ID and belongs to exactly one client. Each client can have at most 5 cats and 2 dogs.
Using the system of Diagram ATM transaction, create diagrams for:1. Exchange data using the Control Buffer node object and data exchange using the Data Store node object?2. Multidimensional Partitions using Graphical and Textual Notation? The answers based on activity diagram on object oriented modeling knowledge!
(c). Explain why BACKWARD CHAINING is considered goal-driven and FORWARD CHAINING is considered data-driven.

Recommended textbooks for you

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning