A Travel Agency wanted to have a software system for the operation of the company. The requirements specifications are: The agency have cars, tempos, buses, and trucks operating with a set of drivers and cleaners. They take trips for individuals, team of people, touring passengers, couriers, and cargo delivery. These trips include travelling passenger from source city to designation city, as well as accommodation for the passengers in the hotels of the cities. The travel agency has a tie-up with hotels across the city. For cargo services, the driver and the courier persons will be offered services at the motels in the city. They have services in the entire country with the head-office at Chennai. The modules volved in this system are Query Tracking, Transport allocation, Trip Management, Transaction Management, Trip onfirmation and Closure. present the architecture design for the above system using pipes and filter and data repository style. Among the two tioned style which one will be more appropriate.

A Travel Agency wanted to have a software system for the operation of the company. The requirements specifications are: The agency have cars, tempos, buses, and trucks operating with a set of drivers and cleaners. They take trips for individuals, team of people, touring passengers, couriers, and cargo delivery. These trips include travelling passenger from source city to designation city, as well as accommodation for the passengers in the hotels of the cities. The travel agency has a tie-up with hotels across the city. For cargo services, the driver and the courier persons will be offered services at the motels in the city. They have services in the entire country with the head-office at Chennai. The modules volved in this system are Query Tracking, Transport allocation, Trip Management, Transaction Management, Trip onfirmation and Closure. present the architecture design for the above system using pipes and filter and data repository style. Among the two tioned style which one will be more appropriate.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

A project is proposed to design an assessment management system to keep track of course assessment submission in a university. Each course has unique ID, name, instructor, at least fifteen students and at least one subject. Each subject has a number, name, description, and at least one course assessment to be done. The subject number is unique for each course. Each assessment has a number that is unique for the given subject and has due submission date and time. In addition, each assessment has at least one given type (e.g. H: Homework, P: Program, E: Essay). Each submitted assessment is given a unique ID, has a submission timestamp (date and time) and belongs to one student only. Once an assessment is submitted, the system sends a message to the student acknowledging the submission and indicating whether the submission is on time or late. For each student, it is important to track the number of submission. Each student is identified by a unique ID, has a name, university-email, and…
A pharmaceutical company produces customized medical equipment for one-time usage in hospital surgeries. The CEO decided to provide an online business-to-business order platform for hospitals through the Web after being approached by two major hospitals. In the first phase of the iterative development project for the order platform, a set of requirements have been completed. The requirements engineer needs the agreements of the stakeholders to hand the requirements over to the development team for implementation. Validation is an iterative process. Therefore, the team is required to conduct another validation session after all the corrections (of the first validation) are made. However, if the team refuses to perform the second requirements validation due to time constraints, what do you think the possible risks that the team might face?
Develop a design class diagram and package diagram for a library system according to the given scenario. The library system provides users with the opportunity to borrow books from the library. The system includes a service page that displays all services such as borrowing and computer services. It also includes a catalog where all possible books are categorized. Users can communicate with the library via the details available on the contact page. The system allows only registered users to borrow books and the books are either hardcopy or e-books. To borrow a book the system will have to check for the eligibility of the user before approval. If the user is not eligible, then the request will be declined. Borrowing could be done via the library system or in person. The admin is responsible for the in-person borrowing. For the borrowing of any book, a form that is available on the forms page has to be filled by the user. Also, the system must check for the availability of a book before…
Computer Science Scenario: You are a Systems Auditor for Windhoek University, an institution that offers higher education to those who wish to further their studies after high school. The institution consists of a number of faculties such as Accounting, Hospitality and Agriculture to mention a few. Just like any compliant institution, Windhoek University is required to have annual IT audits of their infrastructure and operations. You are required to audit the IT infrastructure of the computer labs for the Faculty of Information Technology at the university. In preparation for this, you have been tasked to conduct an Audit Planning Process. In the process, you realise that the labs are freely accessible to anyone and the computers require no log in credentials to use them. Meanwhile, you discover that the university’s web server has been defaced and the students’ account are active and have administration rights on the systems. There has been a major configuration change to the web…
A pharmaceutical company produces customized medical equipment for one-time usage in hospital surgeries. The CEO decided to provide an online business-to-business order platform for hospitals through the Web after being approached by two major hospitals. In the first phase of the iterative development project for the order platform, a set of requirements have been completed. The requirements engineer needs the agreements of the stakeholders to hand the requirements over to the development team for implementation. During the validation process, the team discovers the following issues. Suggest corrective actions to each issue. 1. Unresolved conflicts in requirements. 2. Superfluous requirements 3. Contradictory requirements 4. Unrealistic requirements
A non-governmental organization aimed at rehabilitating street families in a local town in Kenya has been documenting their operations manually. Their system documents their staff records, individuals being rehabilitated and rehabilitation centers. A staff member is described by ID, name, gender, allowance and role. The individual to rehabilitate can be described by a unique number, name, age, gender and rehabilitation service(counselling, health care, nutrition, clothing, accommodation, training etc). Rehabilitation center described by center code and location. The management is in process of computerizing their information system. a) Draw a UML class diagram for this problem. b) Convert the class diagram in a) to C++ program. Your program should include use of important principles of object oriented systems such as encapsulation and inheritance
Develop an activity diagram based on the following narrative. Note any ambiguities or questions that you have as you develop the model. If you need to make assumptions, also note them. The purpose of the Open Access Insurance System is to provide automotive insurance to car owners. Initially, prospective customers fill out an insurance application, which provides information about the customer and his or her vehicles. This information is sent to an agent, who sends it to various insurance companies to get quotes for insurance. When the responses return, the agent then determines the best policy for the type and level of coverage desired and gives the customer a copy of the insurance policy proposal and quote.
Q3:Your company has just acquired a smaller company that sells office automation software. The smaller company's spreadsheet software has a large market share, with many satisfied users (the major reason for the acquisition was that these existing users are potential customers for your company's other products). Unfortunately, no documentation for the spreadsheet software can be found, and the source code is not commented. How would you go about maintaining this software to keep the customers happy?
Your in-house company has been selected for development a gym system, with manybranches, your team has many carried on meeting with the gym owners to define the mainrequirements and what they expected, and the main output from the system, the mainideas that’re discussed with the owners as follows,1. There are 7-12 trainers in two shifts for each branch.2. Each trainee has a unique ID that he can use to train in any branch.3. The branches should be connected and the ID is incremental.4. There are 4 programmes the trainee can follow based on what he needs. Buildmuscles, lose fat, or Increase the strength, the programmers as follows,a. Pro Split: train each muscle one time in a week.b. Upper and Lower: one training for the upper body, and next day for lowerbody.c. Push – Pull – Legs: this program me divide the body into 3 pieces, one dayfor push like chest and triceps, the next day is pull like back and biceps, andthe third day is for legs.d. Full Body Work Out: that’s balance between…
Your in-house company has been selected for development a gym system, with manybranches, your team has many carried on meeting with the gym owners to define the mainrequirements and what they expected, and the main output from the system, the mainideas that’re discussed with the owners as follows,1. There are 7-12 trainers in two shifts for each branch.2. Each trainee has a unique ID that he can use to train in any branch.3. The branches should be connected and the ID is incremental.4. There are 4 programmes the trainee can follow based on what he needs. Buildmuscles, lose fat, or Increase the strength, the programmers as follows,a. Pro Split: train each muscle one time in a week.b. Upper and Lower: one training for the upper body, and next day for lowerbody.c. Push – Pull – Legs: this program me divide the body into 3 pieces, one dayfor push like chest and triceps, the next day is pull like back and biceps, andthe third day is for legs.d. Full Body Work Out: that’s balance between…
You are asked to develop a library management information system Containing only the following information: Book information including Book number ,book name,author,price and publishing date. Reader information including library card number, reader name, gender, address, phone number. Book lending and returning information including lending date and return date. Draw a functional DFD based on the given information.
What precisely is an ADT, and how does it perform the duties that have been delegated to it?